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 C04CD9DC98B for ; Sat, 4 Feb 2006 22:38:12 -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 00489-04 for ; Sat, 4 Feb 2006 22:38:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.pienetworks.com (unknown [210.9.196.17]) by postgresql.org (Postfix) with ESMTP id 35BE69DC9F8 for ; Sat, 4 Feb 2006 22:38:09 -0400 (AST) Received: by mail.pienetworks.com (Postfix, from userid 521) id DCBBD4D336E; Sun, 5 Feb 2006 10:38:08 +0800 (WST) Received: from tuppy.pienetworks.com (tuppy.pienetworks.com [192.168.1.72]) by mail.pienetworks.com (Postfix) with ESMTP id E20A54D336E for ; Sun, 5 Feb 2006 10:38:06 +0800 (WST) Subject: Help From: Enzo Daddario To: PGADMIN Content-Type: text/plain Date: Sun, 05 Feb 2006 10:42:25 +0800 Message-Id: <1139107345.7202.8.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/40 X-Sequence-Number: 20461 Hi All, 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. The DBs were created etc and everything seems to be progressing as expected. Are the above errors critical or of any major concern or can they be ignored??? Thanks ENZO...