| 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
| 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 |
| 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 |