On Jan 26, 2009, at 2:09 PM, Phoenix Kiula wrote:
I wonder if this is an SQL limitation or something I'm missing in the PG manual, but I need to run an update on my database (to replace the value of a column to match a new design structure).
Easiest is probably to add a new column for the new values and add a constraint to that, deprecating (or even dropping) the old column from your design. Don't forget to vacuum afterwards.
Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,497f5540747032091416566! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
