Re: Modifying check constraints

>>>>> "SS" == Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/