drop check constraint - Mailing list pgsql-general

From Tamsin
Subject drop check constraint
Date
Msg-id NEBBKHBOBMJCHDMGKCNJOEGOCJAA.tg_mail@bryncadfan.co.uk
Whole thread Raw
Responses Re: drop check constraint  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hello,

Is it possible to drop a check constraint in any way without
dropping/recreating the table?  I've managed to drop foreign key constraints
by dropping the associated triggers, but check constraints don't seem to
create triggers and there isn't an alter table drop constraint command.  Is
there something I can do to the system tables?

(PostgreSQL 7.0.2)

Thanks for any ideas,
Tamsin


pgsql-general by date:

Previous
From: "Martin A. Marques"
Date:
Subject: Re: Re: new type proposal
Next
From: "Jamie Bumsted"
Date:
Subject: Can you help a newbie?