BUG #7706: Can slave database supports creating temporary tables?

On Mon, Nov 26, 2012 at 01:59:44PM +0000, wilson@leyou.com wrote:

The following bug has been logged on the website:

Bug reference: 7706
Logged by: wilson
Email address: wilson@leyou.com
PostgreSQL version: 9.2.1
Operating system: debian
Description:

Hi Dears,
In M/S mode,Slave database can't create temporary tables right now,just
support read only access.But sometimes,for support some complex queries,we
need create some temp tables actually.
So I suggest postgresql slave node can support create temp tables in the
next version,that'll be great!!!

Well, because the slave is read-only, we have not figured out how to
enable creation of temporary tables on the slave. It isn't even on our
TODO list because we have no idea how we would do it.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs