When an index and a constraint have the same name...

From: jason(at)buberel(dot)org
To: pgsql-general(at)postgresql(dot)org
Subject: When an index and a constraint have the same name...
Date: 2007-01-30 17:18:57
Message-ID: cone.1170177537.231256.22765.1001@bunny
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Seems as though I've gotten myself into something of a pickle:

I wound up with a fkey constraint and an index on the same table having the
same name ('rs_fkey').

The result is an error message when I try to drop the table (cascade) or
even drop the constraint:

# alter table report_specification drop constraint rs_pkey;
NOTICE: constraint pr_rs on table purchase_record depends on index rs_pkey
ERROR: "rs_pkey" is an index

and then there is:

# drop index rs_pkey;
ERROR: cannot drop index rs_pkey because constraint rs_pkey on table
report_specification requires it
HINT: You may drop constraint rs_pkey on table report_specification instead.

Is there some name-spacing trick I can use to selectively drop the index or
the constraint in a way that postgres (using v8.1) will let me get away with
it?

Thanks,
Jason

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2007-01-30 17:31:22 Any Plans for cross database queries on the same server?
Previous Message codeWarrior 2007-01-30 17:15:11 Re: SQL to get a table columns comments?