Re: yowch: dumpRules(): SELECT failed for table website. - Mailing list pgsql-hackers

From SL Baur
Subject Re: yowch: dumpRules(): SELECT failed for table website.
Date
Msg-id m3aehgqp96.fsf@dhcp-38.jp.tlan
Whole thread Raw
In response to yowch: dumpRules(): SELECT failed for table website.  (Alfred Perlstein <bright@wintelcom.net>)
Responses Re: Re: yowch: dumpRules(): SELECT failed for table website.  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-hackers
Alfred Perlstein <bright@wintelcom.net> writes in pgsql-hackers@postgresql.org:

> while doing a pg_dump of a table after postgresql made a mess of itself:

> dumpRules(): SELECT failed for table website.  Explanation from
> backend: 'ERROR: cache lookup of attribute 1 in relation 9892634
> failed '.

I just got a message like that earlier this afternoon.  My problem was
that I had created a view and later dropped and recreated one of the
tables the view referenced.  Dropping and recreating the view fixed
things.



pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: yowch: dumpRules(): SELECT failed for table website.
Next
From: Alfred Perlstein
Date:
Subject: Re: yowch: dumpRules(): SELECT failed for table website.