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: 798.1080355360@sss.pgh.pa.us (view raw or flat)
Thread:
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
error.

(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

Responses

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-2014 The PostgreSQL Global Development Group