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

[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 natura