Thread: pgsql: Add TABLESPACE and ON COMMIT clauses to CREATE TABLE AS.

pgsql: Add TABLESPACE and ON COMMIT clauses to CREATE TABLE AS.

From
neilc@postgresql.org (Neil Conway)
Date:
18 February 2006, 20:04:31
Log Message:
-----------
Add TABLESPACE and ON COMMIT clauses to CREATE TABLE AS. ON COMMIT is
required by the SQL standard, and TABLESPACE is useful functionality.
Patch from Kris Jurka, minor editorialization by Neil Conway.

Modified Files:
--------------
    pgsql/doc/src/sgml/ref:
        create_table.sgml (r1.99 -> r1.100)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_table.sgml.diff?r1=1.99&r2=1.100)
        create_table_as.sgml (r1.31 -> r1.32)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_table_as.sgml.diff?r1=1.31&r2=1.32)
    pgsql/src/backend/commands:
        prepare.c (r1.47 -> r1.48)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/prepare.c.diff?r1=1.47&r2=1.48)
    pgsql/src/backend/executor:
        execMain.c (r1.265 -> r1.266)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c.diff?r1=1.265&r2=1.266)
    pgsql/src/backend/nodes:
        copyfuncs.c (r1.326 -> r1.327)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c.diff?r1=1.326&r2=1.327)
        equalfuncs.c (r1.262 -> r1.263)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c.diff?r1=1.262&r2=1.263)
        outfuncs.c (r1.267 -> r1.268)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/outfuncs.c.diff?r1=1.267&r2=1.268)
        readfuncs.c (r1.183 -> r1.184)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/readfuncs.c.diff?r1=1.183&r2=1.184)
    pgsql/src/backend/parser:
        analyze.c (r1.328 -> r1.329)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/analyze.c.diff?r1=1.328&r2=1.329)
        gram.y (r2.529 -> r2.530)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.529&r2=2.530)
    pgsql/src/include/nodes:
        parsenodes.h (r1.300 -> r1.301)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.300&r2=1.301)
    pgsql/src/test/regress/expected:
        temp.out (r1.10 -> r1.11)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/temp.out.diff?r1=1.10&r2=1.11)
        without_oid.out (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/without_oid.out.diff?r1=1.5&r2=1.6)
    pgsql/src/test/regress/input:
        tablespace.source (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/input/tablespace.source.diff?r1=1.2&r2=1.3)
    pgsql/src/test/regress/output:
        tablespace.source (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/output/tablespace.source.diff?r1=1.2&r2=1.3)
    pgsql/src/test/regress/sql:
        temp.sql (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/temp.sql.diff?r1=1.6&r2=1.7)
        without_oid.sql (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/without_oid.sql.diff?r1=1.5&r2=1.6)