ld.so error when inserting with a plpgsql trigger function

Поиск
Список
Период
Сортировка
От Reimer, Fred
Тема ld.so error when inserting with a plpgsql trigger function
Дата
Msg-id B34839947C5FD2118D9100A0C9D5DE43045EB3B2@atl-nt-ex1.eclipsnet.com
обсуждение исходный текст
Список pgsql-hackers
Hey,

I got this error when attempting to setup a table with a trigger that ran a
plpgsql program upon insert:

"DBD::Pg::st execute failed: ERROR:  Load of file
/usr/local/pgsql/lib/plpgsql.so failed: ld.so.1:
/usr/local/pgsql/bin/postmaster: fatal: relocation error: file
/usr/local/pgsql/lib/plpgsql.so: symbol CurrentMemoryContext: referenced
symbol not found
"

OS is Solaris 7 /w recommended and security patches as of about a month or
two ago.  PostgreSQL is 7.0.  I can do a 'nm plpgsql.so | grep
CurrentMemoryContext' in the /usr/local/pgsql/lib directory and I get:

"    U CurrentMemoryContext"

so it looks like the function is in the library.  Any clues as to what may
be causing this?

Please CC me at work (Fred.Reimer@eclipsys.com) as I only get the list at
home (fwr@ga.prestige.net).

Thanks,

Fred Reimer
Eclipsys Corporation


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Timed Triggers?
Следующее
От: Fabrice Scemama
Дата:
Сообщение: Re: I want tips for debugging deadlocks