Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)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