AW: [HACKERS] Another TEMP table trick

>> 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