On Thu, Nov 17, 2005 at 03:26:21PM -0500, Jaime Casanova wrote: > 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
This is still a bug, or at least a big gotcha. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
