how to alter/drop check contraint?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: how to alter/drop check contraint?
Date: 2000-12-20 13:10:56
Message-ID: 20001220141056.A22241@gruby
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Artur Rataj 2000-12-20 18:38:30 `~' operator and indices
Previous Message Karel Zak 2000-12-20 07:42:56 Re: substring ..