Skip site navigation (1) Skip section navigation (2)

Re: transaction_timestamp()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Samuel Stearns <SStearns(at)internode(dot)com(dot)au>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: transaction_timestamp()
Date: 2010-05-25 04:31:42
Message-ID: 17418.1274761902@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Samuel Stearns <SStearns(at)internode(dot)com(dot)au> writes:
> I have an archiving script running in an 8.3 environment using transaction_timestamp() for the INSERT and DELETE operations.  I want to run the same thing in an 8.1 environment but transaction_timestamp() does not exist in 8.1.  now() will not work because of the time that elapses between the INSERT and DELETE operations (I will end up losing some data).  Does anyone have any suggestions, please?

Um ... transaction_timestamp() is exactly the same thing as now().

Perhaps you need to go re-read
http://www.postgresql.org/docs/8.3/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Samuel StearnsDate: 2010-05-25 05:15:05
Subject: Re: transaction_timestamp()
Previous:From: Samuel StearnsDate: 2010-05-25 04:25:44
Subject: transaction_timestamp()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group