Re: unable to drop a constraint - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: unable to drop a constraint
Date
Msg-id 5557917C-1667-45ED-B3C1-A1899993F190@myyearbook.com
Whole thread Raw
In response to unable to drop a constraint  (Enrico Sirola <enrico.sirola@gmail.com>)
Responses Re: unable to drop a constraint
List pgsql-general
On 2008-07-16, at 7:18 AM, Enrico Sirola wrote:

> Hi,
>
> I'm using postgresql version 8.3.1
>
> I have two tables, one has a field with a foreign key pointing to
> the primary key of another table. When I to drop the first table, I
> get the following error:
>
> test=# drop table user;
> ERROR:  "customer_pkey" is an index

Are you using slony perchance? This looks like an issue with slony
blocking DDL operations:

http://lists.slony.info/pipermail/slony1-general/2006-November/005216.html

Michael Glaesemann
michael.glaesemann@myyearbook.com


pgsql-general by date:

Previous
From: "Mason Hale"
Date:
Subject: Re: vacuum taking an unusually long time
Next
From: Steve Atkins
Date:
Subject: Re: vacuum taking an unusually long time