Bad copy-n-paste on character conversion fix - how screwed am I?

Поиск
Список
Период
Сортировка
От C. Bensend
Тема Bad copy-n-paste on character conversion fix - how screwed am I?
Дата
Msg-id 53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net
обсуждение исходный текст
Ответы Re: Bad copy-n-paste on character conversion fix - how screwed am I?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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"


В списке pgsql-admin по дате отправления:

Предыдущее
От: Thomas F.O'Connell
Дата:
Сообщение: Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems found
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bad copy-n-paste on character conversion fix - how screwed am I?