Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Ivan Sergio Borgonovo" <mail@xxxxxxxxxxxxxxx>
Subject: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
From: "Douglas McNaught" <doug@xxxxxxxxxxxx>
Date: Sun, 18 May 2008 12:50:16 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <20080518140456.0bd8a209@xxxxxxxxxxxxxxxxxxxx>

On Sun, May 18, 2008 at 8:04 AM, Ivan Sergio Borgonovo
<mail@xxxxxxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
  - From: Ivan Sergio Borgonovo
- Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
  - From: Andrew Sullivan
- Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
  - From: Ivan Sergio Borgonovo

Prev by Date: Re: tsearch2 on-demand dictionary loading & using functions in tsearch2
Next by Date: Re: tsearch2 on-demand dictionary loading & using functions in tsearch2
Previous by thread: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Next by thread: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux