Waiting for Commit
От | Pablo Montilla |
---|---|
Тема | Waiting for Commit |
Дата | |
Msg-id | 005e01c41370$85e6b210$7d00a8c0@athena обсуждение исходный текст |
Ответы |
Re: Waiting for Commit
|
Список | 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-----
В списке pgsql-general по дате отправления: