| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | Rado Petrik <r(dot)p(at)szm(dot)sk> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Drop CONSTRAINT |
| Date: | 2003-05-20 15:16:20 |
| Message-ID: | Pine.LNX.4.44.0305201315390.12914-100000@matrix.gatewaynet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 20 May 2003, Rado Petrik wrote:
> Hi,
>
> how I drop this CONSTRAINT?
>
> CONSTRAINT "ckc_p_name_pw_produ" CHECK ((p_name = 'aaa'::"varchar") OR
> (p_name = 'bbb'::"varchar"))
alter table <yourtable> drop contraint ckc_p_name_pw_produ;
>
> Thanks.
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ww zz | 2003-05-20 16:00:11 | how to do this query? |
| Previous Message | Jan Wieck | 2003-05-20 14:57:53 | Re: Testing castability of text to numeric |