Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 20 May 2008 11:43:07 -0400
- Message-id: <20080520154307(dot)GF56707(at)commandprompt(dot)com>
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/
- 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
- Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
- Prev by Date: Re: psql: FATAL: Ident authentication failed for user "postgres"
- Next by Date: Re: psql: FATAL: Ident authentication failed for user "postgres"
- 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"
- Indexes: