Received: from gruby_int.cs.net.pl (cafe1.rem.pl [195.205.133.61]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBKDBp680904 for ; Wed, 20 Dec 2000 08:12:07 -0500 (EST) (envelope-from depesz@gruby.cs.net.pl) Received: (from localhost user: 'depesz' uid#500 fake: STDIN (depesz@gruby.cs.net.pl)) by gruby.cs.net.pl id ; Wed, 20 Dec 2000 14:10:56 +0100 Date: Wed, 20 Dec 2000 14:10:56 +0100 From: hubert depesz lubaczewski To: PGSQL-SQL Subject: how to alter/drop check contraint? Message-ID: <20001220141056.A22241@gruby> Reply-To: depesz@depesz.pl Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i X-Archive-Number: 200012/231 X-Sequence-Number: 568 the subject should be self-explanatory, but: i have table: create table a (b text check (length(b)<10)); and for some reason i want to drop this check or alter this to length(b)<20. how can i do so? or maybe using trigger in plpgsql will be better? how to make trigger which will stop insert or update when something occurs? depesz -- hubert depesz lubaczewski ------------------------------------------------------------------------ najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo, jest niesamowita wręcz łatwość unikania kontaktów z nim ...