Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy

Поиск
Список
Период
Сортировка
От strk
Тема Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy
Дата
Msg-id 20110207143859.GH34837@keybit.net
обсуждение исходный текст
Ответ на Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Ответы Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
On Mon, Feb 07, 2011 at 02:31:49PM +0100, Dimitri Fontaine wrote:
> strk <strk@keybit.net> writes:
> > Do you have an idea on how to further debug this ?
>
> That usually goes with providing a self-contained test case… that is a
> minimum script that creates the function(s) and calls them.

I've finally completed the debugging phase and have
a minimal self-contained testcase showing the problem.

It has to do with INITIALLY DEFERRED constraints.

The testcase is attached.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
Вложения

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

Предыдущее
От: strk
Дата:
Сообщение: Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy
Следующее
От: Robert Haas
Дата:
Сообщение: Re: A different approach to extension NO USER DATA feature