| 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: | Whole Thread | Raw Message | 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
| 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 |