Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Date: 2008-05-18 16:50:16
Message-ID: 5ded07e00805180950k1e98fe67r58209fb8d6f5f2e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, May 18, 2008 at 8:04 AM, Ivan Sergio Borgonovo
<mail(at)webthatworks(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-18 16:56:14 Re: tsearch2 on-demand dictionary loading & using functions in tsearch2
Previous Message Tom Lane 2008-05-18 16:42:20 Re: Postgresql service stops every few minutes on Vista Biz