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.