Temp tables are curious creatures....
| От | Rod Taylor |
|---|---|
| Тема | Temp tables are curious creatures.... |
| Дата | |
| Msg-id | 1020126745.38874.3.camel@knight.zort.ca обсуждение исходный текст |
| Ответы |
Re: Temp tables are curious creatures....
Re: Temp tables are curious creatures.... |
| Список | pgsql-hackers |
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 relationsName | 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 relationsName | Type | Owner ------+-------+-------junk | table | rbtjunk | table | rbt
В списке pgsql-hackers по дате отправления: