UPDATE after Cancle

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: UPDATE after Cancle
Date: 2010-06-23 20:05:06
Message-ID: 20100623200506.GF90301@mr-paradox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy all -

I just got this odd behavior in my system.

This is PG 8.3.10 on RedHat 5.4

psql bla
bla=# update blatab set blafield = replace(blafield,'XXX-1','XXX1-')
where created_by = 'blauser';

<runs for a while>
<dave hit's ctl-c becuase i messed up the substitution value >

Cancel request sent
UPDATE 8231584

I checked and the updated did happen.

autocommit is on, and i wasn't in a TX or anything strange like that.

My guess is that i hit ctl-c during the commit of the data and it wasn't
able to rollback.

Any idea if that's the case? and if so, is that expected?

Thanks

Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-06-23 20:29:39 Re: UPDATE after Cancle
Previous Message Merlin Moncure 2010-06-23 19:58:21 Re: Problem Using RowType Declaration with Table Domains