Re: create temp table and on commit in 7.3.3 - Mailing list pgsql-general

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 51
> >
> > Is 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/