Postgres Pro
Downloads
Home   >   mailing lists

transaction_timestamp() - Mailing list pgsql-admin

From Samuel Stearns
Subject transaction_timestamp()
Date
Msg-id 68B59BEDCD36854AADBDF17E91B2937A01A57CCCB9@EXCHMAIL.staff.internode.com.au
Whole thread Raw
Responses Re: transaction_timestamp()
List pgsql-admin
Tree view

Howdy,

 

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?

 

Thanks,

 

Sam

 

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
Next
From: Tom Lane
Date:
Subject: Re: transaction_timestamp()