Re: Option 'xactisolevel' is not recognized (???) - Mailing list pgsql-novice

From Tom Lane
Subject Re: Option 'xactisolevel' is not recognized (???)
Date
Msg-id 4611.1041546958@sss.pgh.pa.us
Whole thread Raw
In response to Option 'xactisolevel' is not recognized (???)  (Dave Stewart <dstewart@aquaflo.com>)
List pgsql-novice
Dave Stewart <dstewart@aquaflo.com> writes:
> Both EOModeler AND Postgresql claim "Option xactisolevel is not
> recognized". No duh ... what in the flaming pits of hades is that?

Hm.  XactIsoLevel is the internal variable that's set by the
SET TRANSACTION ISOLATION LEVEL command.  I think it used to be
possible to set it using its internal name (goes off and experiments
... yes, that seems to work in releases before 7.3).

What you've got there is an app or client library that uses the
unportable, undocumented, and now unsupported syntax "set XactIsoLevel
to something" instead of the SQL-spec syntax "set transaction isolation
level something".  Time to fix it...

            regards, tom lane

pgsql-novice by date:

Previous
From: Dave Stewart
Date:
Subject: Option 'xactisolevel' is not recognized (???)
Next
From: "Ville Jungman"
Date:
Subject: How to determine the type of a column