Re: Creation of temporary tables on read-only standby servers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Creation of temporary tables on read-only standby servers
Date: 2010-10-18 18:06:01
Message-ID: 22902.1287425161@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Currently it isn't possible to create temporary tables on read-only
> standby servers, and I don't see it listed on the TODO list. Can I add
> it?

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-10-18 18:06:50 Re: Floating-point timestamps versus Range Types
Previous Message Cédric Villemain 2010-10-18 18:05:31 Re: Creation of temporary tables on read-only standby servers