[postgis-users] PostGIS ODBC Connection

Sean seanasy at gmail.com
Thu Mar 10 12:49:42 PST 2011

It has to do with how the ODBC driver tries to update the record.  It
creates a where clause for every field in the row. The value it
compares to the geometry field is not valid.

In the psqlODBC driver you can enable the option 'Row Versioning'
which will cause the driver to update with a where clause based only
on the primary key and any field with a unique constraint.

The setting is buried in:

Settings > Control Panel > Administrative Tools > Data Sources (ODBC)
> File DSN > "your database dsn" > Configure > Connection > Page 2


On Mar 10, 6:12 am, "Robin Stockman" <uk52... at yahoo.co.uk> wrote:
> Hi All,
> I have tried many searches to find a solution to this problem, but
> unfortunately I am no further forward.
> I have an installation of PostgreSQL and PostGIS (latest stable versions) on
> a server, with which QGIS works fine. However, I installed the PostgreSQL
> 35W ODBC driver on a windows PC, as I wanted to create an access database
> with a linked table to the PostGIS database.
> Whilst the data from the PostGIS linked table is displayed without any
> problems, if I change any value in any field I get the error:
> "ODBC-update on a linked table 'public_shapefile1' failed.
> ERROR: parse error - invalid geometry;
> Error while executing the query (#7)"
> Does anyone know why this is happening? I have not touched "the_geom" field
> at all..
> Many thanks,
> Rob
> _______________________________________________
> postgis-users mailing list
> postgis-us... at postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list