Re: yowch: dumpRules(): SELECT failed for table website.

From: SL Baur <steve(at)beopen(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, Alfred Perlstein <bright(at)wintelcom(dot)net>
Subject: Re: yowch: dumpRules(): SELECT failed for table website.
Date: 2000-05-24 09:19:33
Message-ID: m3aehgqp96.fsf@dhcp-38.jp.tlan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alfred Perlstein <bright(at)wintelcom(dot)net> writes in pgsql-hackers(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2000-05-24 09:28:25 Solaris 2.6 problems
Previous Message Alfred Perlstein 2000-05-24 09:10:58 yowch: dumpRules(): SELECT failed for table website.