On Wed, Apr 25, 2012 at 9:37 AM, Nicolas Barbier
<nicolas.barbier@gmail.com> wrote:
> The declarative creation of an “standard-like” temporary table only
> happens once (it is part of the schema). Using (e.g. putting stuff in
> and executing queries on) such tables can happen on the standby
> without the master having to know.
So you are saying it is OK to not be able to *create* them on HS, just
*use* pre-defined tables?
That's almost useless IMHO.
Applications expect to be able to do this all in the same transaction
on one session
CREATE TEMP TABLE x;...DML commands...
SELECT ... FROM x;
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
