Horton

Re: Temporary tables under hot standby

Jim Nasby <jim@nasby.net>

View thread
From: Jim Nasby <jim@nasby.net>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Nicolas Barbier <nicolas.barbier@gmail.com>, Noah Misch <noah@leadboat.com>, pgsql-hackers@postgresql.org
Date: 2012-05-01T20:12:20Z
Lists: pgsql-hackers 
On 4/25/12 6:16 AM, Simon Riggs wrote:
>> The way standard-like temporary tables work is exactly why I assume
>> >  Noah proposes to implement them: because they work nicely with HS.

> Well, following a standard that no other major DBMS has followed is
> not great, especially if it leads to a non-useful feature.

Actually, Oracle's temp tables are standard-compliant. You must explicitly define them via DDL and they remain in the catalog.
-- 
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net