X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37423539C3 for ; Mon, 2 May 2005 22:16:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36692-02 for ; Tue, 3 May 2005 01:16:21 +0000 (GMT) Received: from fusion.bennyvision.com (fusion.bennyvision.com [71.32.179.125]) by svr1.postgresql.org (Postfix) with SMTP id 8761E53A48 for ; Mon, 2 May 2005 22:16:19 -0300 (ADT) Received: (qmail 29042 invoked by uid 1007); 3 May 2005 01:16:23 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 3 May 2005 01:16:22 -0000 Received: from 63.227.74.41 (SquirrelMail authenticated user benny) by webmail.stinkweasel.net with HTTP; Mon, 2 May 2005 20:16:22 -0500 (CDT) Message-ID: <53520.63.227.74.41.1115082982.squirrel@webmail.stinkweasel.net> Date: Mon, 2 May 2005 20:16:22 -0500 (CDT) Subject: Bad copy-n-paste on character conversion fix - how screwed am I? From: "C. Bensend" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.4 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200505/11 X-Sequence-Number: 17440 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"