Help

From: Enzo Daddario <enzo(at)pienetworks(dot)com>
To: PGADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Help
Date: 2006-02-05 02:42:25
Message-ID: 1139107345.7202.8.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

Responses

  • Re: Help at 2006-02-05 03:14:46 from Tom Lane

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-02-05 03:14:46 Re: Help
Previous Message Mohan Anon 2006-02-04 22:53:17 Postgres 8.1.x and MIT Kerberos 5