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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
