From: | "Andy Hallam" <ahm(at)exel(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ODBC and Native error codes |
Date: | 2001-11-06 15:38:22 |
Message-ID: | 9s907v$db1$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
PostgreSQL - 7.1.3 (installed on Linux 2.4.2-2)
PSQLODBC.DLL - 07.01.0007
Visual C++ - 6.0
PostgreSQL does not return the standard ANSI Native SQL number through
SQLGetDiagRec().
I.e
1) - Select from a table that does not exist.
ANSI Native sql code is -208
SQL SERVER returns -208
DB2 returns -204
ORACLE returns -942
PostgreSQL returns -7
2) - Select a column that does not exist on a valid table.
ANSI Native sql code is -207
SQL SERVER returns -207
DB2 returns -206
ORACLE returns -904
PostgreSQL returns -7
3) - Referential integrity violated.
-547 = Reference or constraint violated
-2627 = Primary key violated
-2601 = Duplicate key row
PostgreSQL returns -7 for all the above scenarios ?
Infact, PostgreSQL only ever return -7 !!!
OK - PostgreSQL (Like all the other Database vendors above) does return an
informative string, but it should also return the correct Native ANSI SQL
number.
Anyone know of a way to retreive this Native SQL number?
Andy
ahm(at)exel(dot)co(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2001-11-06 15:38:46 | Re: Equate for "describe table" ? |
Previous Message | Alvaro Herrera | 2001-11-06 15:13:34 | Re: data integrity |
From | Date | Subject | |
---|---|---|---|
Next Message | Alan R. Johns | 2001-11-06 17:27:02 | Access 2000 & Views |
Previous Message | Hiroshi Inoue | 2001-11-06 10:55:55 | Re: Weird problem with aggregate functions |