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

[David Fetter]

The following bug has been logged online:

Bug reference:      2051
Logged by:          David Fetter
Email address:      [EMAIL PROTECTED]
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
;

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly