Re: 8.1beta1: pg_dumpall -c does delete from pg_shadow?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mark(at)mark(dot)mielke(dot)cc
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.1beta1: pg_dumpall -c does delete from pg_shadow?
Date: 2005-08-28 16:03:29
Message-ID: 15911.1125245009@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mark(at)mark(dot)mielke(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-08-28 16:33:09 Re: small pg_dumpall bug/warning in 8.1beta1
Previous Message Stefan Kaltenbrunner 2005-08-28 13:48:02 small pg_dumpall bug/warning in 8.1beta1