Can't change the contents of a field - Mailing list pgsql-general

From Steve Quezadas
Subject Can't change the contents of a field
Date
Msg-id 00bb01c02a58$1e8b53f0$7801a8c0@steve
Whole thread Raw
List pgsql-general
This is weird. I can change the contents of a field in the psql command prompt, but I can't do it in Microsoft Access via ODBC. Everytime I try to change a field in Microsoft Access, it first says: "ODBC--update on a linked table 'test' failed". Then it goes on to say:
 
"Error while executing the query; ERROR: Unable to identify an operating '=' for types 'xid' and 'int4'. You will have to retype this query using an explicit cast. (#1)".
 
Does anyone know why I can't change the field? I turned off the "read only" property. I am using Postgres 7.02 with the new 6.5 version of the ODBC drive (psotdrv.exe)
- Steve

pgsql-general by date:

Previous
From: "Steve Quezadas"
Date:
Subject: Getting "#Name?" in Microsoft access ODBC
Next
From: "Steve Quezadas"
Date:
Subject: Dropping a field from a table.