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

From: strk <strk(at)keybit(dot)net>
To: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy
Date: 2011-02-07 14:38:59
Message-ID: 20110207143859.GH34837@keybit.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 07, 2011 at 02:31:49PM +0100, Dimitri Fontaine wrote:
> strk <strk(at)keybit(dot)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 Content-Type Size
cascade_deferrable_bug.sql text/plain 784 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-02-07 14:50:09 Re: A different approach to extension NO USER DATA feature
Previous Message strk 2011-02-07 14:14:36 Re: DROP SCHEMA xxx CASCADE: ERROR: could not open relation with OID yyy