Обсуждение: error code 25001

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

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