On Monday 18 October 2010 20:06:01 Tom Lane wrote: > Bruce Momjian <br...@momjian.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. Hm. Wouldnt it be possible to use virtual xids for that purpose? They are never seen outside of that session anyway...
Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
