From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
Cc: | pgsql-bugs(at)hub(dot)org |
Subject: | Re: Temporary table error messages different to perm. tables |
Date: | 2000-08-06 02:46:22 |
Message-ID: | 15545.965529982@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Richards | 2000-08-06 16:19:19 | Database in recovery mode |
Previous Message | Philip Warner | 2000-08-04 16:27:03 | ExecEvalExpr: unknown expression type 501 from coalesce |