BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP

From: "David Fetter" <david(at)fetter(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP
Date: 2005-11-17 20:07:00
Message-ID: 20051117200700.AB2F4F0B15@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2051
Logged by: David Fetter
Email address: david(at)fetter(dot)org
PostgreSQL version: 8.0x
Operating system: Linux
Description: CREATE TEMP TABLE AS SELECT doesn't play nice with ON
COMMIT DROP
Details:

CREATE TEMP TABLE foo
AS SELECT a,b,c
FROM bar
ON COMMIT DROP;

causes a syntax error. So does

CREATE TEMP TABLE foo
ON COMMIT DROP
AS SELECT a,b,c
FROM bar
;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2005-11-17 20:26:21 Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP
Previous Message Tom Lane 2005-11-17 18:27:19 Re: Huge query stalls at PARSE/BIND stage (1)