drop check constraint

From: "Tamsin" <tg_mail(at)bryncadfan(dot)co(dot)uk>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: drop check constraint
Date: 2001-02-07 11:25:01
Message-ID: NEBBKHBOBMJCHDMGKCNJOEGOCJAA.tg_mail@bryncadfan.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shahab Asgharzadeh 2001-02-07 11:48:24 numeric type and odbc from access 2000
Previous Message Martin A. Marques 2001-02-07 11:08:44 Re: Re: new type proposal