pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing Transaction Blocks w/ SELECT
2+ messages / 2 participants
[nested] [flat]
* Using Transaction Blocks w/ SELECT
@ 2001-04-26 21:46 postgres@athena.frontlogic.com
2001-04-27 15:08 ` Re: Using Transaction Blocks w/ SELECT Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: postgres@athena.frontlogic.com @ 2001-04-26 21:46 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Using Transaction Blocks w/ SELECT
2001-04-26 21:46 Using Transaction Blocks w/ SELECT postgres@athena.frontlogic.com
@ 2001-04-27 15:08 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2001-04-27 15:08 UTC (permalink / raw)
To: postgres@athena.frontlogic.com; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-04-27 15:08 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-26 21:46 Using Transaction Blocks w/ SELECT postgres@athena.frontlogic.com
2001-04-27 15:08 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox