Re: Possible Bug regarding temp tables (sql or psql?)

It works, but only in CVS, not in 7.2.X.  Marking something as done in
TODO only means it is done and will be in the _next_ release.  Sorry.

---------------------------------------------------------------------------

Mark Frazer wrote:
> 
> 
> Bruce Momjian <pgman@candle.pha.pa.us> [02/07/04 22:10]:
> > 
> > TODO has:
> > 
> >     * Allow psql \d to show temporary table structure
> > 
> > Looks like it works fine now with schemas:
> >     
> > I will mark the TODO as done.
> 
> It doesn't work with select into though:
> 
> config=> select 5 into temp v_tmp ;
> SELECT
> config=> \d v_tmp 
> Did not find any relation named "v_tmp".
> config=> select 4 into temp v_tmp ;
> ERROR:  Relation 'v_tmp' already exists
> config=> select version() ;
>                            version                           
> -------------------------------------------------------------
>  PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
> 
> 
> -- 
> I heard one time you single-handedly defeated a hoard of rampaging somethings
> in the something something system. - Fry
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026