Joseph Shraibman <jks@selectacast.net> writes:
>> Yes, that proves that your core backend is 7.0.3. However, the spelling
>> of the error message proves that your plpgsql shlib is NOT 7.0.3. It
>> might well be 6.5 or even older.
> Huh? How could that happen?
Easily. Check the path to the shlib that's defined in the CREATE
FUNCTION call for plpgsql_call_handler, eg do
select * from pg_proc where proname = 'plpgsql_call_handler';
The backend will believe whatever you tell it --- if, say, you restored
a 6.5 dump that had a different library path than your current
installation, you'd be in trouble. How exactly did you install plpgsql
support into this database?
regards, tom lane