Postgres Pro
Downloads
Home   >   mailing lists

Thread: error code 25001

error code 25001

From
Tatsuo Ishii
Date:
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

Re: error code 25001

From
Tom Lane
Date:
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