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

Sandro Santilli <strk@keybit.net>

View thread

From: strk <strk@keybit.net>

To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>

Cc: pgsql-hackers@postgresql.org

Date: 2011-02-07T14:38:59Z

Lists: pgsql-hackers

Attachments

cascade_deferrable_bug.sql (text/plain)

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