Help - Mailing list pgsql-admin

From Enzo Daddario
Subject Help
Date
Msg-id 1139107345.7202.8.camel@localhost.localdomain
Whole thread Raw
Responses Re: Help
List pgsql-admin
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...





pgsql-admin by date:

Previous
From: "Mohan Anon"
Date:
Subject: Postgres 8.1.x and MIT Kerberos 5
Next
From: Tom Lane
Date:
Subject: Re: Help