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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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 Content-Type Size
create-table-options.patch text/plain 32.1 KB

Responses

Browse pgsql-patches by date

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