Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot" - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Date
Msg-id 5ded07e00805180950k1e98fe67r58209fb8d6f5f2e@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view 
On Sun, May 18, 2008 at 8:04 AM, Ivan Sergio Borgonovo
<mail@webthatworks.it> wrote:

> What is the effect of having nested functions all declared
> SERIALIZABLE?
>
> What if just the outermost is declared SERIALIZABLE?

SERIALIZABLE applies to the entire transaction, not to individual
function calls.

-Doug

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: tsearch2 on-demand dictionary loading & using functions in tsearch2
Next
From: Craig Ringer
Date:
Subject: Re: tsearch2 on-demand dictionary loading & using functions in tsearch2