Re: Using Transaction Blocks w/ SELECT

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Using Transaction Blocks w/ SELECT
Дата
Msg-id Pine.LNX.4.30.0104271708040.758-100000@peter.localdomain
обсуждение исходный текст
Ответ на Using Transaction Blocks w/ SELECT  (<postgres@athena.frontlogic.com>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Using Transaction Blocks w/ SELECT
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Regular expressions and indexes