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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
