I've had a couple issues with the ODBC driver that ships with Postgres. I am using Access 2000 to link tables Postgres.
Of the two issues, one is small: after I enabled row version in the ODBC driver - to fix a problem updating certain tables - the column xmin began appearing in all the linked tables. Is there any to prevent xmin from appearing but still use the Enable Row Version option in ODBC DSN?
The second is a bigger deal. On certain forms, any time an update occurs, I get a message that text that was destined for a text type (i.e., unlimited varchar) field has been wrongfully interpreted as part of the SQL statement. Say if I had written
'This test string will be inserted into the text field'
I frequently get back error 'the relation "test" does not exist'. I was able to resolve this issue on some workstations by vastly increasing the cache size, from 100 to ~10000. Is this a good idea at all? And it still does not resolve the problem on one particular machine, where the user happens to write several fields of text of about 400-800 characters?
Does anyone have any ideas on how to address this? Advice would be much appreciated.
Many thanks,
Eric
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
