Re: Re: any way for a transaction to "see" inserts done earlier in the transaction?

От

Alban Hertroys

Тема

Дата

17 апреля 2014 г. в 06:55:47

Msg-id

5A914EC4-ABB1-41AB-9A6A-24C9185B3F17@gmail.com

обсуждение

Ответ на

Re: any way for a transaction to "see" inserts done earlier in the transaction? (David G Johnston)

Список

pgsql-general

Дерево обсуждения

any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 16 апреля 2014 г. в 23:27:17

Re: any way for a transaction to "see" inserts done earlier in the transaction? Tom Lane <tgl@sss.pgh.pa.us> 16 апреля 2014 г. в 23:31:48

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 16 апреля 2014 г. в 23:53:34

Re: any way for a transaction to "see" inserts done earlier in the transaction? Steven Schlansker <steven@likeness.com> 16 апреля 2014 г. в 23:58:43

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 00:06:03

Re: any way for a transaction to "see" inserts done earlier in the transaction? David G Johnston <david.g.johnston@gmail.com> 17 апреля 2014 г. в 00:28:27

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Robert DiFalco <robert.difalco@gmail.com> 17 апреля 2014 г. в 00:34:10

Re: any way for a transaction to "see" inserts done earlier in the transaction? David G Johnston <david.g.johnston@gmail.com> 17 апреля 2014 г. в 00:49:39

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Alban Hertroys <haramrae@gmail.com> 17 апреля 2014 г. в 06:55:47

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 15:06:00

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 15:06:38

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Robert DiFalco <robert.difalco@gmail.com> 17 апреля 2014 г. в 15:41:36

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Scott Marlowe <scott.marlowe@gmail.com> 17 апреля 2014 г. в 15:20:06

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 17:02:06

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Vincent Veyron <vincent.veyron@libremen.org> 17 апреля 2014 г. в 21:19:06

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Vincent Veyron <vincent.veyron@libremen.org> 17 апреля 2014 г. в 21:19:26

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 18:00:51

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Vincent Veyron <vv.lists@wanadoo.fr> 17 апреля 2014 г. в 17:40:49

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? "Greg Sabino Mullane" <greg@turnstep.com> 18 апреля 2014 г. в 18:57:09

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 15:01:41

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 14:54:40

Re: any way for a transaction to "see" inserts done earlier in the transaction? Tom Lane <tgl@sss.pgh.pa.us> 17 апреля 2014 г. в 00:17:08

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 00:18:44

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 00:25:01

Re: any way for a transaction to "see" inserts done earlier in the transaction? David G Johnston <david.g.johnston@gmail.com> 17 апреля 2014 г. в 00:39:26

Re: Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 14:58:52

Re: any way for a transaction to "see" inserts done earlier in the transaction? David G Johnston <david.g.johnston@gmail.com> 17 апреля 2014 г. в 16:25:48

Re: any way for a transaction to "see" inserts done earlier in the transaction? Adrian Klaver <adrian.klaver@aklaver.com> 17 апреля 2014 г. в 00:33:56

Re: any way for a transaction to "see" inserts done earlier in the transaction? Adrian Klaver <adrian.klaver@aklaver.com> 17 апреля 2014 г. в 02:32:14

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 15:06:11

Re: any way for a transaction to "see" inserts done earlier in the transaction? Rajeev rastogi <rajeev.rastogi@huawei.com> 21 апреля 2014 г. в 03:45:40

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 00:08:41

Re: any way for a transaction to "see" inserts done earlier in the transaction? Rob Sargent <robjsargent@gmail.com> 17 апреля 2014 г. в 00:13:52

Re: any way for a transaction to "see" inserts done earlier in the transaction? Bosco Rama <postgres@boscorama.com> 17 апреля 2014 г. в 00:13:09

Re: any way for a transaction to "see" inserts done earlier in the transaction? "Greg Sabino Mullane" <greg@turnstep.com> 17 апреля 2014 г. в 16:32:20

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 00:16:34

Re: any way for a transaction to "see" inserts done earlier in the transaction? John R Pierce <pierce@hogranch.com> 17 апреля 2014 г. в 00:01:09

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 00:06:34

Re: any way for a transaction to "see" inserts done earlier in the transaction? Andy Colson <andy@squeakycode.net> 17 апреля 2014 г. в 01:26:13

Re: any way for a transaction to "see" inserts done earlier in the transaction? Susan Cassidy <susan.cassidy@decisionsciencescorp.com> 17 апреля 2014 г. в 15:02:37

Re: any way for a transaction to "see" inserts done earlier in the transaction? Steven Schlansker <steven@likeness.com> 16 апреля 2014 г. в 23:31:20

On 17 Apr 2014, at 2:49, David G Johnston  wrote:

> Robert DiFalco wrote
>> Two common cases I can think of:
>> 
>> 1. The PERL framework is only caching the insert and does not actually
>> perform it until commit is issued.
> 
> Wouldn't the same mechanism cache the corresponding SELECT?

Not likely, or if it did it wouldn’t be able to know what id was returned from the function (which calls nextval(), but that isn’t relevant here since it’s marked volatile).
That makes it a possible scenario for what’s being witnessed here.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.

В списке pgsql-general по дате отправления

Предыдущее

От: Michael Paquier

Дата: 17 апреля 2014 г. в 04:56:15

Сообщение: Re: shared memory allocation - C function

Следующее

От: Steve Spence

Дата: 17 апреля 2014 г. в 12:01:01

Сообщение: Arduino SQL Connector