Re: Some strange bug with drop table with slony cluster

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Maxim Boguk <mboguk(at)masterhost(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Some strange bug with drop table with slony cluster
Date: 2009-06-17 22:35:05
Message-ID: 5473.1245278105@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Maxim Boguk <mboguk(at)masterhost(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message justin 2009-06-17 22:44:34 Re: used for large media files
Previous Message Tom Lane 2009-06-17 22:19:56 Re: how to cancel a query in progress