From: Rod Taylor <rbt@rbt.ca>
To: Alan Gutierrez <ajglist@izzy.net>
Cc: pgsql-sql@postgresql.org, PostgreSQL-general <pgsql-general@postgresql.org>
Subject: Re: is current_timestamp unique for a transaction?
Date: 15 Feb 2003 23:24:01 -0500
Message-ID: <1045369440.12011.54.camel@jester> (raw)
In-Reply-To: <Pine.WNT.4.53.0302152148200.984@CX1198465-B>
References: <Pine.WNT.4.53.0302152148200.984@CX1198465-B>
Not guaranteed, but also not likely to be the same value unless you have
high volume.
Use a sequence if you need a unique number.
On Sat, 2003-02-15 at 22:49, Alan Gutierrez wrote:
> Is current_timestamp(6) garunteed to be unique for each transaction?
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rbt@rbt.ca, ajglist@izzy.net, pgsql-general@postgresql.org
Subject: Re: is current_timestamp unique for a transaction?
In-Reply-To: <1045369440.12011.54.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox