| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Tamsin <tg_mail(at)bryncadfan(dot)co(dot)uk> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: drop check constraint |
| Date: | 2001-02-07 17:33:23 |
| Message-ID: | Pine.BSF.4.21.0102070932350.49683-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yes. You need to remove the row on pg_relcheck and then change the
value of relchecks for the row in pg_class for the relation the check
constraint is on.
On Wed, 7 Feb 2001, Tamsin wrote:
> 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas T. Thai | 2001-02-07 17:40:30 | Re: full text searching |
| Previous Message | Brice Ruth | 2001-02-07 17:23:37 | Re: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? |