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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jason(at)buberel(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: When an index and a constraint have the same name...
Date: 2007-01-31 05:41:56
Message-ID: 16093.1170222116@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

jason(at)buberel(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2007-01-31 05:45:51 Re: Any Plans for cross database queries on the same server?
Previous Message Patrick 2007-01-31 05:11:35 Re: [GENERAL] PostgreSQL 9.0