Re: Wrong SQLSTATE returned?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I'm using ADO to connect to my PostgreSQL instance. When I use a
> SELECT statement that references a non-existent column in an existing
> table I get a SQLSTATE error S1000 code with native error code 7.
> ...
> Am I not supposed to get a SQLSTATE code of: 42703 UNDEFINED COLUMN?

S1000 is a "generic error" that is returned when a driver (in Perl DBI
land anyway) does not implement SQLSTATE. That could certainly be the case
here. You could test to see if it ever returns anything except S1000:
if so, it's probably a bug in the driver. If not, someone may need to
write in full SQLSTATE support.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200506121500
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCrIgzvJuQZxSWSsgRAq7gAJ9P7W+RLp/JtdoO//s+egTtrN/DFQCg25Eb
NrR9EWd9t/kFJZC+9ObMzwY=
=KOv9
-----END PGP SIGNATURE-----