Re: any way for a transaction to "see" inserts done earlier in the transaction?
От | Steven Schlansker |
---|---|
Тема | Re: any way for a transaction to "see" inserts done earlier in the transaction? |
Дата | |
Msg-id | 3783C401-675F-4B93-A8D3-B71DF2BB2E9A@likeness.com обсуждение исходный текст |
Ответ на | Re: any way for a transaction to "see" inserts done earlier in the transaction? (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>) |
Ответы |
Re: any way for a transaction to "see" inserts done earlier
in the transaction?
|
Список | pgsql-general |
>> On Wed, Apr 16, 2014 at 4:31 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> Susan Cassidy <susan.cassidy@decisionsciencescorp.com> writes: >> > Is there any way to let a transaction "see" the inserts that were done >> > earlier in the transaction? >> >> It works that way automatically, as long as you're talking about separate >> statements within one transaction. >> >> regards, tom lane > On Apr 16, 2014, at 4:53 PM, Susan Cassidy <susan.cassidy@decisionsciencescorp.com> wrote: > Well, it isn't working for me right now. It can't "see" a row that was inserted earlier in the transaction. It is a newprimary key, and when I SELECT it, it isn't found. > Can you share the code that does not work with us? Preferably as a small self-contained example.
В списке pgsql-general по дате отправления: