Re: Creation of temporary tables on read-only standby servers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Creation of temporary tables on read-only standby servers
Date
Msg-id 24228.1287429998@sss.pgh.pa.us
Whole thread Raw
In response to Re: Creation of temporary tables on read-only standby servers  (Andres Freund <andres@anarazel.de>)
Responses Re: Creation of temporary tables on read-only standby servers
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On Monday 18 October 2010 20:06:01 Tom Lane wrote:
>> Not unless you have some credible concept for how it might ever be
>> implemented.  You can't create temp tables because you can't modify
>> system catalogs, and if you did somehow create them you couldn't put
>> anything in them because you can't generate XIDs on a slave ... much
>> less commit them.  We have talked about ways that temp tables might be
>> created without touching the "real" system catalogs, but the XID issue
>> seems a complete showstopper.

> Hm. Wouldnt it be possible to use virtual xids for that purpose? They are 
> never seen outside of that session anyway...

Well, maybe, but then you need infrastructure to track whether VXIDs
committed or aborted.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: create tablespace fails silently, or succeeds improperly
Next
From: Jeff Davis
Date:
Subject: Re: Floating-point timestamps versus Range Types