pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTransaction isolation level for plpgsql
3+ messages / 3 participants
[nested] [flat]
* Transaction isolation level for plpgsql
@ 2000-09-30 02:32 Keith Wong <keith@e-magine.com.au>
2000-09-30 10:56 ` Re: Transaction isolation level for plpgsql Peter Eisentraut <peter_e@gmx.net>
2000-09-30 11:08 ` Re: Transaction isolation level for plpgsql Poul L. Christiansen <poulc@cs.auc.dk>
0 siblings, 2 replies; 3+ messages in thread
From: Keith Wong @ 2000-09-30 02:32 UTC (permalink / raw)
To: pgsql-sql
Hi all,
Does anybody know the transaction isolation level default when a plpgsql
stored procedure is called?
Is it possible to set it? Or is this controlled by SPI?
Cheers,
Keith.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Transaction isolation level for plpgsql
2000-09-30 02:32 Transaction isolation level for plpgsql Keith Wong <keith@e-magine.com.au>
@ 2000-09-30 10:56 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2000-09-30 10:56 UTC (permalink / raw)
To: Keith Wong <keith@e-magine.com.au>; +Cc: pgsql-sql
Keith Wong writes:
> Does anybody know the transaction isolation level default when a plpgsql
> stored procedure is called?
> Is it possible to set it? Or is this controlled by SPI?
It's whatever the transaction that called the function was set to.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Transaction isolation level for plpgsql
2000-09-30 02:32 Transaction isolation level for plpgsql Keith Wong <keith@e-magine.com.au>
@ 2000-09-30 11:08 ` Poul L. Christiansen <poulc@cs.auc.dk>
1 sibling, 0 replies; 3+ messages in thread
From: Poul L. Christiansen @ 2000-09-30 11:08 UTC (permalink / raw)
To: pgsql-sql; +Cc: Keith Wong <keith@e-magine.com.au>
Use the command "\h set" and you'll see the parameters.
test=# \h set
Command: SET
Description: Set run-time parameters for session
Syntax:
SET variable { TO | = } { value | 'value' | DEFAULT }
SET CONSTRAINTS {ALL | constraintlist} mode
SET TIME ZONE { 'timezone' | LOCAL | DEFAULT }
SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
test=# show transaction isolation level;
NOTICE: TRANSACTION ISOLATION LEVEL is READ COMMITTED
SHOW VARIABLE
test=#
HTH,
Poul L. Christiansen
Keith Wong wrote:
>
> Hi all,
>
> Does anybody know the transaction isolation level default when a plpgsql
> stored procedure is called?
> Is it possible to set it? Or is this controlled by SPI?
>
> Cheers,
> Keith.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-09-30 11:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-30 02:32 Transaction isolation level for plpgsql Keith Wong <keith@e-magine.com.au>
2000-09-30 10:56 ` Peter Eisentraut <peter_e@gmx.net>
2000-09-30 11:08 ` Poul L. Christiansen <poulc@cs.auc.dk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox