On Thu, Sep 23, 2010 at 11:01 AM, Chris Barnes
<compuguruchrisbarnes@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.