Tom, The reason it is of importance to me/ecpg is for informix compatibility.
informix returns a unique errorcode for the copy operation when the file is not found. this isn't much of an argument from a postgres POV, however I still find the sqlstate to be ambiguous. Dave On Sun, 2003-08-24 at 16:46, Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> 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 > -- Dave Cramer <[EMAIL PROTECTED]> fastcrypt ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org