RE: Roll Back dont roll back counters

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can only guarantee the order if the sequence caching in the
session is 1 (You can set it higher, can't you?). If any sequence
numbers are cached, then you can't even guarantee the order, only
uniqueness.

Cheers...

MikeA

>> -----Original Message-----
>> From: Carlos Felipe Zirbes [mailto:carlosz(at)dbserver(dot)com(dot)br]
>> Sent: 16 August 2001 14:06
>> To: pgsql-general(at)postgresql(dot)org
>> Subject: RE: [GENERAL] Roll Back dont roll back counters
>>
>>
>> You still can tell the order even if you have holes in the key...
>>
>> Carlos Felipe Zirbes
>> DBServer Assessoria em Sistemas de Informação
>> E-mail: carlosz(at)dbserver(dot)com(dot)br
>> Fone: (51) 3342-8055
>> Fax: (51) 3342-4838
>>
>>
>>
>> -----Original Message-----
>> From: Roderick A. Anderson [mailto:raanders(at)tincan(dot)org]
>> Sent: quinta-feira, 16 de agosto de 2001 09:27
>> To: Martijn van Oosterhout
>> Cc: Ben-Nes Michael; pgsql-general(at)postgresql(dot)org
>> Subject: Re: [GENERAL] Roll Back dont roll back counters
>>
>>
>> On Thu, 16 Aug 2001, Martijn van Oosterhout wrote:
>>
>> > Why do people care about holes anyway? I've never
>> understood that...
>>
>> The single seat syndrome? (It's my database and I'm the
>> only one using
>> it.)
>>
>> Trying to put intelligence into the field? (I can tell the order
>> the entries were made in the table using this field.)
>>
>>
>> Rod
>> --
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an
>> appropriate subscribe-nomail command to majordomo(at)postgresql(dot)org
>> so that your message can get through to the mailing list cleanly
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an
>> appropriate subscribe-nomail command to majordomo(at)postgresql(dot)org
>> so that your message can get through to the mailing list cleanly
>>

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO3vJQ3ympNV/C086EQIU7gCg39S8h0M2l24/DU5H9CVJetYczYIAn18W
Bqke7grgimtbw4tdrdKV1whH
=Ura+
-----END PGP SIGNATURE-----