Re: Temp tables are curious creatures....

I think you have to use the backend pid to find your own.  I think
there is a libpq function that returns the backend pis so psql can
frame the proper query.

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

Rod Taylor wrote:
> Appears psql needs to know how to differentiate between it's own temp
> tables and those of another connection.  On the plus side, this takes
> care of a TODO item to add temp table listings to psql.
> 
> Connection 1:
> 
> template1=# create temp table junk(col1 int4);
> CREATE
> template1=# select * from junk;
>  col1 
> ------
> (0 rows)
> 
> 
> Connection 2:
> template1=# \d
>   List of relations
>  Name | Type  | Owner 
> ------+-------+-------
>  junk | table | rbt
> (1 row)
> 
> template1=# select * from junk;
> ERROR:  Relation "junk" does not exist
> 
> template1=# create temp table junk (col4 text);
> CREATE
> 
>   List of relations
>  Name | Type  | Owner 
> ------+-------+-------
>  junk | table | rbt
>  junk | table | rbt
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

--  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