Re: Temporary table error messages different to perm. tables - Mailing list pgsql-bugs

Philip Warner <pjw@rhyme.com.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