create temp table and on commit in 7.3.3
Hi all,
This is giving error in 7.3.3.
CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
ERROR: parser: parse error at or near "ON" at character 51
Is this supported.
rgds
Antony Paul
On Wed, 2005-02-09 at 10:48 +0530, Antony Paul wrote:
Hi all,
This is giving error in 7.3.3.CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
ERROR: parser: parse error at or near "ON" at character 51Is this supported.
No. Looking at the manual would have made it pretty obvious this was
added in 7.4
-Neil
On Wed, Feb 09, 2005 at 06:00:52PM +1100, Neil Conway wrote:
On Wed, 2005-02-09 at 10:48 +0530, Antony Paul wrote:
Hi all,
This is giving error in 7.3.3.CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
ERROR: parser: parse error at or near "ON" at character 51Is this supported.
No. Looking at the manual would have made it pretty obvious this was
added in 7.4
The 7.3 and 7.2 documentation for CREATE TABLE both mention ON COMMIT:
http://www.postgresql.org/docs/7.3/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
http://www.postgresql.org/docs/7.2/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
Should those versions describe ON COMMIT if they don't support it?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
I learned that there is an on commit clause by looking at the
Compaitiblity section of the 7.3.3 docs and I was confused whether it
is supporting this or not
rgds
Antony Paul
Show quoted text
On Wed, 9 Feb 2005 00:19:41 -0700, Michael Fuhr <mike@fuhr.org> wrote:
On Wed, Feb 09, 2005 at 06:00:52PM +1100, Neil Conway wrote:
On Wed, 2005-02-09 at 10:48 +0530, Antony Paul wrote:
Hi all,
This is giving error in 7.3.3.CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
ERROR: parser: parse error at or near "ON" at character 51Is this supported.
No. Looking at the manual would have made it pretty obvious this was
added in 7.4The 7.3 and 7.2 documentation for CREATE TABLE both mention ON COMMIT:
http://www.postgresql.org/docs/7.3/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
http://www.postgresql.org/docs/7.2/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITYShould those versions describe ON COMMIT if they don't support it?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Michael Fuhr <mike@fuhr.org> writes:
The 7.3 and 7.2 documentation for CREATE TABLE both mention ON COMMIT:
http://www.postgresql.org/docs/7.3/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
http://www.postgresql.org/docs/7.2/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
Should those versions describe ON COMMIT if they don't support it?
That section is describing features that are in the spec that we don't
support (or didn't then support).
regards, tom lane
On Wed, Feb 09, 2005 at 03:40:49PM -0500, Tom Lane wrote:
Michael Fuhr <mike@fuhr.org> writes:
The 7.3 and 7.2 documentation for CREATE TABLE both mention ON COMMIT:
http://www.postgresql.org/docs/7.3/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
http://www.postgresql.org/docs/7.2/static/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITYShould those versions describe ON COMMIT if they don't support it?
That section is describing features that are in the spec that we don't
support (or didn't then support).
Ah, right...just above there I see this:
"The CREATE TABLE conforms to SQL92 Intermediate and to a subset of
SQL99, with exceptions listed below and in the descriptions above."
Sorry about that.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/