dropping anonymous constraints - Mailing list pgsql-general

From Ben Liblit
Subject dropping anonymous constraints
Date
Msg-id 3D34ED46.60907@eecs.berkeley.edu
Whole thread Raw
Responses Re: dropping anonymous constraints
List pgsql-general
Given a table "data" with column "value", one can add a constraint that
has no name:

     ALTER TABLE data ADD CHECK (value > 0);

How, then, does one remove this constraint?  The "ALTER TABLE ... DROP
CONSTRAINT ..." command expects to see a constraint name, but this
constraint is anonymous.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY seems to work, but no data in the table
Next
From: "Tracy Gong"
Date:
Subject: ? about Installation of Postgresql