Postgis NG serial sequence autodetection breaks on tables whose name need to be 
escaped
---------------------------------------------------------------------------------------

                 Key: GEOT-2500
                 URL: http://jira.codehaus.org/browse/GEOT-2500
             Project: GeoTools
          Issue Type: Bug
          Components: data jdbc-ng
    Affects Versions: 2.6-M1
            Reporter: Andrea Aime
            Assignee: Andrea Aime
             Fix For: 2.6-M2


This happens because of an oddity in pg_get_serial_sequence, the first argument 
need to be escaped even in string form (the table name) but the column name 
does not, for example, this will work:
SELECT pg_get_serial_sequence('"seq"', 'key');
But those won't:
SELECT pg_get_serial_sequence('seq', 'key');
SELECT pg_get_serial_sequence('"seq"', '"key"');


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com 
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to