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