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
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 |