Thread: DROP TABLE hangs because of same table foreign key

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)
 

Louis-David Mitterrand <vindex@apartia.org> writes:
> 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. 

I'm a little confused.  Could you post a complete example?
        regards, tom lane

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.