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: David Fetter <david(at)fetter(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:58:59
Message-ID: 20051117215859.GC9407@fetter.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Nov 17, 2005 at 04:37:14PM -0500, Tom Lane wrote:
> 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;

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?

    CREATE TABLE foo (LIKE SELECT ...);

or some such?

Cheers,
D
-- 
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-11-17 22:32:43
Subject: Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP
Previous:From: Tom LaneDate: 2005-11-17 21:37:14
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