>> test=> create table test (x int);>> CREATE>> test=> insert into test values (1);>> INSERT >> test=> create temp
tabletest (x int); <-->> CREATE <-->> test=> insert into test values (2);>> INSERT
197871>> test=> select * from test;>> x>> ->> 2>> (1 row)>> >> test=> drop table test;>> DROP>> test=> select * from
test;>>x>> ->> 1>> (1 row)>> >> test=> drop table test;>> DROP
Do you really think that this should be allowed ? I think table names
including
temp tables should (at least in combination with the owner) be unique. I
think your
example above demonstrates how confusing the application code can get.
I think it is good, that temp tables are not really inserted into system
tables,
since this would be substantial overhead.
There could be a problem with GUI tools that rely on these rows
to format their output (like pgaccess or ODBC --> M$ Access) though.
Andreas