Hi,
Temporary tables usually gets a unique schema name, see this:
postgres=# create temp table foo(i int);
CREATE TABLE
postgres=# explain verbose select * from foo;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on pg_temp_3.foo (cost=0.00..35.50 rows=2550 width=4)
Output: i
(2 rows)
The problem is that explain-verbose regression test output becomes
unstable when several concurrently running tests operate on temporary
tables.
I was wondering can we simply skip the temporary schema name from the
explain-verbose output or place the "pg_temp" schema name?
Thoughts/Suggestions?
Regares,
Amul