"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,
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
[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
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