Postgres Pro
Downloads
Home   >   mailing lists

Strange error dropping foreign key - Mailing list pgsql-hackers

From Magnus Hagander
Subject Strange error dropping foreign key
Date
Msg-id 200710181626280000@18407431
Whole thread Raw
Responses Re: Strange error dropping foreign key
List pgsql-hackers
Tree view 
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR:  "items_pkey" is an index

The foreign key points to items.Item_id which is what's indexed by items_pkey. But I only wanted to drop that
constraint.

/Magnus

pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Why copy_relation_data only use wal whenWALarchivingis enabled
Next
From: Decibel!
Date:
Subject: Re: dblink un-named connection doesn't get re-used