From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Mark Frazer <mark(at)somanetworks(dot)com> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Possible Bug regarding temp tables (sql or psql?) |
Date: | 2002-07-05 18:52:23 |
Message-ID: | 200207051852.g65IqNm01276@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces 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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | ozric tentacle | 2002-07-06 12:22:44 | HELP FOR POSTGRESQL NEEDED... |
Previous Message | Leland F. Jackson, CPA | 2002-07-05 16:10:40 | Re: [INTERFACES] MS Access 2K Inform User on Record changes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-07-06 02:17:16 | Re: How do i return a dataset from a stored procedure |
Previous Message | Vernon Wu | 2002-07-05 18:29:18 | i18n in pgSQL |