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/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
