Re: Using Transaction Blocks w/ SELECT - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Using Transaction Blocks w/ SELECT
Date
Msg-id Pine.LNX.4.30.0104271708040.758-100000@peter.localdomain
Whole thread Raw
In response to Using Transaction Blocks w/ SELECT  (<postgres@athena.frontlogic.com>)
List pgsql-sql
postgres@athena.frontlogic.com writes:

> Goinging throught the libpq docs, I noticed that in all of the examples involving
> select statements, transaction blocks are used.  I see why this is necessary for
> write operations, but I don't see the need in read operations that don't commit.  Am
> I missing something?  Any help appreciated.

It's done to get consistent data snapshots across several commands.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From:
Date:
Subject: Using Transaction Blocks w/ SELECT
Next
From: Stephan Szabo
Date:
Subject: Re: Regular expressions and indexes