pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Drop CONSTRAINT 2+ messages / 2 participants [nested] [flat]
* Drop CONSTRAINT @ 2003-05-20 09:32 Rado Petrik <r.p@szm.sk> 2003-05-20 15:16 ` Re: Drop CONSTRAINT Achilleus Mantzios <achill@matrix.gatewaynet.com> 0 siblings, 1 reply; 2+ messages in thread From: Rado Petrik @ 2003-05-20 09:32 UTC (permalink / raw) To: pgsql-sql Hi, how I drop this CONSTRAINT? CONSTRAINT "ckc_p_name_pw_produ" CHECK ((p_name = 'aaa'::"varchar") OR (p_name = 'bbb'::"varchar")) Thanks. -- Rado Petrik <r.p@szm.sk> ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Drop CONSTRAINT 2003-05-20 09:32 Drop CONSTRAINT Rado Petrik <r.p@szm.sk> @ 2003-05-20 15:16 ` Achilleus Mantzios <achill@matrix.gatewaynet.com> 0 siblings, 0 replies; 2+ messages in thread From: Achilleus Mantzios @ 2003-05-20 15:16 UTC (permalink / raw) To: Rado Petrik <r.p@szm.sk>; +Cc: 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@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-05-20 15:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-05-20 09:32 Drop CONSTRAINT Rado Petrik <r.p@szm.sk> 2003-05-20 15:16 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox