Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCHES] CREATE TEMP TABLE .... ON COMMIT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] CREATE TEMP TABLE .... ON COMMIT
Date
Msg-id 787.1028903602@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TEMP TABLE .... ON COMMIT  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: [PATCHES] CREATE TEMP TABLE .... ON COMMIT  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Tree view 
Gavin Sherry <swm@linuxworld.com.au> writes:
> template1=# create temp table a (a int) on commit drop;
> ERROR:  You must be inside a transaction to use ON COMMIT

Surely that's only for ON COMMIT DROP, if you intend to offer the
others?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_stat_reset() weirdness
Next
From: Joe Conway
Date:
Subject: Re: pg_stat_reset() weirdness