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

Re: Waiting for Commit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pablo Montilla" <melkor(at)adinet(dot)com(dot)uy>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Waiting for Commit
Date: 2004-03-27 02:42:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
"Pablo Montilla" <melkor(at)adinet(dot)com(dot)uy> writes:
> What I've got is something like this:

> Session1> INSERT INTO Table VALUES(0);
> Session1> COMMIT;
> Session2> SELECT FROM Table;

> And Session2 is not gettint the values I've just commited.

I don't believe that can happen, unless you've made a programming

(1) Are you waiting for the COMMIT response to come back before you
issue the other SELECT?

(2) Are you running the other transaction in serializable mode?
If so, it won't see commits that happened later than its own BEGIN.

			regards, tom lane

In response to


pgsql-general by date

Next:From: David GaramondDate: 2004-03-27 03:17:08
Subject: Re: Beginner Questions Please: Which To Go With ?
Previous:From: Tom LaneDate: 2004-03-27 02:38:15
Subject: Re: Problem with memory in C function

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