Chris Barnes <compuguruchrisbar...@hotmail.com> 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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
