On Thu, Sep 23, 2010 at 11:01 AM, Chris Barnes <compuguruchrisbar...@hotmail.com> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
