Re: Some strange bug with drop table with slony cluster - Mailing list pgsql-general

From Tom Lane
Subject Re: Some strange bug with drop table with slony cluster
Date
Msg-id 5473.1245278105@sss.pgh.pa.us
Whole thread Raw
In response to Some strange bug with drop table with slony cluster  (Maxim Boguk <mboguk@masterhost.ru>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to cancel a query in progress
Next
From: justin
Date:
Subject: Re: used for large media files