Re: What's the XID? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: What's the XID?
Date
Msg-id 20080102115435.GB31408@alvh.no-ip.org
Whole thread Raw
In response to Re: What's the XID?  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: What's the XID?  (Guillaume Lelarge <guillaume@lelarge.info>)
List 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 by date:

Previous
From: Glyn Astill
Date:
Subject: Shutting down warm standby server? "
Next
From: Guillaume Lelarge
Date:
Subject: Re: What's the XID?