On 11/17/05, David Fetter <[EMAIL PROTECTED]> wrote: > > 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 > ; >
That is because there isn't an ON COMMIT clause for CREATE TABLE AS see compatibility section in: http://www.postgresql.org/docs/8.1/static/sql-createtableas.html -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
