dropping anonymous constraints

From: Ben Liblit <liblit(at)eecs(dot)berkeley(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: dropping anonymous constraints
Date: 2002-07-17 04:06:30
Message-ID: 3D34ED46.60907@eecs.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tracy Gong 2002-07-17 04:17:29 ? about Installation of Postgresql
Previous Message Tom Lane 2002-07-17 03:50:12 Re: COPY seems to work, but no data in the table