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

2007-01-31 Thread Tom Lane
"Jason L. Buberel" <[EMAIL PROTECTED]> writes: > Thanks for taking a look Tom: > I am running postgres 8.1.4 on RedHet (CentOS) v4.0. Here is the > description of the purchase_record table (somewhat abbreviated with > uninvolved columns omitted): Well, I was hoping I could duplicate the problem,

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

2007-01-30 Thread Jason L. Buberel
Thanks for taking a look Tom: I am running postgres 8.1.4 on RedHet (CentOS) v4.0. Here is the description of the purchase_record table (somewhat abbreviated with uninvolved columns omitted): # \d purchase_record Table "public.purchase_record" Column

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

2007-01-30 Thread Tom Lane
[EMAIL PROTECTED] 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 tabl

[GENERAL] When an index and a constraint have the same name...

2007-01-30 Thread jason
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_specifica