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