Обсуждение: 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.