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

jason@buberel.org writes:
> 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').

That shouldn't be a problem particularly.

> 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

That seems odd.  What PG version is this exactly ("8.1" is not good
enough)?  What does psql show for "\d report_specification" and
"\d purchase_record"?

            regards, tom lane