Re: Questions about Rollback - after insert, update, - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Questions about Rollback - after insert, update,
Date
Msg-id 20050923143030.GE2298@wolff.to
Whole thread Raw
In response to Re: Questions about Rollback - after insert, update,  (Yonatan Ben-Nes <da@canaan.co.il>)
List pgsql-general
On Fri, Sep 23, 2005 at 13:19:34 +0200,
  Yonatan Ben-Nes <da@canaan.co.il> wrote:
>
> You can add to that list the command TRUNCATE though it can be rollback
> its not useful in cases where the truncated data should continue to be
> accessed till the transaction be commited.

I think that is a different issue. This is a problem in that truncate takes
an exclusive lock on the table which might block other things going on
in the database. It could still be useful to rollback a table truncated
in error.

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: COPY - permission denied
Next
From: Tom Lane
Date:
Subject: Re: COPY - permission denied