Re: 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. +