From: Tom Lane <tgl@sss.pgh.pa.us>
To: C. Bensend <benny@bennyvision.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Bad copy-n-paste on character conversion fix - how screwed am I?
Date: Mon, 02 May 2005 21:47:39 -0400
Message-ID: <4471.1115084859@sss.pgh.pa.us> (raw)
In-Reply-To: <53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net>
References: <53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net>
"C. Bensend" <benny@bennyvision.com> writes:
> 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.
Always a good idea to do this kind of thing inside a BEGIN block ;-)
As far as the system functions are concerned, you can just set the
proacl column to NULL (ie, default) and that'll be fine for everything
except the character conversion functions.
As far as user-defined functions are concerned, NULL probably works for
most of them too, but you would want to consult a recent backup to see
if any were not like that.
regards, tom lane
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: tgl@sss.pgh.pa.us, benny@bennyvision.com
Subject: Re: Bad copy-n-paste on character conversion fix - how screwed am I?
In-Reply-To: <4471.1115084859@sss.pgh.pa.us>
References: <53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net> <4471.1115084859@sss.pgh.pa.us>
* 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