Skip site navigation (1) Skip section navigation (2)

Re: Temporary tables under hot standby

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Temporary tables under hot standby
Date: 2012-04-29 20:02:58
Message-ID: 20120429200258.GB14509@tornado.leadboat.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Apr 24, 2012 at 11:55:15PM -0400, Noah Misch wrote:
> Concerning everyone's favorite topic, how to name the new type of table, I
> liked Tom's proposal[1] to make CREATE TEMP TABLE retain current behavior and
> have CREATE GLOBAL TEMP TABLE and/or CREATE LOCAL TEMP TABLE request the new
> SQL-standard variety.  (I'd vote for using CREATE GLOBAL and retaining CREATE
> LOCAL for future expansion.)  As he mentions, to get there, we'd ideally start
> by producing a warning instead of silently accepting GLOBAL as a noise word.
> Should we put such a warning into 9.2?

Here is the change I'd make.

Thanks,
nm

> [1] http://archives.postgresql.org/message-id/5422.1240936705@sss.pgh.pa.us

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2012-04-29 20:04:50
Subject: Re: Re: xReader, double-effort (was: Temporary tables under hot standby)
Previous:From: Robert HaasDate: 2012-04-29 19:43:19
Subject: Re: default_transaction_isolation = serializable causes crash under Hot Standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group