Chris Barnes <[email protected]> writes:
> I am attempting to drop an foreign key on a table and it sits for hours and
> doesn't drop or put anything into the log.
Dropping a foreign key is fast in itself, but it requires exclusive lock
on both the referencing and referenced tables. Look to see what is
blocking the lock request. pg_locks and pg_stat_activity views are
your friends.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
