Arch Linux

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#48303 - [postgresql] unable to load plpgsql.so

Attached to Project: Arch Linux
Opened by ed adasiewicz (eda2z) - Monday, 22 February 2016, 20:15 GMT
Last edited by Doug Newgard (Scimmia) - Tuesday, 23 February 2016, 21:13 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Dan McGee (toofishes)
Architecture All
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description: When trying to do an insert into a table I am receiving:

ERROR: could not load library "/usr/lib/postgresql/plpgsql.so": /usr/lib/postgresql/plpgsql.so: undefined symbol: DatumIsReadWriteExpandedObject

I had originally encountered this in a python program but was able to reproduce it with a simple insert in psql -- e.g.

insert into tasks (details) values ('Hello');

This does NOT happen with updates or selects, only inserts. Upon further testing the problem stems from the table having a trigger which is written in plpgsql.

Downgrading to 9.4.5.1 solves the problem.

Additional info:
* package version(s)
postgresql 9.5.1-1
postgresql-libs 9.5.1-1

* config and/or log files etc.

Steps to reproduce: If you enter the following in psql you will get the error on the last line:

create table t1 (f1 text, d1 timestamp);

create or replace function t1() returns trigger as $$
begin
if TG_OP = 'INSERT' then
NEW.d1 := now();
return NEW;
end if;
end;
$$ language plpgsql;

This task depends upon

Closed by  Doug Newgard (Scimmia)
Tuesday, 23 February 2016, 21:13 GMT
Reason for closing:  Not a bug
Comment by Andreas (vogan) - Tuesday, 23 February 2016, 08:29 GMT
Can't confirm the issue, probably you forgot to upgrade your cluster to 9.5 after the postgresql upgrade?
See: https://wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL
Comment by ed adasiewicz (eda2z) - Tuesday, 23 February 2016, 14:45 GMT
Ooops.. My error, sorry to waste your time.

Loading...