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

2005-11-22 Thread David Fetter
On Tue, Nov 22, 2005 at 06:20:37PM -0500, Bruce Momjian wrote: > > TODO has: > > o Add ON COMMIT capability to CREATE TABLE AS ... SELECT Great :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---(end o

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

2005-11-17 Thread David Fetter
On Thu, Nov 17, 2005 at 05:32:43PM -0500, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > On Thu, Nov 17, 2005 at 04:37:14PM -0500, Tom Lane wrote: > >> CREATE TEMP TABLE foo ... ON COMMIT DROP; > > > It's that first little elipsis mark that's the problem. Is there > > something re

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

2005-11-17 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > On Thu, Nov 17, 2005 at 04:37:14PM -0500, Tom Lane wrote: >> CREATE TEMP TABLE foo ... ON COMMIT DROP; > It's that first little elipsis mark that's the problem. Is there > something really clever I've been missing on how to do a dynamic table > creation?

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

2005-11-17 Thread David Fetter
On Thu, Nov 17, 2005 at 04:37:14PM -0500, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> 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; It's that first little

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

2005-11-17 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> 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 ---

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

2005-11-17 Thread David Fetter
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 ver

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

2005-11-17 Thread Jaime Casanova
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 A

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

2005-11-17 Thread David Fetter
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