From: C. Bensend <benny@bennyvision.com>
To: pgsql-admin@postgresql.org
Subject: Bad copy-n-paste on character conversion fix - how screwed am I?
Date: Mon, 2 May 2005 20:16:22 -0500 (CDT)
Message-ID: <53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net> (raw)
Hey folks,
I just had a copy-n-paste mishap on one of my databases, while
fixing the character conversion problem.
The following erroneous command was entered:
UPDATE pg_proc SET proacl = '{=}'
;
.. instead of the correct one (missing the WHERE clause). It
updated 1747 rows - oh crap.
This is 8.0.2 running on OpenBSD 3.5-STABLE. Is there a way to
fix what I've just borked? I'm not even real sure what damage I've
just done...
Any help would be appreciated. :)
Benny
--
"You come from a long line of scary women." -- Ranger, "Three To
Get Deadly"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: benny@bennyvision.com
Subject: Re: Bad copy-n-paste on character conversion fix - how screwed am I?
In-Reply-To: <53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net>
References: <53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox