Re: Rollback of Query Cancellation - Mailing list pgsql-general

From Jasen Betts
Subject Re: Rollback of Query Cancellation
Date
Msg-id gm31uq$vkk$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Rollback of Query Cancellation  (Abdul Rahman <abr_ora@yahoo.com>)
List pgsql-general
On 2009-01-28, Abdul Rahman <abr_ora@yahoo.com> wrote:
> --0-2110834523-1233119974=:72728
> Content-Type: text/plain; charset=us-ascii
>
> Dear All,
>
> Yesterday I canceled a running query because it was taking long time
> (more than 12 minutes) to delete lots of records. Today when I
> executed the same query it hardly took few seconds to finish. It
> clearly explores that PostgreSQL does not perform rollback action.
> Is it true?

it's true, but that's not proof. (the delete could have got held up by
a lock yesterday)


pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: how to implement a foreign key type constraint against a not unique column
Next
From: Jasen Betts
Date:
Subject: Re: ALTER TABLE with TYPE serial does not work