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

From: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>
To: Bosco Rama <postgres(at)boscorama(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Date: 2014-04-17 00:16:30
Message-ID: CAE3Q8onfztrVLvfzJy3WT7YfYxJO80VNmxzwKhH7gH5fb99B1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems to be returning the right id. It should be next for the serial
datatype.

Susan

On Wed, Apr 16, 2014 at 5:13 PM, Bosco Rama <postgres(at)boscorama(dot)com> wrote:

> On 04/16/14 17:08, Susan Cassidy wrote:
> > The function does a select to see if the id number exists, and it fails.
> > NOT FOUND causes a RAISE EXCEPTION.
>
> Is it returning the right id? I seem to remember a recent thread
> about Perl DBI returning the wrong id's for certain operations.
>
> Just at thought.
>
> Bosco.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-04-17 00:17:01 Re: any way for a transaction to "see" inserts done earlier in the transaction?
Previous Message Bosco Rama 2014-04-17 00:13:48 Re: any way for a transaction to "see" inserts done earlier in the transaction?