[GENERAL] RE: Roll Back dont roll back counters

2001-08-17 Thread Michael Ansley (UK)
Title: RE: Roll Back dont roll back counters -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes, of course.  But you have to have pretty stringent performance requirements to justify changing to technical IDs as a matter of rule.  Reading an ER model is pretty important too, from a maintenanc

[GENERAL] Re: Roll Back dont roll back counters

2001-08-17 Thread Bruno Wolff III
On Fri, Aug 17, 2001 at 11:37:33AM +0100, "Michael Ansley (UK)" <[EMAIL PROTECTED]> wrote: > > Um, no, primary keys should not always be opaque. Technical primary > keys should always be opaque. Relational modelling has been built to I think it has more to do with efficiency and whether or n

[GENERAL] Re: Roll Back dont roll back counters

2001-08-16 Thread Colin 't Hart
> If I design a table with SERIAL type and then try to insert few rows, but > some of the rows are rolled back the roll back process does not roll back > the counter status. > > Is there a way to do a roll back to the counter ? And I suppose if I deleted some rows you'd want all rows with higher