how to alter/drop check contraint? - Mailing list pgsql-sql

From hubert depesz lubaczewski
Subject how to alter/drop check contraint?
Date
Msg-id 20001220141056.A22241@gruby
Whole thread Raw
Responses Re: how to alter/drop check contraint?
List pgsql-sql
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
nowoczesnespołeczeństwo,     jest niesamowita wręcz łatwość unikania kontaktów z nim ...
 


pgsql-sql by date:

Previous
From: Karel Zak
Date:
Subject: Re: substring ..
Next
From: Jie Liang
Date:
Subject: Re: substring ..