Re: SQLState

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Mahesh Swamy" <maheshs(at)fast(dot)fujitsu(dot)com(dot)au>, "osspatches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: SQLState
Date: 2004-05-12 14:37:48
Message-ID: 200405121637.48177.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Am Mittwoch, 12. Mai 2004 04:07 schrieb Mahesh Swamy:
> 2/ If there is no convention is it ok to use the letter 'x' for all our
> State codes? eg. if we want to add a state under the "53" class, we would
> use "53x001", "53x002" and so on.

That doesn't work, because sqlstate values have to be exactly 5 characters.

In addition to the conventions that you were already told, classes starting
with Y are reserved for PostgreSQL clients.

In response to

  • SQLState at 2004-05-12 02:07:50 from Mahesh Swamy

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2004-05-12 15:01:33 Re: mingw configure failure detection
Previous Message Mahesh Swamy 2004-05-12 04:55:53 Re: SQLState