Re: CREATE TEMP TABLE .... ON COMMIT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: CREATE TEMP TABLE .... ON COMMIT
Date: 2002-08-09 14:33:22
Message-ID: 787.1028903602@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Gavin Sherry <swm(at)linuxworld(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-08-09 15:26:08 Re: pg_stat_reset() weirdness
Previous Message Tom Lane 2002-08-09 13:50:13 Re: pg_stat_reset() weirdness

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2002-08-09 16:01:56 Re: stand-alone composite types patch (was [HACKERS] Proposal:
Previous Message Tom Lane 2002-08-09 14:31:56 Re: adding PGPASSWORDFILE to libpq