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

add additional options to CREATE TABLE ... AS

From: Kris Jurka <books(at)ejurka(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: add additional options to CREATE TABLE ... AS
Date: 2006-02-14 19:32:36
Message-ID: Pine.BSO.4.63.0602141425560.8341@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-patches
This patch adds most of the options available for regular CREATE TABLE 
syntax to the CREATE TABLE x AS SELECT ... and AS EXECUTE ... 
Specifically this allows specification of on commit behavior for temp 
tables and tablespaces for regular tables to these two statements. 
Additionally with/without oids is now available for the EXECUTE variant. 
Currently you still cannot specify inheritance attributes with these 
commands, but this seems like a more complicated task.

Kris Jurka

Attachment: create-table-options.patch
Description: text/plain (32.1 KB)

Responses

pgsql-patches by date

Next:From: Andrew KlostermanDate: 2006-02-14 19:52:02
Subject: Re: BUG #2246: Bad malloc interactions: ecpg, openssl
Previous:From: Andrew KlostermanDate: 2006-02-14 19:21:11
Subject: Re: BUG #2246: Bad malloc interactions: ecpg, openssl

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