Postgres Pro
Downloads
Home   >   mailing lists

Re: any way for a transaction to "see" inserts done earlier in the transaction? - Mailing list pgsql-general

From Susan Cassidy
Subject Re: any way for a transaction to "see" inserts done earlier in the transaction?
Date
Msg-id CAE3Q8onfztrVLvfzJy3WT7YfYxJO80VNmxzwKhH7gH5fb99B1Q@mail.gmail.com
Whole thread Raw
In response to Re: any way for a transaction to "see" inserts done earlier in the transaction?  (Bosco Rama <postgres@boscorama.com>)
List pgsql-general
Tree view
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@boscorama.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.

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Next
From: Tom Lane
Date:
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?