Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-16 Thread Hiroshi Saito
Hi. Yeah, I did slightly interesting approach by OSC. http://winpg.jp/~saito/pgAdmin/OSC2008Fukuoka.ppt But , It is Japanese:-) Good document! I can read it slowly. Yey, :-) Next, I will talk here. (20th)! http://www.ospn.jp/osc2009-spring/ However, one session is plproxy+pgbouncer. and,

[pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Quan Zongliang
Hi All, The wxWidgets framework has some classes relative to ODBC: wxDb/wxDbTable and so on. Them is controlled by identifier wxUSE_ODBC. Default is 0, that is, don't compiling with wxWidgets. My idea is only support this function (import from ODBC) under MS-Windows using Microsoft API. Although

Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Dave Page
On Wed, Jan 14, 2009 at 1:21 PM, Guillaume Lelarge guilla...@lelarge.info wrote: I don't quite understand why we would want to use ODBC in pgAdmin. One thing that makes pgAdmin great is its use of libpq. Can someone explain me why we should use ODBC ? To import data from diverse data sources.

Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Magnus Hagander
Dave Page wrote: On Wed, Jan 14, 2009 at 12:14 PM, Quan Zongliang quanzongli...@gmail.com wrote: Hi All, The wxWidgets framework has some classes relative to ODBC: wxDb/wxDbTable and so on. Them is controlled by identifier wxUSE_ODBC. Default is 0, that is, don't compiling with wxWidgets.

Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Dave Page
On Wed, Jan 14, 2009 at 1:38 PM, Guillaume Lelarge guilla...@lelarge.info wrote: Dave Page a écrit : On Wed, Jan 14, 2009 at 1:21 PM, Guillaume Lelarge guilla...@lelarge.info wrote: I don't quite understand why we would want to use ODBC in pgAdmin. One thing that makes pgAdmin great is its

Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Quan Zongliang
Without using wxUSE_ODBC, I don't see that you'll be able to do this nicely in a cross platform way. I suppose you could allow the user to select the ODBC driver libraries (eg. psqlodbc.so) directly, but that will mean that DSNs can't be used. Initially, my plan is only implement ODBC under

Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Hiroshi Saito
Hi. I don't quite understand why we would want to use ODBC in pgAdmin. One thing that makes pgAdmin great is its use of libpq. Can someone explain me why we should use ODBC ? I think that it will use when the Postgres itself has a linkserver function. Probably, it seems to be a SQLServer

Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Magnus Hagander
Hiroshi Saito wrote: Hi. I don't quite understand why we would want to use ODBC in pgAdmin. One thing that makes pgAdmin great is its use of libpq. Can someone explain me why we should use ODBC ? I think that it will use when the Postgres itself has a linkserver function. Probably, it

Re: [pgadmin-hackers] Import: about ODBC data source

2009-01-14 Thread Hiroshi Saito
Hi. While that would be nice to have, I still think it would make a lot of sense to be able to do it from pgAdmin as well. It's not at all uncommon to load things from say an access database or even an excel spreadsheet, and you don't necessarily want to have those on your db server... Yeah,