Re: Rollback of Query Cancellation

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Rollback of Query Cancellation
Date: 2009-01-28 07:53:00
Message-ID: glp2sv$7ji$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Abdul Rahman wrote:
> Very nice!
> Most probably it was waiting for something else. This is the reason the
> query executed today and clearly showed certain number of rows deleted.
> But what ELSE?
>
It could be a ton of things, but as an example, if you have a cursor
open on a row that your query wants to delete.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkmADtsACgkQjDX6szCBa+onTQCgoEKG1CsZXfmmYLBW29gvHoOb
kv8AoNzW1MHOUuPM0bOISTn/ppnuuyXM
=CFb7
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Rahman 2009-01-28 07:58:12 Re: Rollback of Query Cancellation
Previous Message Hermann Muster 2009-01-28 07:52:43 Feature request dblink: Security issue - dblink user+password parameters must be optional