>>>>> "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/