Re: Bad copy-n-paste on character conversion fix - how

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Bad copy-n-paste on character conversion fix - how
Date: 2005-05-03 03:48:50
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

"C. Bensend" <benny(at)bennyvision(dot)com> writes:
> So, just to be sure:

> 1) Start a %(&@#*(&% transaction
> 2) Set the column to NULL for all rows, undoing my stupidity
> 3) Issue the CORRECT SQL statement, and that will take care of the
> character conversion problem
> 4) COMMIT said transaction after verifying that I'm not doing
> something stupid _again_

> Is this correct?


All this thrashing will have bloated pg_proc a bit (like a factor of
three...) so you might want to do a "VACUUM FULL pg_proc" after the dust
has settled. But that's a bit on the anal-retentive side considering
that pg_proc isn't really all that big. I offer it up merely for
educational purposes.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Sitompul 2005-05-03 08:00:52 How the query please!
Previous Message Tatsuo Ishii 2005-05-03 03:08:58 Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems