I’m using LX-Office 2.4.3 with openSuse 11.0. In 10.3 everything worked fine, but when I upgraded to 11.0 I had problems with INSERT and UPDATE commands via plpgsql.so.
FEHLER: konnte Bibliothek »/usr/lib/postgresql/plpgsql.so« nicht laden: /usr/lib/postgresql/plpgsql.so: undefined symbol: pg_re_throw
No one has a solution to this problem, so I will try to downgrad postgresql.
Can I use repositories for that? If yes, which ones?
No way… I added the 10.3 oss repo again, and checked the dependencies. Yast would downgrade not only postgresql, but also pidgin, libpurple, tcl, tk … and many more. That can’t be the solution…
Mixing distribution version repositories will break your system - infact you most likely already did a considerable amount of damage if you downgraded the postgre libs to 10.3 level.
Undefined symbol means your postgre files have mixed versions.
Yes, I realized that.
And I found a solution for lx-office.
- create a dump of the database or maybe two (to work with one of them)
- change all CREATE TABLE commands to end with “WITH OIDS”, like:
CREATE TABLE "Umsätze" (
"Kennzeichen" character(10) NOT NULL,
"Datum" date] NOT NULL,
"km-Stand" integer NOT NULL,
"Kostenart" character(1) NOT NULL,
) WITH OIDS;
- delete the old database
- import the changed dump (WITH OIDS) again
- lx-office 2.4.3 works again