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

-----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@dbserver.com.br]
>> Sent: 16 August 2001 14:06
>> To: pgsql-general@postgresql.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@dbserver.com.br
>> Fone: (51) 3342-8055
>> Fax: (51) 3342-4838
>>
>>
>>
>> -----Original Message-----
>> From: Roderick A. Anderson [mailto:raanders@tincan.org]
>> Sent: quinta-feira, 16 de agosto de 2001 09:27
>> To: Martijn van Oosterhout
>> Cc: Ben-Nes Michael; pgsql-general@postgresql.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@postgresql.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@postgresql.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-----

_________________________________________________________________________
This e-mail and any attachments are confidential and may also be privileged and/or copyright
material of Intec Telecom Systems PLC (or its affiliated companies). If you are not an
intended or authorised recipient of this e-mail or have received it in error, please delete
it immediately and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail is strictly prohibited and may be unlawful.
Intec Telecom Systems PLC. does not represent or warrant that an attachment hereto is free
from computer viruses or other defects. The opinions expressed in this e-mail and any
attachments may be those of the author and are not necessarily those of Intec Telecom
Systems PLC.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
__________________________________________________________________________