Postgres Pro
Downloads
Home   >   mailing lists

Re: autocommit vs TRUNCATE et al - Mailing list pgsql-hackers

From Gavin Sherry
Subject Re: autocommit vs TRUNCATE et al
Date
Msg-id Pine.LNX.4.21.0210191200050.6080-100000@linuxworld.com.au
Whole thread Raw
In response to autocommit vs TRUNCATE et al  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: autocommit vs TRUNCATE et al  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Fri, 18 Oct 2002, Tom Lane wrote:

> Anyone see a way out of this catch-22?  If not, which is the least
> bad alternative?

Ultimately, fix TRUNCATE to be transaction safe. This is non-trivial,
I know :-).

Regardless, the first option seems the less of the two evils.

Gavin

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: autocommit vs TRUNCATE et al
Next
From: Mike Mascari
Date:
Subject: Re: autocommit vs TRUNCATE et al