On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> > db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
> > ERROR:  "items_pkey" is an index
> Context please?

Yeah, I had that one coming, didn't it... That's what I get for trying to
type it up on my phone on the way home.

Anyway. I've asked for a dump of the db to get all the details, but basically:
   id int not null primary key,
CREATE TABLE items_stat (
   item_id int not null references items.id,

One thing that might be related - items is a Slony slave table. items_stat
is *not* in the Slony set. It's not *supposed* to have a foreign key to the
items table, which is why I'm trying to drop it.

It had the same scenario on teh primary slony node, but there the ALTER
TABLE to drop the constraint worked fine. Again, items is master in the
slony set, items_stat is not in any slony set.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to