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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
