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

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Date: 2008-05-20 15:43:07
Message-ID: 20080520154307.GF56707@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, May 18, 2008 at 02:04:56PM +0200, Ivan Sergio Borgonovo wrote:

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

You can't do that. You have to declare SERIALIZABLE right at the
beginning of the transaction, or it won't work (and, IIRC, it throws
an error). That means _before_ you call the first function (since
calling the function is then the first statement in the transaction,
before serializable).

A

--
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Joo 2008-05-20 15:50:16 Re: psql: FATAL: Ident authentication failed for user"postgres"
Previous Message Dan Joo 2008-05-20 15:24:30 Re: psql: FATAL: Ident authentication failed for user "postgres"