DROP TABLE hangs because of same table foreign key - Mailing list pgsql-hackers

From Louis-David Mitterrand
Subject DROP TABLE hangs because of same table foreign key
Date
Msg-id 20020502123832.GA2696@apartia.org
Whole thread Raw
Responses Re: DROP TABLE hangs because of same table foreign key  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: DROP TABLE hangs because of same table foreign key  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
Hi,

On 7.2.1 debian-unstable PG hangs when trying to drop a table which
contains a field referencing another field in the same table as a
foreign key. 

Is it legal/orhtodox to use a "references" on another field of the same
table?
Strangely after restarting PG the drop succeeds without hanging.

--    OENONE: Vous aimez. On ne peut vaincre sa destinée.           Par un charme fatal vous fûtes entraînée.
                             (Phèdre, J-B Racine, acte 4, scène 6)
 


pgsql-hackers by date:

Previous
From: Jim Mercer
Date:
Subject: Re: PostgreSQL mission statement?
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: PostgreSQL mission statement?