Re: Postgres wont drop foriegn keys on tables.

From: Vick Khera <vivek(at)khera(dot)org>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres wont drop foriegn keys on tables.
Date: 2010-09-23 15:28:05
Message-ID: AANLkTinaf=XJFReQDpqFk1Tb9bt4MhcNdiSVngGNnbi7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-09-23 15:29:47 Re: Postgres wont drop foriegn keys on tables.
Previous Message Jan Otto 2010-09-23 15:14:56 update from 9.0rc1 to 9.0