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 |
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 |