Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group