Public bug reported:
On amd64 certain 32 bit applications need 32 bit ODBC. An example is
wine.
Currently odbc-postgresql:i386 depends on libpq5:i386.
However, other 64bit packages depend on libpq5 (amd64) like pgadmin,
libreoffice-sdbc-postgresql.
Both can't be installed at the same time.
Probably libpq.so should be installed to /usr/lib/i386-linux-gnu/ to
install simultaneous installation.
A workaround is to manually download odbc-postgresql:i386 and
libpq5:i386. Then unpack so's to /usr/lib/i386-linux-gnu/odbc and
libpq5:i386 to /usr/lib/i386-linux-gnu.
Then modify odbcinst.ini to look like this:
[PostgreSQL Unicode]
Description = PostgreSQL ODBC driver (Unicode version)
Driver = /usr/lib/i386-linux-gnu/odbc/psqlodbcw.so
Driver64 = psqlodbcw.so
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcpsqlS.so
Setup64 = libodbcpsqlS.so
UsageCount = 1
CPTimeout =
CPTimeToLive =
DisableGetFunctions =
DontDLCLose =
ExFetchMapping =
Threading =
FakeUnicode =
IconvEncoding =
Trace =
TraceFile =
TraceLibrary =
Debug = 0
CommLog = 1
[PostgreSQL ANSI]
Description = PostgreSQL ODBC driver (ANSI version)
Driver = /usr/lib/i386-linux-gnu/odbc/psqlodbca.so
Driver64 = psqlodbca.so
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcpsqlS.so
Setup64 = libodbcpsqlS.so
UsageCount = 1
CPTimeout =
CPTimeToLive =
DisableGetFunctions =
DontDLCLose =
ExFetchMapping =
Threading =
FakeUnicode =
IconvEncoding =
Trace =
TraceFile =
TraceLibrary =
Debug = 0
CommLog = 1
Now wine, pgadmin, libreoffice will be able to coexist and run at the
same time.
Ferry
** Affects: postgresql-9.1 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to postgresql-9.1 in Ubuntu.
https://bugs.launchpad.net/bugs/1081517
Title:
i386 libpq5 conflict on amd64
Status in “postgresql-9.1” package in Ubuntu:
New
Bug description:
On amd64 certain 32 bit applications need 32 bit ODBC. An example is
wine.
Currently odbc-postgresql:i386 depends on libpq5:i386.
However, other 64bit packages depend on libpq5 (amd64) like pgadmin,
libreoffice-sdbc-postgresql.
Both can't be installed at the same time.
Probably libpq.so should be installed to /usr/lib/i386-linux-gnu/ to
install simultaneous installation.
A workaround is to manually download odbc-postgresql:i386 and
libpq5:i386. Then unpack so's to /usr/lib/i386-linux-gnu/odbc and
libpq5:i386 to /usr/lib/i386-linux-gnu.
Then modify odbcinst.ini to look like this:
[PostgreSQL Unicode]
Description = PostgreSQL ODBC driver (Unicode version)
Driver = /usr/lib/i386-linux-gnu/odbc/psqlodbcw.so
Driver64 = psqlodbcw.so
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcpsqlS.so
Setup64 = libodbcpsqlS.so
UsageCount = 1
CPTimeout =
CPTimeToLive =
DisableGetFunctions =
DontDLCLose =
ExFetchMapping =
Threading =
FakeUnicode =
IconvEncoding =
Trace =
TraceFile =
TraceLibrary =
Debug = 0
CommLog = 1
[PostgreSQL ANSI]
Description = PostgreSQL ODBC driver (ANSI version)
Driver = /usr/lib/i386-linux-gnu/odbc/psqlodbca.so
Driver64 = psqlodbca.so
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcpsqlS.so
Setup64 = libodbcpsqlS.so
UsageCount = 1
CPTimeout =
CPTimeToLive =
DisableGetFunctions =
DontDLCLose =
ExFetchMapping =
Threading =
FakeUnicode =
IconvEncoding =
Trace =
TraceFile =
TraceLibrary =
Debug = 0
CommLog = 1
Now wine, pgadmin, libreoffice will be able to coexist and run at the
same time.
Ferry
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/1081517/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
