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

Reply via email to