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

From Antony Paul
Subject Re: create temp table and on commit in 7.3.3
Date
Msg-id 2989532e05020823262deac894@mail.gmail.com
Whole thread Raw
In response to Re: create temp table and on commit in 7.3.3  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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


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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: create temp table and on commit in 7.3.3
Next
From: Tino Wildenhain
Date:
Subject: Re: Postgresql and Macintosh