error code 25001

Started by Tatsuo Ishiiabout 17 years ago2 messages
#1Tatsuo Ishii
ishii@postgresql.org

Error code 25001 is used for "SET TRANSACTION ISOLATION LEVEL must be
called before any query" when it's an ERROR. However, it also means
"there is already a transaction in progress" when it's a NOTICE.

So we cannot distinguish them just by checking the error code.

So my question is, an error code is used for both an error condition
*and* a warning: is this normal?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tatsuo Ishii (#1)
Re: error code 25001

Tatsuo Ishii <ishii@postgresql.org> writes:

Error code 25001 is used for "SET TRANSACTION ISOLATION LEVEL must be
called before any query" when it's an ERROR. However, it also means
"there is already a transaction in progress" when it's a NOTICE.

So we cannot distinguish them just by checking the error code.

So my question is, an error code is used for both an error condition
*and* a warning: is this normal?

I don't think that's the only case. Surely it's not that hard to tell
whether you have an error or not ...

regards, tom lane