Skip site navigation (1) Skip section navigation (2)

Re: Temporary table error messages different to perm. tables

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 (view raw or flat)
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

In response to

pgsql-bugs by date

Next:From: Michael RichardsDate: 2000-08-06 16:19:19
Subject: Database in recovery mode
Previous:From: Philip WarnerDate: 2000-08-04 16:27:03
Subject: ExecEvalExpr: unknown expression type 501 from coalesce

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group