[udig-devel] 1.1.RC1 testing

Cory Horner chorner at refractions.net
Wed Jun 7 09:07:04 PDT 2006


Michael Brasser wrote:

>...I've also been able to solve at least one PostGIS problem by changing line 34 of PostGISAutoIncrementFIDMapper, from:
>     statement.execute("SELECT currval(pg_get_serial_sequence("+tableName+","+colName+"))");
>to
>     statement.execute("SELECT currval(pg_get_serial_sequence(\'"+tableName+"\',\'"+colName+"\'))");
>
>i.e. it seems like the table name and column name need to be in single quotes to work correctly???
>  
>
You're right, this would be a problem if the table name or column names 
contain uppercase characters.

Cory.


More information about the udig-devel mailing list