Error codes from ODBC driver - Mailing list pgsql-odbc

From dirk.jacobs@tuple.be
Subject Error codes from ODBC driver
Date
Msg-id OFCFC49AB1.E0BE7C9C-ON41256B7B.005C3C56@tuple.be
Whole thread Raw
List pgsql-odbc

version 7.01.00.09

Hi there,

I want to detect if a table already exists or an index already exists but the driver always returns with SQLState S1000 which is a general error code.

The correct SQLstates are :

#define SQLSTATE_GENERAL_ERROR "S1000"


#define SQLSTATE_TABLE_EXISTS "S0001"
#define SQLSTATE_TABLE_NOT_FOUND "S0002"
#define SQLSTATE_INDEX_EXISTS "S0011"
#define SQLSTATE_INDEX_NOT_FOUND "S0012"

Any suggestions ?

-Dirk Jacobs

pgsql-odbc by date:

Previous
From: "Corey W. Gibbs"
Date:
Subject: Maybe more of a VB question, but here goes
Next
From: Wolfgang.Fuertbauer@ebewe.com
Date:
Subject: Re: Problem with VB-DirectODBC selecting