By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,374 Members | 2,014 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,374 IT Pros & Developers. It's quick & easy.

Problem creating ROWTYPE variable in plpgsql.

P: n/a

Hi,
profile_row profile_master%ROWTYPE;
in a plpgsql function

gives the error below

tradein_clients=# SELECT general.create_accounts();
WARNING: plpgsql: ERROR during compile of create_accounts near line 8
ERROR: cache lookup for type 0 of profile_master.........pg.dropped.2........ failed

profile_master have had deletions of its column in past.
if i replace profile_master with another table in which no columns
were dropped there is no problem.

Has this been fixed in the upcoming version of postgresql?
Regds
Mallah.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Rajesh Kumar Mallah <ma****@trade-india.com> writes:
profile_row profile_master%ROWTYPE;
in a plpgsql function
gives the error below
tradein_clients=# SELECT general.create_accounts();
WARNING: plpgsql: ERROR during compile of create_accounts near line 8
ERROR: cache lookup for type 0 of profile_master.........pg.dropped.2........ failed profile_master have had deletions of its column in past.


I believe this has been fixed for 7.4 --- at least, we have fixed some
related issues.

2003-09-25 19:02 tgl

* src/: backend/executor/execQual.c,
backend/executor/nodeFunctionscan.c, pl/plpgsql/src/gram.y,
pl/plpgsql/src/pl_comp.c, pl/plpgsql/src/pl_exec.c,
pl/plpgsql/src/pl_funcs.c, pl/plpgsql/src/plpgsql.h: Make the world
safe (more or less) for dropped columns in plpgsql rowtypes.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.