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