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