| 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: | Whole Thread | Raw Message | 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 |
| 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 |