Re: 8.1beta1: pg_dumpall -c does delete from pg_shadow? - Mailing list pgsql-hackers

mark@mark.mielke.cc writes:
> Our friendly psql complains that pg_shadow is a view:
>     psql:<filename>:11: ERROR:  cannot delete from a view
>     HINT:  You need an unconditional ON DELETE DO INSTEAD rule.

Yeah, this is on the open-items list; the DELETE FROM is broken (and
was always a pretty bogus approach anyway), but it's not very clear
what to do instead.
        regards, tom lane