Philip Warner <[EMAIL PROTECTED]> 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
