Re: [GENERAL] UPDATE after Cancle

2010-06-23 Thread Joshua D. Drake
On Wed, 2010-06-23 at 13:05 -0700, David Kerr wrote: > 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'; > > > > > Cancel request

[GENERAL] UPDATE after Cancle

2010-06-23 Thread David Kerr
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'; Cancel request sent UPDATE 8231584 I checked and the updated did happen. autocommit is on, an