Strange error dropping foreign key

From: "Magnus Hagander" <magnus(at)hagander(dot)net>
To: Pgsql-hackers(at)postgresql(dot)org
Subject: Strange error dropping foreign key
Date: 2007-10-18 14:26:27
Message-ID: 200710181626280000@18407431
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Decibel! 2007-10-18 14:29:08 Re: dblink un-named connection doesn't get re-used
Previous Message Marko Kreen 2007-10-18 14:25:51 Re: [RFC] extended txid docs