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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]