Bug found: fmgr_info: function <number>: cache lookup failed
If you double-alias a column in a query (yeah, stupid, I know, but I did
it by mistake and others will too!), then the dreaded "fmgr_info:
function <number>: cache lookup failed" message is kicked out. For example:
select * from company c, references r where r.company_id=c.company.id;
Note that c.company.id references column id in table company twice!
Hope that this finds someone looking at the error handling in the
parser! Should be chucked out as a syntax error.
Brad
Bradley Kieser <brad@kieser.net> writes:
If you double-alias a column in a query (yeah, stupid, I know, but I did
it by mistake and others will too!), then the dreaded "fmgr_info:
function <number>: cache lookup failed" message is kicked out. For example:
select * from company c, references r where r.company_id=c.company.id;
Can you provide a *complete* example? Also, what version are you using?
I tried this in 7.2.1:
test72=# create table company (id int);
CREATE
test72=# create table refs(company_id int);
CREATE
test72=# select * from company c, refs r where r.company_id=c.company.id;
ERROR: No such attribute or function 'company'
regards, tom lane