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

From Stephan Szabo
Subject Re: DROP TABLE hangs because of same table foreign key
Date
Msg-id 20020502083108.B48224-100000@megazone23.bigpanda.com
Whole thread Raw
In response to DROP TABLE hangs because of same table foreign key  (Louis-David Mitterrand <vindex@apartia.org>)
List pgsql-hackers
On Thu, 2 May 2002, Louis-David Mitterrand wrote:

>
> 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?

Should be.
Were there any other transactions open at the time?  Given it went away
after restarting, I'd first guess that something else might have a lock
on the table.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Schemas: status report, call for developers
Next
From: "Marc G. Fournier"
Date:
Subject: Re: PostgreSQL mission statement?