Re: ambiguous sql states - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ambiguous sql states
Date
Msg-id 28272.1061758000@sss.pgh.pa.us
Whole thread Raw
In response to Re: ambiguous sql states  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: ambiguous sql states
Re: ambiguous sql states
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Dave Cramer writes:
>> I'm working on identifying various errors in ecpg using sql state and
>> one which is particularly ambiguous is ERRCODE_UNDEFINED_OBJECT for a
>> file which isn't found. This is returned in a number of places. Is it
>> possible to get a set of file specific error codes?

> That error code if for undefined objects, not files that can't be found.

Dave's correct, that's what we're currently using.  I'm happy to change
it if someone can suggest an appropriate SQLSTATE (even a category...)
to use instead.

I would however like to know why ecpg cares.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Collation rules and multi-lingual databases
Next
From: Jason Tishler
Date:
Subject: Re: PostgreSQL 7.4 Beta 1 + SSL + Cygwin