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 B619753AF4 for ; Mon, 2 May 2005 22:47:38 -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 39963-07 for ; Tue, 3 May 2005 01:47:37 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3E46F53AE8 for ; Mon, 2 May 2005 22:47:36 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j431ldIH004472; Mon, 2 May 2005 21:47:39 -0400 (EDT) To: "C. Bensend" Cc: pgsql-admin@postgresql.org 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> Comments: In-reply-to "C. Bensend" message dated "Mon, 02 May 2005 20:16:22 -0500" Date: Mon, 02 May 2005 21:47:39 -0400 Message-ID: <4471.1115084859@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/12 X-Sequence-Number: 17441 "C. Bensend" 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