[pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3: . docs/en_US src src/frm src/include
Author: dpage Date: 2006-01-09 10:38:49 + (Mon, 09 Jan 2006) New Revision: 4884 Added: trunk/pgadmin3/docs/en_US/commandline.html Modified: trunk/pgadmin3/CHANGELOG.txt trunk/pgadmin3/docs/en_US/pgadmin3.hhc trunk/pgadmin3/docs/en_US/pgadmin3.hhp.cached trunk/pgadmin3/docs/en_US/using.html trunk/pgadmin3/src/frm/frmMain.cpp trunk/pgadmin3/src/include/frmMain.h trunk/pgadmin3/src/pgAdmin3.cpp Log: Add -a and -q command line options to auto connect to a server and open a query window respectively [Magnus Hagander] Modified: trunk/pgadmin3/CHANGELOG.txt === --- trunk/pgadmin3/CHANGELOG.txt2006-01-09 09:31:15 UTC (rev 4883) +++ trunk/pgadmin3/CHANGELOG.txt2006-01-09 10:38:49 UTC (rev 4884) @@ -18,6 +18,7 @@ /ul br ul +li2006-01-09 DP Add -a and -q command line options to auto connect to a server and open a query window respectively [Magnus Hagander] li2006-01-09 DP 1.4.2 Honour the copy quoting setting properly in the SQL results pane [Magnus Hagander] li2006-01-09 DP Use Ctrl-A to select all results in the query results pane. [Magnus Hagander] li2006-01-09 DP 1.4.2 Set the initial Unicode/Local charset options correctly in the Export dialogue [Magnus Hagander] Added: trunk/pgadmin3/docs/en_US/commandline.html === --- trunk/pgadmin3/docs/en_US/commandline.html 2006-01-09 09:31:15 UTC (rev 4883) +++ trunk/pgadmin3/docs/en_US/commandline.html 2006-01-09 10:38:49 UTC (rev 4884) @@ -0,0 +1,40 @@ +html + +head +meta http-equiv=Content-Type content=text/html; charset=windows-1252 +link rel=STYLESHEET type=text/css href=pgadmin3.css +titleCommand Line Parameters/title +/head + +body + +h3Command Line Parameters/h3 +p +There are a number of command line options that may be passed to the pgAdmin executable +when starting it. +/p + +ul + lib-h/b Display command line option help.br /nbsp;/li + + lib-s lt;server descriptiongt;/b Auto connect to the specified server. lt;server descriptiongt; is the description + entered when you added the server to the treeview in pgAdmin, quoted if required. If multiple servers are registered with + the same description, the first found will be auto-connected.br /nbsp;/li + + lib-q/b Open a a href=query.htmlQuery Tool/a window upon connection. This option requires the + b-s lt;server descriptiongt;/b option.br /nbsp;/li + + lib-cm lt;config filegt;/b Edit the specified postgresql.conf config file.br /nbsp;/li + + lib-ch lt;hba filegt;/b Edit the specified pg_hba.conf config file.br /nbsp;/li + + lib-c lt;filegt;/b Edit the specified config file. pgAdmin will attempt to auto-detect what type of config file is + being editted.br /nbsp;/li + + lib-t/b Start in dialogue translation test mode. This mode allows each dialogue to be viewed without running the + application to assist with string translation.br /nbsp;/li +/ul + +/body + +/html Modified: trunk/pgadmin3/docs/en_US/pgadmin3.hhc === --- trunk/pgadmin3/docs/en_US/pgadmin3.hhc 2006-01-09 09:31:15 UTC (rev 4883) +++ trunk/pgadmin3/docs/en_US/pgadmin3.hhc 2006-01-09 10:38:49 UTC (rev 4884) @@ -106,6 +106,10 @@ param name=Name value=Guru Hints param name=Local value=guruhints.html /OBJECT + LI OBJECT type=text/sitemap + param name=Name value=Command Line Options + param name=Local value=commandline.html + /OBJECT /UL LI OBJECT type=text/sitemap param name=Name value=pgAgent Modified: trunk/pgadmin3/docs/en_US/pgadmin3.hhp.cached === (Binary files differ) Modified: trunk/pgadmin3/docs/en_US/using.html === --- trunk/pgadmin3/docs/en_US/using.html2006-01-09 09:31:15 UTC (rev 4883) +++ trunk/pgadmin3/docs/en_US/using.html2006-01-09 10:38:49 UTC (rev 4884) @@ -10,7 +10,7 @@ H3Using pgAdmin/H3 PThis section explains how you can use pgAdmin to maintain your -PostgreSQL databases. PgAdmin supports database server versions +PostgreSQL databases. pgAdmin supports database server versions 7.3 and up. Versions older than 7.3 are not supported, please use pgAdmin II for these./P UL @@ -44,6 +44,7 @@ LIPThe A HREF=options.htmlOptions/A dialogue will allow you to configure pgAdmin./P LIPA HREF=guruhints.htmlGuru Hints/A help you perfect your databases./P +LIPA HREF=commandline.htmlCommand Line Options/A to start pgAdmin in the most convenient mode./P /UL PWhen
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
hi! after checking out revision 4884 make fails with the following error: [EMAIL PROTECTED]:/net/programs/pgadmin-svn/pgadmin3]$ make make all-recursive make[1]: Entering directory `/usr/net/programs/pgadmin-svn/pgadmin3' Making all in i18n make[2]: Entering directory `/usr/net/programs/pgadmin-svn/pgadmin3/i18n' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/net/programs/pgadmin-svn/pgadmin3/i18n' Making all in src make[2]: Entering directory `/usr/net/programs/pgadmin-svn/pgadmin3/src' if g++ -DHAVE_CONFIG_H -I. -I. -I.. -DDATA_DIR=\/usr/local/pgadmin-svn/share/pgadmin3/\ -Wall -Wno-non-virtual-dtor -I../src/include -I../src/agent/include -I../src/slony/include -I/usr/include/pgsql -DSSL -I/usr/local/lib/wx/include/gtk2-unicode-debug-static-2.6 -I/usr/local/include/wx-2.6 -D__WXDEBUG__ -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 -g -O0 -DDATA_DIR=\/usr/local/pgadmin-svn/share/pgadmin3/\ -Wall -Wno-non-virtual-dtor -I../src/include -I../src/agent/include -I../src/slony/include -MT pgAdmin3.o -MD -MP -MF .deps/pgAdmin3.Tpo -c -o pgAdmin3.o `test -f './pgAdmin3.cpp' || echo './'`./pgAdmin3.cpp; \ then mv -f .deps/pgAdmin3.Tpo .deps/pgAdmin3.Po; else rm -f .deps/pgAdmin3.Tpo; exit 1; fi pgAdmin3.cpp: In member function `virtual bool pgAdmin3::OnInit()': pgAdmin3.cpp:420: error: `frmQuery' undeclared (first use this function) pgAdmin3.cpp:420: error: (Each undeclared identifier is reported only once for each function it appears in.) pgAdmin3.cpp:420: error: `fq' undeclared (first use this function) pgAdmin3.cpp:420: error: syntax error before `(' token make[2]: *** [pgAdmin3.o] Error 1 make[2]: Leaving directory `/usr/net/programs/pgadmin-svn/pgadmin3/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/net/programs/pgadmin-svn/pgadmin3' make: *** [all] Error 2 revision 4883 makes just fine. system is suse 9.3, gcc 3.3.4, wx 2.6.0. regards, Miha [EMAIL PROTECTED] wrote: Author: dpage Date: 2006-01-09 10:38:49 + (Mon, 09 Jan 2006) New Revision: 4884 ... ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Miha Radej Sent: 09 January 2006 14:56 To: pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3: hi! after checking out revision 4884 make fails with the following error: snip revision 4883 makes just fine. system is suse 9.3, gcc 3.3.4, wx 2.6.0. regards, Miha Does it build if you add 'include frmQuery.h' at the top of pgAdmin3.cpp (see how frmMain and some others are already included)? Regards, Dave. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
hi! Dave Page wrote: after checking out revision 4884 make fails with the following error: snip revision 4883 makes just fine. system is suse 9.3, gcc 3.3.4, wx 2.6.0. regards, Miha Does it build if you add 'include frmQuery.h' at the top of pgAdmin3.cpp (see how frmMain and some others are already included)? i have just been playing around and tried doing that :) no luck, though: [EMAIL PROTECTED]:/net/programs/pgadmin-svn/pgadmin3]$ make make all-recursive make[1]: Entering directory `/usr/net/programs/pgadmin-svn/pgadmin3' Making all in i18n make[2]: Entering directory `/usr/net/programs/pgadmin-svn/pgadmin3/i18n' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/net/programs/pgadmin-svn/pgadmin3/i18n' Making all in src make[2]: Entering directory `/usr/net/programs/pgadmin-svn/pgadmin3/src' if g++ -DHAVE_CONFIG_H -I. -I. -I.. -DDATA_DIR=\/usr/local/pgadmin-svn/share/pgadmin3/\ -Wall -Wno-non-virtual-dtor -I../src/include -I../src/agent/include -I../src/slony/include -I/usr/include/pgsql -DSSL -I/usr/local/lib/wx/include/gtk2-unicode-debug-static-2.6 -I/usr/local/include/wx-2.6 -D__WXDEBUG__ -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 -g -O0 -DDATA_DIR=\/usr/local/pgadmin-svn/share/pgadmin3/\ -Wall -Wno-non-virtual-dtor -I../src/include -I../src/agent/include -I../src/slony/include -MT pgAdmin3.o -MD -MP -MF .deps/pgAdmin3.Tpo -c -o pgAdmin3.o `test -f './pgAdmin3.cpp' || echo './'`./pgAdmin3.cpp; \ then mv -f .deps/pgAdmin3.Tpo .deps/pgAdmin3.Po; else rm -f .deps/pgAdmin3.Tpo; exit 1; fi pgAdmin3.cpp: In member function `virtual bool pgAdmin3::OnInit()': pgAdmin3.cpp:421: error: `CreateConn' undeclared (first use this function) pgAdmin3.cpp:421: error: (Each undeclared identifier is reported only once for each function it appears in.) make[2]: *** [pgAdmin3.o] Error 1 make[2]: Leaving directory `/usr/net/programs/pgadmin-svn/pgadmin3/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/net/programs/pgadmin-svn/pgadmin3' make: *** [all] Error 2 regards, Miha ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
-Original Message- From: Miha Radej [mailto:[EMAIL PROTECTED] Sent: 09 January 2006 15:16 To: Dave Page Cc: pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3: hi! Dave Page wrote: after checking out revision 4884 make fails with the following error: snip revision 4883 makes just fine. system is suse 9.3, gcc 3.3.4, wx 2.6.0. regards, Miha Does it build if you add 'include frmQuery.h' at the top of pgAdmin3.cpp (see how frmMain and some others are already included)? i have just been playing around and tried doing that :) no luck, though: OK, give me a few minutes - I'm just rebuilding my Slackware box - almost there now. It's most certainly a header issue - Magnus' patch was built on Windows, which I also tested it on, however Windows has precompiled headers which normally means we only need to include pgadmin3.h in each file. /D ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page Sent: 09 January 2006 15:21 To: Miha Radej Cc: pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3: OK, give me a few minutes - I'm just rebuilding my Slackware box - almost there now. It's most certainly a header issue - Magnus' patch was built on Windows, which I also tested it on, however Windows has precompiled headers which normally means we only need to include pgadmin3.h in each file. Fix committed - thanks for the report. Regards, Dave. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
hi! i've tinkered around a bit and it seems to work with the attached patch applied. pgadmin -q displayed the usage screen so i guess it should work. cheers, Miha Dave Page wrote: after checking out revision 4884 make fails with the following error: snip revision 4883 makes just fine. system is suse 9.3, gcc 3.3.4, wx 2.6.0. regards, Miha Does it build if you add 'include frmQuery.h' at the top of pgAdmin3.cpp (see how frmMain and some others are already included)? i have just been playing around and tried doing that :) no luck, though: OK, give me a few minutes - I'm just rebuilding my Slackware box - almost there now. It's most certainly a header issue - Magnus' patch was built on Windows, which I also tested it on, however Windows has precompiled headers which normally means we only need to include pgadmin3.h in each file. Index: src/pgAdmin3.cpp === --- src/pgAdmin3.cpp(revision 4885) +++ src/pgAdmin3.cpp(working copy) @@ -49,6 +49,8 @@ #include frmMain.h #include frmConfig.h #include frmSplash.h +#include frmQuery.h +#include pgServer.h #include wx/dir.h #include wx/fs_zip.h #include ctl/xh_calb.h ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
oops, sorry :) just sent an email with a success report and didn't see this email. cheers, Miha Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page Sent: 09 January 2006 15:21 To: Miha Radej Cc: pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3: OK, give me a few minutes - I'm just rebuilding my Slackware box - almost there now. It's most certainly a header issue - Magnus' patch was built on Windows, which I also tested it on, however Windows has precompiled headers which normally means we only need to include pgadmin3.h in each file. Fix committed - thanks for the report. Regards, Dave. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3:
-Original Message- From: Miha Radej [mailto:[EMAIL PROTECTED] Sent: 09 January 2006 15:50 To: Dave Page Cc: pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] SVN Commit by dpage: r4884 - in trunk/pgadmin3: oops, sorry :) just sent an email with a success report and didn't see this email. :-) Thanks for the patch anyhoo! Regards, Dave. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org