11.0 Postgresql Downgrade Repositories

skywalka_de · 15-Jul-2008, 01:21

Hello,

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.

Error:

Code:

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?

skywalka_de · 15-Jul-2008, 01:48

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

**Chrysantine** · 15-Jul-2008, 02:35

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.

skywalka_de · 15-Jul-2008, 03:21

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:

Code:

CREATE TABLE "Ums&#228;tze" (
"Kennzeichen" character(10) NOT NULL,
"Datum" date[] NOT NULL,
"km-Stand" integer NOT NULL,
"Kostenart" character(1) NOT NULL,
"Betrag" money
) WITH OIDS;

- delete the old database
- import the changed dump (WITH OIDS) again
- lx-office 2.4.3 works again