| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dave Stewart <dstewart(at)aquaflo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Option 'xactisolevel' is not recognized (???) |
| Date: | 2003-01-02 22:35:58 |
| Message-ID: | 4611.1041546958@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Dave Stewart <dstewart(at)aquaflo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ville Jungman | 2003-01-03 06:24:20 | How to determine the type of a column |
| Previous Message | Dave Stewart | 2003-01-02 22:10:10 | Option 'xactisolevel' is not recognized (???) |