DROP TABLE hangs because of same table foreign key

From: Louis-David Mitterrand <vindex(at)apartia(dot)org>
To: PostGreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: DROP TABLE hangs because of same table foreign key
Date: 2002-05-02 12:38:32
Message-ID: 20020502123832.GA2696@apartia.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2002-05-02 12:43:04 Re: PostgreSQL mission statement?
Previous Message Jim Mercer 2002-05-02 12:37:06 Re: PostgreSQL mission statement?