Handler for plpgsql out of date?
Just wanted to check that this was a known problem:
ERROR: fmgr_info: language 20322 has old-style handler
this is from current CVS when trying to call a procedure written in plpgsql.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
Philip Warner <pjw@rhyme.com.au> writes:
Just wanted to check that this was a known problem:
ERROR: fmgr_info: language 20322 has old-style handler
this is from current CVS when trying to call a procedure written in plpgsql.
It's certainly not a known problem --- if it were, the plpgsql regress
test would be failing.
I have a nasty feeling that the reason for the failure is that you
restored a DB dump that declares the plpgsql call handler as language
'C' (correct for 7.0) not 'newC' (correct for current sources).
I don't see any easy way around this :-(.
Anyone have an idea how we can avoid importing a bad declaration from
an old dump?
BTW, I'm leaving in a few minutes and won't be home till Wed. evening,
so don't expect any thoughts from this quarter...
regards, tom lane