Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: crystal <crystal_lium(at)163(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390
Date: 2008-07-09 13:55:22
Message-ID: 20080709135522.GB3946@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

crystal wrote:

> TEST=# drop owned by u1, u2 cascade;
> NOTICE: drop cascades to view v2
> ERROR: cache lookup failed for relation 16390

Rats. I guess this is due to the two-pass nature of some algorithm.
(Dropping owned by u1 cascade drops the view too, and then when dropping
owned by u2, it tries to find the view and the cache lookup fails).

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-07-09 14:52:37 Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390
Previous Message crystal 2008-07-09 08:11:30 BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390