Home > mailing lists

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

From	Abdul Rahman
Subject	Re: Rollback of Query Cancellation
Date	January 28, 2009 05:09:32
Msg-id	463367.64064.qm@web65716.mail.ac4.yahoo.com Whole thread Raw
In response to	Rollback of Query Cancellation (Abdul Rahman <abr_ora@yahoo.com>)
Responses	Re: Rollback of Query Cancellation
List	pgsql-general

Thanks Justin,

Answers of your technical questions are as under:

What does the sql statement look like?

delete from ci_cif_v where req_id='0824100207';

Where was the statement run?

On SQL pan of pgAdmin-III

How was the statement killed?

By clicking the Cancel Query button ->

What do the logs show?

Message just showed the time it took to delete certain number of records.

From: justin
Date: 28 January 2009, 04:39:01
Subject: Re: Rollback of Query Cancellation

From: Jaime Casanova
Date: 28 January 2009, 05:13:24
Subject: Re: Rollback of Query Cancellation