Re: Auto-timestamp generator (attached) - Mailing list pgsql-general

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