Re: Temporary table error messages different to perm. tables

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> The following seems a little strange (in 7.02/Linux):

> zzz=# create table t1(f1 integer);
> zzz=# create temporary table t2(f1 integer, f2 integer);
> zzz=# Update t1 Set f1 = (select x.junk from t2 x where x.junk2 = t1.f1);
> ERROR: Unable to locate type name 't2' in catalog

This is fixed in current CVS:

regression=# create table t1(f1 integer);
CREATE
regression=# create temporary table t2(f1 integer, f2 integer);
CREATE
regression=# Update t1 Set f1 = (select x.junk from t2 x where x.junk2 = t1.f1);
ERROR: No such attribute or function 'junk'

Problem was that the temp table name mapping has to be applied to type
names as well as table names.

regards, tom lane