Re: Auto-timestamp generator (attached)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Auto-timestamp generator (attached)
Дата
Msg-id 14980.981679290@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Auto-timestamp generator (attached)  (Joseph Shraibman <jks@selectacast.net>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: Auto-timestamp generator (attached)
Следующее
От: Joseph Shraibman
Дата:
Сообщение: Re: Auto-timestamp generator (attached)