[pgadmin-hackers] SVN Commit by hiroshi: r7554 - trunk/pgadmin3/pgadmin/frm
Author: hiroshi Date: 2009-01-14 17:27:50 + (Wed, 14 Jan 2009) New Revision: 7554 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7554&view=rev Log: Fix display problem of dbname. Modified: trunk/pgadmin3/pgadmin/frm/frmQuery.cpp -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
[pgadmin-hackers] Graphical query builder's object tree problem.
Hi. I see a graphical query builder's problem. http://winpg.jp/~saito/pgAdmin/20090114_QB_1.png An object tree does not appear.:-( Then, click operation of the pane is begin view. http://winpg.jp/~saito/pgAdmin/20090114_QB_2.png Does someone work on this problem? Regards, Hiroshi Saito -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
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, I did slightly interesting approach by OSC. http://winpg.jp/~saito/pgAdmin/OSC2008Fukuoka.ppt But , It is Japanese:-) Regards, Hiroshi Saito -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
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 seems to be a SQLServer Manager. :-) > But, It seems that however, it is still far 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... //Magnus -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
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 Manager. :-) But, It seems that however, it is still far Regards, Hiroshi Saito -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
> 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 MS-Windows. Because I have some experience with it. Until I found the wxODBC. And almost all works I did is under Windows, so I have the illusion that other playform scarcely use ODBC. Well, no question about this yet. Thanks. --- Quan Zongliang quanzongli...@gmail.com CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
On Wed, Jan 14, 2009 at 1:38 PM, Guillaume Lelarge wrote: > Dave Page a écrit : >> On Wed, Jan 14, 2009 at 1:21 PM, Guillaume Lelarge >> 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. >> > > Ohhh, /me feeling stupid. Need more caffeine... or more sleep. :-D -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
Dave Page wrote: > On Wed, Jan 14, 2009 at 12:14 PM, Quan Zongliang > 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. >> >> My idea is only support this function (import from ODBC) under MS-Windows >> using Microsoft API. Although there is iODBC (http://www.iodbc.org) >> under Unix implemented the ODBC API. > > iODBC is used on Mac, but in my experience, unixODBC is more popular > on Linux. I don't know what is used on Solaris or the BSDs. I'm not > keen on the idea of only offering functionality on one platform. > > 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. > > Anyone else got any thoughts? One thing that would be very useful on Unix, I think, would be to be able to use DBD drivers. I guess if we flip back to the discussion from earlier, this could be handled if we integrated python (or perl for DBD, but since we were considering python in a general sense). Then we could generate a datastream from any driver there. However, I'm unsure if those drivers provide things like "enumerating tables", but it's probably possible to do that through a very thing db wrapper (we'd only need the table name - all other metadata required to transfer the *data* is available in the api) //Magnus -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
Dave Page a écrit : > On Wed, Jan 14, 2009 at 1:21 PM, Guillaume Lelarge > 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. > Ohhh, /me feeling stupid. Need more caffeine... or more sleep. Sorry about this. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
On Wed, Jan 14, 2009 at 1:21 PM, Guillaume Lelarge 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. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
Dave Page a écrit : > On Wed, Jan 14, 2009 at 12:14 PM, Quan Zongliang > 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. >> >> My idea is only support this function (import from ODBC) under MS-Windows >> using Microsoft API. Although there is iODBC (http://www.iodbc.org) >> under Unix implemented the ODBC API. > > iODBC is used on Mac, but in my experience, unixODBC is more popular > on Linux. I don't know what is used on Solaris or the BSDs. I'm not > keen on the idea of only offering functionality on one platform. > > 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. > > Anyone else got any thoughts? > 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 ? -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Import: about ODBC data source
On Wed, Jan 14, 2009 at 12:14 PM, Quan Zongliang 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. > > My idea is only support this function (import from ODBC) under MS-Windows > using Microsoft API. Although there is iODBC (http://www.iodbc.org) > under Unix implemented the ODBC API. iODBC is used on Mac, but in my experience, unixODBC is more popular on Linux. I don't know what is used on Solaris or the BSDs. I'm not keen on the idea of only offering functionality on one platform. 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. Anyone else got any thoughts? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
[pgadmin-hackers] Import: about ODBC data source
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 there is iODBC (http://www.iodbc.org) under Unix implemented the ODBC API. OK? Regards. --- Quan Zongliang quanzongli...@gmail.com CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] SVN Commit by dpage: r7552 - in trunk/pgadmin3/pgadmin: . ctl frm
On Wed, Jan 14, 2009 at 11:10 AM, Quan Zongliang wrote: > >> Modified: >>trunk/pgadmin3/pgadmin/ctl/ctlSQLBox.cpp > > > I got compile error: >...ctlsqlbox.cpp(567) : error C2653: 'wxSystemOptions' : is not a class or > namespace name >...ctlsqlbox.cpp(567) : error C3861: 'SetOption': identifier not found >...ctlsqlbox.cpp(575) : error C2653: 'wxSystemOptions' : is not a class or > namespace name >...ctlsqlbox.cpp(575) : error C3861: 'SetOption': identifier not found Oops, sorry. Should be fixed now. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
[pgadmin-hackers] SVN Commit by dpage: r7553 - in trunk/pgadmin3/pgadmin: ctl frm
Author: dpage Date: 2009-01-14 11:45:37 + (Wed, 14 Jan 2009) New Revision: 7553 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7553&view=rev Log: Only use wxSystemOptions::SetOption on Mac where we actually need it. Modified: trunk/pgadmin3/pgadmin/ctl/ctlSQLBox.cpp trunk/pgadmin3/pgadmin/frm/frmMain.cpp -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] SVN Commit by dpage: r7552 - in trunk/pgadmin3/pgadmin: . ctl frm
> Modified: >trunk/pgadmin3/pgadmin/ctl/ctlSQLBox.cpp I got compile error: ...ctlsqlbox.cpp(567) : error C2653: 'wxSystemOptions' : is not a class or namespace name ...ctlsqlbox.cpp(567) : error C3861: 'SetOption': identifier not found ...ctlsqlbox.cpp(575) : error C2653: 'wxSystemOptions' : is not a class or namespace name ...ctlsqlbox.cpp(575) : error C3861: 'SetOption': identifier not found wxWidgets 2.8.9 for windows with "#define wxUSE_SYSTEM_OPTIONS 1" include path: $(WXWIN)/include ( wx/sysopt.h is here. ) $(WXWIN)/contrib/include ... I tried to add the line: wxSystemOptions::SetOption(wxT("mac.listctrl.always_use_generic"), false); to wxWidgets project's cpp file, it's ok without compile error. How to correct my config? --- Quan Zongliang quanzongli...@gmail.com CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
[pgadmin-hackers] SVN Commit by dpage: r7552 - in trunk/pgadmin3/pgadmin: . ctl frm
Author: dpage Date: 2009-01-14 10:21:57 + (Wed, 14 Jan 2009) New Revision: 7552 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7552&view=rev Log: Add a hack to switch between the native and generic wxListCtrl on Mac. The native control has issues with multi-select when used on frmMain and by the autocomplete menu used by wxSTC. The generic control has sizing issues when used in the dialogues. These issues exist with wxWidgets <= 2.8.9 Modified: trunk/pgadmin3/pgadmin/ctl/ctlSQLBox.cpp trunk/pgadmin3/pgadmin/frm/frmMain.cpp trunk/pgadmin3/pgadmin/pgAdmin3.cpp -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
[pgadmin-hackers] SVN Commit by dpage: r7551 - trunk/pgadmin3/pgadmin/frm
Author: dpage Date: 2009-01-14 10:13:29 + (Wed, 14 Jan 2009) New Revision: 7551 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7551&view=rev Log: Display a message if we can't display a hint. Modified: trunk/pgadmin3/pgadmin/frm/frmHint.cpp -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
[pgadmin-hackers] SVN Commit by dpage: r7550 - trunk/pgadmin3/pgadmin/frm
Author: dpage Date: 2009-01-14 10:07:55 + (Wed, 14 Jan 2009) New Revision: 7550 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7550&view=rev Log: Prevent a crash occuring if the Hint menu option is selected on Mac at an inappropriate time. It seems that our attempts to disable the menu option on that platform get ignored. Modified: trunk/pgadmin3/pgadmin/frm/frmHint.cpp -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Patch: database version check
On Wed, Jan 14, 2009 at 2:20 AM, Quan Zongliang wrote: > BTW: > With import function, some base class changed. > Two new methods: CanImport and CanExport added to pgObject class. > For pgTable, if it has column, both return true. If not, both return false. > For pgView, CanImport return false and CanExport return true. > > As them are base class. Apply them now? Do you expect to have the whole patch ready in the next 2 or 3 weeks? If not, I'd rather wait until after we branch 1.10. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] about new module to software
On Wed, Jan 14, 2009 at 1:22 AM, Quan Zongliang wrote: >> Yeah - I don't think that one is too difficult. There's more to it >> than you've shown of course - there's code to populate the lists and >> to setup the columns to use them for example. > > I mean we should reduce redundant code, reuse existed code as possible. > The hackers should cooperate when working on that functions with similar > components. Oh, of course. I certainly agree with that. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers