"Jeff D. Hamann" <jeff.hamann@xxxxxxxxxxxxxxxxxxxxx> wrote in message news:TcudneZxRZ6qhG3fRVn-gQ@xxxxxxxxxxxxxxxxxx > 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..." You mean the old "record has been changed by another user"? If so, try setting the "row versioning" driver option to true. > > 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 > jeff.hamann@xxxxxxxxxxxxxxxxxxxxx > www.forestinformatics.com > > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
