Can't drop constraint? - Mailing list pgsql-admin

From Carol Walter
Subject Can't drop constraint?
Date
Msg-id 5D4683FD-DDAB-46CB-B3E6-62B1082A8CD4@indiana.edu
Whole thread Raw
Responses Re: Can't drop constraint?
List pgsql-admin
Hello,

I don't know how they did this, but I have a table that has a compound
field constraint.  When I try to insert data into this table from an
app I'd developing the query fails because the data supposedly
violates the unique constraint on these fields.  The fields are first,
middle, and last names.  The name I'm trying to insert doesn't exist
in the database, yet I can't put it in.  When I try to drop the
constraint, which I can plainly see when I describe the table,
postgres tells me that the constraint doesn't exist.  How can I fix
this?

Thanks,
Carol

pgsql-admin by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: postgres 8.2.9 can`t drop database in single user mode
Next
From: Tom Lane
Date:
Subject: Re: Can't drop constraint?