Excerpts from Robert Haas's message of mié nov 23 12:28:38 -0300 2011: > Hmm, I'm not seeing any increase in the number of entries in > pg_shdepend when I create either a temporary or permanent table: > > rhaas=# select sum(1) from pg_shdepend; > sum > ----- > 2 > (1 row) > > rhaas=# create temp table xyz (a int); > CREATE TABLE > rhaas=# select sum(1) from pg_shdepend; > sum > ----- > 2 > (1 row)
That's because the owner is "pinned" (i.e. the bootstrap user). Try with a different user. I see new rows with both temp and non-temp tables. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
