Sorry for the seemingly novice posting, but I could find a solution for this
on the web so far...
I've been developing a database using postgresql (and loving it) and have
started running into problems with attempting to update records using the
ODBC connection. The tables that contain geometric fields are causing the
problems. Whenever I try to update a record that contains a geometric field
(any field) I get the following error message:
ODBC -- update on a linked table 'public_locations' failed.
ERROR: invalid input syntax for type point: "(100),(100)" (#7)
When I attempt to update the record without the quotes, as if typing 100,100
in the point field, I get the error:
"record has been changed... blah, blah, blah..."
Is there some trick to being able to use the geometric data types if you're
going to interface with Access using the ODBC driver?
Jeff.
---
Jeff D. Hamann
Forest Informatics, Inc.
PO Box 1421
Corvallis, Oregon USA 97339-1421
541-754-1428
je*********@forestinformatics.com
www.forestinformatics.com