On 04/16/2014 07:06 PM, Susan Cassidy wrote:
Yes, it is the same connection. It is all the same transaction.
Susan
On Wed, Apr 16, 2014 at 5:00 PM, John R Pierce <pie...@hogranch.com
<mailto:pie...@hogranch.com>> wrote:
On 4/16/2014 4:53 PM, Susan Cassidy 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 new primary key, and when I SELECT it, it
isn't found.
are you using the same connection ? it won't be visible to a different
connection until its committed.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
Any chance you accidentally fired of a rollback?
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
