Horton

Re: Summary and Plan for Hot Standby

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Tatsuo Ishii <ishii@postgresql.org>
Cc: simon@2ndQuadrant.com, pgsql-hackers@postgresql.org
Date: 2009-11-16T06:05:17Z
Lists: pgsql-hackers 
Tatsuo Ishii wrote:
> Just a question:
> 
> - Does Hot Standby allow to use prepared query (not prepared
>   transaction) in standby? I mean: Parse message from frontend can be
>   accepted by standby?

Yes.

> - Can we create tempory tables in standby?

No, because creating a temporary table needs to write to the catalogs.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com