[GENERAL] Transaction Strategies for Natural Primary Keys Cascading Updates

2009-09-08 Thread Richard Broersma
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

Re: [GENERAL] Transaction Strategies for Natural Primary Keys Cascading Updates

2009-09-08 Thread miller_2555
Richard Broersma wrote: 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