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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390
Дата
Msg-id 20080709135522.GB3946@alvh.no-ip.org
обсуждение исходный текст
Ответ на BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390  ("crystal" <crystal_lium@163.com>)
Ответы Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "crystal"
Дата:
Сообщение: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390