from a user report: > I emerged kexi 2.3.1. But there is no real support for postgresql (please > read on). I added the flag and so on. It compiled with it greatly. > > But, when I launch the app -> import database from a server > > I cannot select any driver (postgresql one in my case). Remains empty. > > I noticed that the defaut libpqxx is 2.6.9, whereas the last one is 3.0.2.
2.6.9 is probably not new enough to work with the latest versions of PostgreSQL. I think PgSQL 9.0 support was brought with libpqxx 3.0
http://pgfoundry.org/pipermail/libpqxx-general/2011-January/thread.html ^ This is about the only information that I could find, and it suggests that even libpqxx-3.1 (not in portage yet) is too old for postgres 9. However even after manual downgrading I did not find a working combination...
Created attachment 262251 [details] Kexi's build log Beware to the locale, you might experience some "?".
Created attachment 262255 [details] Emerge opts
Hmm this looks like in your case the postgresql driver is not even built. Can you try two things please: 1) enabling the postgres useflag on qt-sql, rebuilding qt-sql, then rebuilding kexi? 2) upgrading libpqxx to newest version in portage, then rebuilding kexi (with --nodeps if necessary)? In each case it's interesting * whether there is something like usr/lib64/kde4/kexidb_postgresdriver.so or similar * and whether you can select postgres database in the dialog Thanks!
(In reply to comment #5) > Hmm this looks like in your case the postgresql driver is not even built. > > Can you try two things please: > 1) enabling the postgres useflag on qt-sql, rebuilding qt-sql, then rebuilding > kexi? > 2) upgrading libpqxx to newest version in portage, then rebuilding kexi (with > --nodeps if necessary)? > > In each case it's interesting > * whether there is something like usr/lib64/kde4/kexidb_postgresdriver.so or > similar > * and whether you can select postgres database in the dialog > > Thanks! > Huum. No emerge possible w/o the deps. How could we tell the emerge package to link directly with libpqxx-3.0.2 ? Many thanks !
I just changed the kexi ebuild. In an hour or so it should also accept libpqxx-3.*
Ok, it is now working fine, Thank you Andreas, you made it greatly, See you
OK thanks... dependencies have been fixed.