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

Waiting for Commit

From: "Pablo Montilla" <melkor(at)adinet(dot)com(dot)uy>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Waiting for Commit
Date: 2004-03-26 20:25:44
Message-ID: 005e01c41370$85e6b210$7d00a8c0@athena (view raw or flat)
Thread:
Lists: pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello, I don't know if this is the right place for this question,
sorry in advance.

So, the question is: how can I wait for a transaction commited data
to be available to other sessions programmatically? I need to read
data in a different session than the one that commits it, but I'm
having timing problems, and can't seem to be able to synchronize
them. 

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.

Many thanks,
Pablo

- -- 
An assertion is Zen only when it is itself an act and does not refer
to
anything that is asserted in it.
 -- (from Bruce Lee's book, The Tao of Jeet Kune Do)


-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.3

iQA/AwUBQGSRxr6KEogX0AkqEQKGLwCgmR+sn1/YnoRNlNIzK6OVkNo2cm8An2tm
b0dz1bNuAUpFtQbaa/KZHkl3
=ZkFI
-----END PGP SIGNATURE-----


Responses

pgsql-general by date

Next:From: Diogo BiazusDate: 2004-03-26 20:29:21
Subject: Problem with memory in C function
Previous:From: Eric RidgeDate: 2004-03-26 20:08:29
Subject: pg 7.3, cursors, and prepared queries

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