"Gauthier, Dave" <[EMAIL PROTECTED]> writes:
> How user specific is pg_tables when it comes to temporary tables?
regression=# \d pg_tables
...
View definition:
SELECT n.nspname AS schemaname, c.relname AS tablename,
pg_get_userbyid(c.relowner) AS tableowner, t.spcname AS tablespace,
c.relhasind
Hi:
How user specific is pg_tables when it comes to temporary tables? It
seems to pick up the existence of a a temp table created by the same
user but a different session. Here's the demo scenario
Session 1:
mydb=# create temporary table foo (a int);
Session 2:
stdb2=# select tab
