Re: [HACKERS] DROP TABLE hangs because of same table foreign key

2002-05-02 Thread Stephan Szabo
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?

Re: [HACKERS] DROP TABLE hangs because of same table foreign key

2002-05-02 Thread Tom Lane
Louis-David Mitterrand <[EMAIL PROTECTED]> 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,

[HACKERS] DROP TABLE hangs because of same table foreign key

2002-05-02 Thread Louis-David Mitterrand
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 hangin