Skip site navigation (1) Skip section navigation (2)

Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: Jaime Casanova <systemguards(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP
Date: 2005-11-17 21:37:14
Message-ID: 8757.1132263434@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
David Fetter <david(at)fetter(dot)org> writes:
> This is still a bug,

No, it's a feature request, and a rather low-priority one considering
you can already do

	CREATE TEMP TABLE foo ... ON COMMIT DROP;
	INSERT INTO foo SELECT ...

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: David FetterDate: 2005-11-17 21:58:59
Subject: Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP
Previous:From: David FetterDate: 2005-11-17 21:07:49
Subject: Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group