Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy - Mailing list pgsql-hackers

From strk
Subject Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy
Date
Msg-id 20110207143859.GH34837@keybit.net
Whole thread Raw
In response to Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: strk
Date:
Subject: Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy
Next
From: Robert Haas
Date:
Subject: Re: A different approach to extension NO USER DATA feature