From: Tom Lane <tgl@sss.pgh.pa.us>
To: Enzo Daddario <enzo@pienetworks.com>
Cc: PGADMIN <pgsql-admin@postgresql.org>
Subject: Re: Help
Date: Sat, 04 Feb 2006 22:14:46 -0500
Message-ID: <7438.1139109286@sss.pgh.pa.us> (raw)
In-Reply-To: <1139107345.7202.8.camel@localhost.localdomain>
References: <1139107345.7202.8.camel@localhost.localdomain>
Enzo Daddario <enzo@pienetworks.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, enzo@pienetworks.com
Subject: Re: Help
In-Reply-To: <7438.1139109286@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox