Re: global temporary tables - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: global temporary tables
Date
Msg-id 1272181795.4161.1604.camel@ebony
Whole thread Raw
In response to Re: global temporary tables  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: global temporary tables  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Sat, 2010-04-24 at 19:01 -0400, Robert Haas wrote:

> There is one major problem, though: assigning a
> scratch relfilenode to the temporary table requires generating an OID,
> which we currently have no way to allow on the standby.

Why not have an unlogged counter, which resets each system start, using
same datatype as an oid. There's no necessity for the relfilenode to be
an actual oid is there?

That way we could use it on standbys also.

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: global temporary tables
Next
From: Bernd Helmle
Date:
Subject: Re: psql: Add setting to make '+' on \d implicit