Re: What's the XID?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: What's the XID?
Дата
Msg-id 20080102115435.GB31408@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: What's the XID?  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: What's the XID?
Список pgsql-admin
Guillaume Lelarge wrote:

> We first send the query to the database. For each returned column, we
> send two queries. The first one gives us the type's name of the column
> and the second one gives us the OID of the base type. So, each query
> executed with pgAdmin's query tool should increase age(datfrozenxid) by :
>   1 + (2 * number of columns in the SELECT)

Ever thought of doing it all in a single transaction?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

В списке pgsql-admin по дате отправления:

Предыдущее
От: Glyn Astill
Дата:
Сообщение: Shutting down warm standby server? "
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: What's the XID?