Package: odbc-postgresql
Version: 1:08.03.0200-1.2
Severity: normal
Hi,
I have a database with a fairly complex view ("fairly complex" here
means that "explain select * from view" returns a query plan of more
than 70 rows). Having said that, when I call "select * from view", that
doesn't take too long -- at least not when I run it from the psql
command line.
If, however, I try the same thing from libreoffice using the PostgreSQL
ODBC driver, things go horribly wrong. At first I thought it was
something in libreoffice, but that turns out not to be the case;
enabling the query logger reveals that the PostgreSQL ODBC driver will
turn a simple query on a view into a bunch of prepared statements. It's
absolutely not clear to me what it exactly does, but it looks like it's
trying to run the view in the ODBC driver instead of letting postgresql
handle it. The result is that a query which takes less than a second on
the psql command line if the cache is hot, had not even produced a
result when I killed libreoffice half an hour after the point where I
called the query through the ODBC driver in libreoffice.
I doubt it's libreoffice itself, as switching to the JDBC driver rather
than the ODBC one made the problem go away.
-- System Information:
Debian Release: wheezy/sid
APT prefers testing-proposed-updates
APT policy: (500, 'testing-proposed-updates'), (500, 'oldstable'), (500,
'unstable'), (500, 'stable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.38-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=nl_BE.UTF-8, LC_CTYPE=nl_BE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages odbc-postgresql depends on:
ii libc6 2.11.2-13 Embedded GNU C Library: Shared lib
ii libpq5 9.0.3-1 PostgreSQL C client library
ii odbcinst1debian2 2.2.14p2-2 Support library for accessing odbc
odbc-postgresql recommends no packages.
Versions of packages odbc-postgresql suggests:
pn unixodbc-bin <none> (no description available)
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
