Re: Some strange bug with drop table with slony cluster

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Some strange bug with drop table with slony cluster
Дата
Msg-id 5473.1245278105@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Some strange bug with drop table with slony cluster  (Maxim Boguk <mboguk@masterhost.ru>)
Список pgsql-general
Maxim Boguk <mboguk@masterhost.ru> writes:
> Server was slave in slony replication.

> Now problem:
> table was unsubscribed from replication (without any errors)
> and then dropped from master without any errors

> But when i try drop table from slave i got very strange error:
> hh=# drop TABLE metro_station_old;
> ERROR:  "area_pk" is an index

You'd be best off to ask about this on the Slony mailing lists.
Slony plays some strange games with the system catalogs, and
I think that cases like this are fairly common if you don't perform
schema changes on slon-ified tables in just exactly the right way.
Hopefully somebody over there will recognize this particular
symptom and help you out.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how to cancel a query in progress
Следующее
От: justin
Дата:
Сообщение: Re: used for large media files