Re: Modifying check constraints

>>>>> "SS" == Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:

>> Can I change the CHECK constraint afterwards? For example, can I
>> add another value that "tipo" can have, or I'd have to recreate the
>> table?

SS> Right now, I think you'd need to recreate, but 7.2 should let you drop
SS> and re-add the check constraint.

I posted a note the other day to postgres general titled "constraint
surgery" showing how I altered the check constraints on a table asking
if it would cause problems.  it is in the list archives for Nov 7 (I
think).

I never got any replies, so I'm getting ready to try it on my
production server and hope it doesn't croak anything.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/