#124 PostArabic install on Ubuntu requires tweak to SQL file

[Andy Boyko]

When building and installing PostArabic 1.05 on Ubuntu Linux 7.04 and PostgreSQL 8.2.4, the SQL file /usr/share/postgresql/8.2/contrib/libarabic.sql refers to $libdir/libarabic.so, but the library is actually written to the name /usr/lib/postgresql/8.2/lib/arabic.so (without the 'lib' prefix), so the SQL cannot be imported because the path to the shared library is invalid. In order to load the libarabic.sql file, one must thus either edit the SQL, or symlink arabic.so to libarabic.so, at which point the SQL imports properly.

[Steffen Macke]

Logged In: YES
user_id=30248
Originator: NO

Thanks for the bug report.

The problem results from the dilemma between the PostgreSQL standard, which would encourage to use arabic.so and the previous builds, which have used libarabic.so.

A simple sed s/libarabic.so/arabic.so/ should solve the issue. This should be added the spec file.

I wasn't successfull in building an Ubuntu package. My current attempt on the openSUSE build system fails
because of a missing bzip2.
Could you provide a spec file or patch for this?

[Andy Boyko]

Logged In: YES
user_id=911462
Originator: YES

I don't have any experience with Ubuntu/Debian packaging, so I unfortunately can't offer any useful patches on this; for our needs, building PostArabic from source is sufficient, so anything that works with configure/make/make install would be fine. (Not sure if that makes a general solution easier or harder...)

Thanks for your help!

[Steffen Macke]

Logged In: YES
user_id=30248
Originator: NO

I hope that we can address this problem in the 1.0.6 release.

[Steffen Macke]

Logged In: YES
user_id=30248
Originator: NO

I'm able to build a *.deb package for Ubuntu 8.04/PostgreSQL 8.3 now (using the openSUSE build farm)

If you are interested to test the package, let me know.