X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 49AE89DCAB8 for ; Sat, 4 Feb 2006 23:14:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07665-08 for ; Sat, 4 Feb 2006 23:14:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id DBCFA9DCA87 for ; Sat, 4 Feb 2006 23:14:46 -0400 (AST) 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 k153EkYP007439; Sat, 4 Feb 2006 22:14:46 -0500 (EST) To: Enzo Daddario cc: PGADMIN Subject: Re: Help In-reply-to: <1139107345.7202.8.camel@localhost.localdomain> References: <1139107345.7202.8.camel@localhost.localdomain> Comments: In-reply-to Enzo Daddario message dated "Sun, 05 Feb 2006 10:42:25 +0800" Date: Sat, 04 Feb 2006 22:14:46 -0500 Message-ID: <7438.1139109286@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200602/41 X-Sequence-Number: 20462 Enzo Daddario writes: > I have just installed postgres 8.1.2 (upgrading from 7.4.2) and upon > commencement of populating DBs with data dumped using pg_dumpall(7.4.2) > I receive the following error: > DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database > WHERE datname = 'template0'); > ERROR: cannot delete from a view > HINT: You need an unconditional ON DELETE DO INSTEAD rule. > DELETE FROM pg_group; > ERROR: cannot delete from a view > HINT: You need an unconditional ON DELETE DO INSTEAD rule. These are to be expected if you try to restore a dump made with an old version of pg_dumpall. If you don't see any other problems, just ignore 'em. BTW, it's usually best to try to make the dump with the newer version of pg_dump/pg_dumpall. This can be a pain in the neck though if you are using a packaging system that wants to update all the PG executables at the same time :-( regards, tom lane