Re: timestamp as primary key?

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: AgentM <agentm(at)themactionfaction(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: timestamp as primary key?
Date: 2006-10-19 15:50:08
Message-ID: 20061019155008.GX71084@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 19, 2006 at 10:36:29AM -0400, AgentM wrote:
> Only if each message is contained in its own transaction since now()
> is effectively a constant throughout a transaction. In this case, I
> would choose a surrogate key since it is likely that the table will
> be referenced.

See timeofday().
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2006-10-19 16:00:06 Re: Stats Collector Won't Start
Previous Message Jim C. Nasby 2006-10-19 15:46:19 Re: Interval referential integrity