Re: Storing Snapshot Data - Mailing list pgsql-general

From Tom Lane
Subject Re: Storing Snapshot Data
Date
Msg-id 13405.1071156026@sss.pgh.pa.us
Whole thread Raw
In response to Storing Snapshot Data  (John Gibson <gib@edgate.com>)
List pgsql-general
John Gibson <gib@edgate.com> writes:
> Unfortunately, I am stuck on how to get all three into the monitor table
> with the same timestamp.

Do all the work in a single SERIALIZABLE transaction.  That gives you a
static, consistent view of the database for as long as you need.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Should we consider empty fields as NULL values when
Next
From: Richard Huxton
Date:
Subject: Re: Should we consider empty fields as NULL values when dealing with string columns ?