bts tags 283957 wontfix thanks On Thu, Dec 02, 2004 at 04:29:20PM +0100, Emmanuel Charpentier wrote: > As of today (Dec 2, 2004), the native PostgreSQL driver (as packaged > by Peter Einsraut in odbc-postgresql) is *still* unable to report important > information to client programs, such as existent schemata, and, for example, > cannot be used from OpenOffice for view creation. A bug has been filed a > long time ago against odbc-postgresql, but things seems not good on this > front (the maintainer, wrote on Aug, 10, 2004 in a followup to bug #215943 : > "The ODBC 3 support (with unixODBC) in the 07.03.0200 driver is broken beyond > repair, so it is not reasonable to package this. The next upstream version > will be ODBC 3 exclusively and will be packaged when it's ready. :)").
> As an interim solytion, I went back to using self-compiled, unpackaged > unixODBC unstream version (which is at 2.2.10, btw) : *their* ODBC driver, > which still has some issues, BTW, at least allows for some important > day-to-day operations. But this solution has, of course, some drawbacks. > Could we have an optional package (such as unixodbc-drivers), which might be > suggested by unixODBC (and other relevant database packages) : this might > be a temporary help for people trying to use Postgres (and maybe other > databases) from OpenOffice and other GUIs. I believe that individual ODBC drivers in Debian need to be supported by people close to the RDBMS in question, not centrally by the unixodbc maintainer. AIUI, upstream agrees and is planning to break the ODBC drivers out of the unixodbc tarball in a future release. The psqlodbc maintainer is welcome to pull in unixodbc's Drivers/PostgreSQL for use as his upstream tarball, but I'm not interested in maintaining this as part of the unixodbc source package. > IIRC, I have also had some issues with *other* ODBC drivers (MySQL, isql, > IIRC). This is not as important to me as the POstgreSQL driver, since I > settled for PostgreSQL? But it might be important for other people. Uh, the MySQL driver in the UnixODBC source tree is imported *from* the version that ships as libmyodbc in Debian. If there are bugfixes in the UnixODBC-bundled version, then UnixODBC upstream needs to be passing those back to MyODBC upstream; if you know of specific bugs that apply to the Debian libmyodbc package but not to the MySQL driver bundled with UnixODBC, please tell me about them so I can kick the appropriate people. And "isql" isn't an ODBC driver, so I don't know what you're referring to there. -- Steve Langasek postmodern programmer
signature.asc
Description: Digital signature
