Skip site navigation (1) Skip section navigation (2)

Re: Database Integrity

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Database Integrity
Date: 2011-11-18 19:48:57
Message-ID: 20111118204857.2ee4d927@anubis.defcon1 (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-novice
On Fri, 18 Nov 2011 20:44:33 +0100
"Jean-Yves F. Barbier" <12ukwn(at)gmail(dot)com> wrote:

> 
> AFAIK no because even if you're not in your transaction, Pg opens its own (hence
> rollback if something bad happens).
 
Oops: forgot to say that in this case, you'll loose the concurrency you
could have with SET TRANSACTION SERIALIZABLE, which is bad if there are
many concurrent DELETEs & users making them.

-- 
Evening hours "all clear" for romance!
(Tell mate you have to work late.)

In response to

pgsql-novice by date

Next:From: Jane GeeringDate: 2011-11-18 23:27:18
Subject: Access to pg_hba.conf
Previous:From: Daniel StaalDate: 2011-11-18 19:46:48
Subject: Re: Database Integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group