Re: unable to drop a constraint

Hi Michael,

Il giorno 16/lug/08, alle ore 18:21, Michael Glaesemann ha scritto:

>
> 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:

hmmmm I don't use slony anymore, but these tables were part of a
replication set in the past.... It seems a good starting point, thanks
a lot,
e.