PostgeSQL ODBC - another wrong error message returned: INSERT with missing field

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

another wrong error message returned: INSERT with missing field

me@alternize.com

2005-11-15, 8:23 pm

hi list.

i'm not sure if this was reported before (there was an error message related
conversation earlier):

when executing an malformed INSERT statement (which for example contains
some invalid fields), the odbc driver returns:

ERROR: current transaction is aborted, commands ignored until end of
transaction block

instead of the verbose error message you'll see when you execute the query
on the psql command line:

ERROR: column "somefield" of relation "sometable" does not exist.

cheers,
thomas

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links