For those experienced using natural primary key designs, what update
strategies do you use when updating related tuples within a
transaction when the primary key is also subject to changes?
For example consider a table is vertically partitioned into two or
more segments (all related on the natural primary key). Allowing for
the primary key to be updated (and cascaded to the foreign keys), are
there any ways to updated all of the tuples in a single transaction
using the primary key in the where clause?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug