Re: unable to drop a constraint

Поиск
Список
Период
Сортировка
От Enrico Sirola
Тема Re: unable to drop a constraint
Дата
Msg-id A21641EE-C405-4E3D-95A4-0A024270ECFC@gmail.com
обсуждение исходный текст
Ответ на Re: unable to drop a constraint  (Michael Glaesemann <michael.glaesemann@myyearbook.com>)
Список pgsql-general
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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Enrico Sirola
Дата:
Сообщение: Re: unable to drop a constraint
Следующее
От: gabrielle
Дата:
Сообщение: Last chance to sign up for PDXPUG Day! You know you want to!