Re: Using Transaction Blocks w/ SELECT

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <postgres(at)athena(dot)frontlogic(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Using Transaction Blocks w/ SELECT
Date: 2001-04-27 15:08:39
Message-ID: Pine.LNX.4.30.0104271708040.758-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

postgres(at)athena(dot)frontlogic(dot)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(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message clayton cottingham 2001-04-27 16:18:51 anyone use contrib/rserv?
Previous Message Hans-Jürgen Schönig 2001-04-27 09:04:25 Regular expressions and indexes