On Thu, Sep 23, 2010 at 11:01 AM, Chris Barnes <[email protected]> wrote: > 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. >
Does the pg_stat_activity view show that it is waiting for a lock? It will need to lock both the origin and destination tables of the FK to clear the triggers. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
