ld.so error when inserting with a plpgsql trigger function

From: "Reimer, Fred" <Fred(dot)Reimer(at)Eclipsys(dot)com>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>, "'pgsql-ports(at)postgresql(dot)org'" <pgsql-ports(at)postgresql(dot)org>
Subject: ld.so error when inserting with a plpgsql trigger function
Date: 2000-10-04 13:14:29
Message-ID: B34839947C5FD2118D9100A0C9D5DE43045EB3B2@atl-nt-ex1.eclipsnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-ports

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(dot)Reimer(at)eclipsys(dot)com) as I only get the list at
home (fwr(at)ga(dot)prestige(dot)net).

Thanks,

Fred Reimer
Eclipsys Corporation

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-10-04 15:08:13 Re: I want tips for debugging deadlocks
Previous Message Philip Warner 2000-10-04 11:05:58 Re: pg_dump and quoting

Browse pgsql-ports by date

  From Date Subject
Next Message Frederick W. Reimer 2000-10-05 19:21:20 symbol not found in plpgsql.so
Previous Message Yutaka tanida 2000-10-04 10:35:26 Re: PostgreSQL and Cygwin 1.1.x