Re: unable to drop a constraint

[Michael Glaesemann <michael.glaesemann@xxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx