Re: Database Integrity - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: Database Integrity
Date
Msg-id 20111118204857.2ee4d927@anubis.defcon1
Whole thread Raw
In response to Re: Database Integrity  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
List pgsql-novice
On Fri, 18 Nov 2011 20:44:33 +0100
"Jean-Yves F. Barbier" <12ukwn@gmail.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.)

pgsql-novice by date:

Previous
From: "Daniel Staal"
Date:
Subject: Re: Database Integrity
Next
From: Jane Geering
Date:
Subject: Access to pg_hba.conf