Re: DROP TABLE hangs because of same table foreign key

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Louis-David Mitterrand <vindex(at)apartia(dot)org>
Cc: PostGreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP TABLE hangs because of same table foreign key
Date: 2002-05-02 15:32:57
Message-ID: 20020502083108.B48224-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeffrey W. Baker 2002-05-02 15:43:23 Re: Schemas: status report, call for developers
Previous Message Hannu Krosing 2002-05-02 15:00:42 Re: Schemas: status report, call for developers