Question about detecting database changes

From: Dave Peticolas <dave(at)krondo(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Question about detecting database changes
Date: 2014-06-18 22:11:29
Message-ID: CAPRbp04rDsgSwPCghZHM+BgELHUU3L8ak1K9219WX5uoXidR9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I have a question about getting some information about database changes.

Let's suppose I have a particular transaction ID that I happen to know has
been rolled back.

Is it possible to ask the database if there have been any committed
transactions subsequent
to that rolled-back transaction? Basically I'm would like to know if I will
see the same state
of data that I could see at the beginning of that transaction in the
transaction I am in right
now. I am using Postgres 9.2, but if it's only possible in a later version
I would be interested
in knowing that too.

Thanks very much!

--
--Dave Peticolas

Browse pgsql-general by date

  From Date Subject
Next Message Jason Long 2014-06-18 23:47:44 Overlapping ranges
Previous Message Vasudevan, Ramya 2014-06-18 22:08:11 Re: max_connections reached in postgres 9.3.3