Error loading /usr/lib/postgresql/plpgsql.so

From: wsheldah(at)lexmark(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Error loading /usr/lib/postgresql/plpgsql.so
Date: 2003-03-19 16:17:37
Message-ID: OFF0D3DB85.5D4DA937-ON85256CEE.00586105@lexmark.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've recently upgraded a test server from postgresql 7.2.2 to version
7.3.2, and also rebuilt perl 5.8.0 on a gentoo linux system. Restoring the
databases worked fine, selecting from tables works fine, but a simple
insert statement generates this error:

ERROR: Load of file /usr/lib/postgresql/plpgsql.so failed: /lib/libc.so.6: version `GLIBC_2.3' not found (required by /usr/lib/postgresql/plpgsql.so)

The same error is generated whether the insert is done from the psql prompt or through a perl script using DBI and DBD::PG (latest versions of both).
The insert statement is:

insert into testrun(f1, f2, f3, f4, f5, f6, f7 ) values( 'aa', 'bb', 'cc', 'ddd', 'eee', 'ffff', 'ggggg') ;

(with actual field names and values altered)

The testrun table has a trigger that runs before insert or update, that calls a plpgsql function. This is evidently where the problem is. However,
/lib/libc.so.6 clearly exists, and my current version of glibc appears to be 2.3

What's the best way to go about fixing it?

Thanks,

Wes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Gregory 2003-03-19 16:32:20 retrieving fields in plpgsql
Previous Message Flower Sun 2003-03-19 15:59:47 How to get information of active/inactive user connection for postgresql