Re: Roll Back dont roll back counters - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: Roll Back dont roll back counters
Date
Msg-id Pine.LNX.4.10.10108160732080.10717-100000@tincan.org
Whole thread Raw
In response to Re: Roll Back dont roll back counters  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Thu, 16 Aug 2001, Martijn van Oosterhout wrote:

> You can tell the order anyway. The order doesn't change, it's only that
> there may be numbers missing,

Please note the message from "Michael Ansley (UK)".  If two of more
connections get a cache from a sequence and the inserts are 'sporatic'
then there will be a difference in the sequence number and the insert
order.

> Primarys keys should be opaque. Any meaning read into them is entirely
> coincidental.

I agree.


Rod
--


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: why sequential scan
Next
From: roypgsqlgen@xemaps.com
Date:
Subject: confused on maximum characters