Re: add additional options to CREATE TABLE ... AS

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Neil Conway <neilc(at)samurai(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: add additional options to CREATE TABLE ... AS
Date: 2006-02-14 22:30:36
Message-ID: Pine.BSO.4.63.0602141722160.27266@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Tue, 14 Feb 2006, Tom Lane wrote:

> I kinda wonder why bother at all. I don't see any good reason why
> people shouldn't issue two statements.
>

Well if you don't know what the resulting columns are going to be that
could be difficult. There are a number of reasons why this patch is an
improvement.

1) People have requested this feature:
http://archives.postgresql.org/pgsql-bugs/2005-11/msg00163.php
http://archives.postgresql.org/pgsql-bugs/2004-03/msg00186.php

2) The SQL spec requires ON COMMIT for CREATE TEMP TABLE AS SELECT.

3) The unification of EXECUTE and SELECT options actually simplifies the
grammar by removing the WithOidsAs production hack.

Kris Jurka

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Simon Riggs 2006-02-14 22:54:13 Re: Patch Submission Guidelines
Previous Message Tom Lane 2006-02-14 22:28:54 Re: Patch Submission Guidelines