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.