[ psqlodbc-Bugs-1000738 ] Wrong ODBC state (42P01 or 42P07) is returned on dropping/creating table

Bugs item #1000738, was opened at 2006-09-21 10:06
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 38&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Dmitriy Ivanov (divanov)
Assigned to: Nobody (None)
Summary: Wrong ODBC state (42P01 or 42P07) is returned on dropping/creating table

Initial Comment:
When DROP TABLE missing_table is executed, the driver returns error state 42P01 instead of 42S02.

When CREATE TABLE existing_table ... is executed, the driver returns error state 42P07 instead of 42S01.


------------------------------------------------------------ ----------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-09-21 12:03

Message:
The driver returns the error code just as it receives from the backends.

regards,
Hiroshi Inoue

------------------------------------------------------------ ----------

Comment By: Dmitriy Ivanov (divanov)
Date: 2006-09-21 10:15

Message:
I have forgotten to mention that the behavior is with the
ANSI driver 8.02.0100

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 38&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend