XactIsoLevel handling - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject XactIsoLevel handling
Date
Msg-id Pine.OSF.4.58.0405181615180.368774@kosh.hut.fi
Whole thread Raw
Responses Re: XactIsoLevel handling  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
In tcop/utility.c, the isolation level is set with a call like:

SetPGVariable("transaction_isolation", makeList(item->arg), false)

when a BEGIN SERIALIZABLE etc. call is made.

Why is the isLocal-parameter false? Couldn't it be true as well? It works
as it is, since the XactIsoLevel variable is reset to default value in
StartTransaction anyway, but it looks silly to me to define the variable
as a session variable when in fact it acts like a local one.

I bumped into this because my current 2PC doesn't allow you to set session
variables. I modified the above line, and BEGIN SERIALIZABLE seems to
work fine now with 2PC.

- Heikki



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: add server include files to default installation?
Next
From: Jan Wieck
Date:
Subject: Re: Relocatable installs