create temp table and on commit in 7.3.3

From: Antony Paul <antonypaul24(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: create temp table and on commit in 7.3.3
Date: 2005-02-09 05:18:14
Message-ID: 2989532e05020821184a9aba4b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message javier wilson 2005-02-09 05:54:21 Re: Database permissions
Previous Message Joshua D. Drake 2005-02-09 05:14:29 Re: Backup restore does not work