Re: Possible Bug regarding temp tables (sql or psql?) - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Possible Bug regarding temp tables (sql or psql?)
Date
Msg-id 200207051852.g65IqNm01276@candle.pha.pa.us
Whole thread Raw
In response to Re: Possible Bug regarding temp tables (sql or psql?)  (Mark Frazer <mark@somanetworks.com>)
List pgsql-sql
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
 




pgsql-sql by date:

Previous
From: Vernon Wu
Date:
Subject: i18n in pgSQL
Next
From: Bruce Momjian
Date:
Subject: Re: How do i return a dataset from a stored procedure