[udig-devel] 1.1.RC1 testing

[Michael Brasser]

Jesse,

It looks like at least part of the problem was with my tables -- the sequences and tables were out of sync, for some reason. That said, 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???

Michael

Jesse Eichar wrote:

>Hmmm.  I've noticed that postgis does need some more debugging. :- 
>(  I'm going to try to find some time to work on this this week.  It  
>is critical to our story.
>
>Thanks Michael.
>
>Jesse
>
>On 6-Jun-06, at 12:14 AM, Michael Brasser wrote:
>
>> Only one major problem that I've come across...I am unable to add  
>> features to a PostGIS database using 1.1.RC1:
>>...
>> Regards,
>> Michael