On Fri, Apr 14, 2006 at 04:53:53PM +0200, Martijn van Oosterhout wrote: > Sounds really good. <snip>
There's a message on the pgsql-odbc mailing list[1] with some reasons for not using libpq: 1. The driver sets some session default parameters(DateStyle, client_encoding etc) using start-up message. As far as I can see it only does this when the environment variables are set. Which IMHO is the correct behaviour. If psqlodbc doesn't honour them that does violate the principle of least surprise. OTOH, the users of ODBC possibly shouldn't be affected by the environment variables of the user, given the user of ODBC likely doesn't know (or care) that PostgreSQL is involved. 2. You can try V2 protocol implementation when the V3 implementation has some bugs or performance issues. Well, there is a point here, you can't force the version. It always defaults to 3 if available. 3. Quote: I don't know what libraries the libpq would need in the future but it's quite unpleasant for me if the psqlodbc driver can't be loaded with the lack of needeless librairies. It's a reason, just not a good one IMHO. If the user has installed libpq with a number of libraries, then that's what the user wants. I'm not sure why psqlODBC is worried about that. So while this thread has produced several good ideas (which possibly should be implemented regardless), perhaps we should focus on these issues also. Have a nice day, [1] http://archives.postgresql.org/pgsql-odbc/2006-04/msg00052.php -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
signature.asc
Description: Digital signature