dropping anonymous constraints

Ben Liblit <liblit@eecs.berkeley.edu>

From: Ben Liblit <liblit@eecs.berkeley.edu>
To: pgsql-general@postgresql.org
Date: 2002-07-17T04:06:30Z
Lists: 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.