Re: BUG #5246: Misleading/inconsistent SQLSTATE behavior

Chris Travers <chris@metatrontech.com> writes:
> It looks like this could be added without a disruption to programmer
> interfaces, but it seems like any major change in this area would
> create binary compatibility issues (i.e. require recompile of linked
> software).  Is this correct in what you mean by API  incompatibility?

No, I'm concerned about the programmer interface at the moment.  What
have you got in mind?

> ... The problem I was running into is that if the
> user enters a non-existant database, the program would prompt for
> username/password instead of letting them know the database was wrong.
> My workaround at the moment is to check the error message against a
> configurable value to see if it represents a missing database.  It
> sucks because it means that foreign locale users must go through extra
> configuration steps.  If I had the SQLSTATE data it would  be easy to
> set up so that wouldn't be needed.

We do have a workaround for distinguishing "password required" from
other errors without any locale-specific tests.  It is surely a crock,
but you'd want to use that in the near term anyway.  Any real fix here
could not appear before 8.5 at the earliest.

            regards, tom lane