Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Susan Cassidy <susan.cassidy@xxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: any way for a transaction to "see" inserts done earlier in the transaction?
From: Bosco Rama <postgres@xxxxxxxxxxxxx>
Date: Wed, 16 Apr 2014 17:13:48 -0700
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAE3Q8o=B7oKNiVH+Bcsrom2UjvpTF5wy8fMZ0ey+uFSUehTyig@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux i686 on x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0

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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Greg Sabino Mullane
- Re: any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Susan Cassidy

References:
- any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Susan Cassidy
- Re: any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Tom Lane
- Re: any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Susan Cassidy
- Re: any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Steven Schlansker
- Re: any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Susan Cassidy
- Re: any way for a transaction to "see" inserts done earlier in the transaction?
  - From: Susan Cassidy

Prev by Date: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Next by Date: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Previous by thread: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Next by thread: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]