Re: [pgadmin-hackers] Compiling pgAdmin on SuSE 10.1
Hi! Dave Page pravi: ./frm/frmReport.cpp: In member function 'virtual void reportObjectDataDictionaryFactory::GenerateReport(frmReport*, pgObject*)': ./frm/frmReport.cpp:1335: warning: cannot pass objects of non-POD type 'class wxString' through '...'; call will abort at runtime Yeah, these ones only fail on GCC - it's complaining about passing a wxString as a parameter to a variadic function. The fix is to use the c_str() member, eg. The above warnings are now gone, but I noticed these now: ./frm/frmEditGrid.cpp: In member function ‘void sqlTable::Paste()’: ./frm/frmEditGrid.cpp:1840: warning: comparison between signed and unsigned integer expressions ./frm/frmEditGrid.cpp:1841: warning: comparison between signed and unsigned integer expressions ./frm/frmEditGrid.cpp:1856: warning: comparison between signed and unsigned integer expressions ./frm/frmEditGrid.cpp:1857: warning: comparison between signed and unsigned integer expressions The attached patch is yet another works for me kind of patch, I don't know what good/standard C++ practice is in such situations, considering I don't know C++ at all :) Regards, Miha -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods Index: src/frm/frmEditGrid.cpp === --- src/frm/frmEditGrid.cpp (revision 5211) +++ src/frm/frmEditGrid.cpp (working copy) @@ -1837,8 +1837,8 @@ skipSerial = false; for (col = 0; col nCols; col++) { -if ((unsigned int)columns[col].type == PGOID_TYPE_SERIAL || -(unsigned int)columns[col].type == PGOID_TYPE_SERIAL8) +if ((unsigned int)columns[col].type == (unsigned int)PGOID_TYPE_SERIAL || +(unsigned int)columns[col].type == (unsigned int)PGOID_TYPE_SERIAL8) { wxMessageDialog msg(GetView()-GetParent(), _(This table contains serial columns. Do you want to use the values in the clipboard for these columns?), @@ -1853,8 +1853,8 @@ for (col = (hasOids ? 1 : 0); col nCols col (int)data.GetCount(); col++) { -if (!(skipSerial ((unsigned int)columns[col].type == PGOID_TYPE_SERIAL || -(unsigned int)columns[col].type == PGOID_TYPE_SERIAL8))) +if (!(skipSerial ((unsigned int)columns[col].type == (unsigned int)PGOID_TYPE_SERIAL || +(unsigned int)columns[col].type == (unsigned int)PGOID_TYPE_SERIAL8))) { SetValue(row, col, data.Item(col)); } ---(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
[pgadmin-hackers] Compiling pgAdmin on SuSE 10.1
Hi! I tried to compile pgAdmin on a Suse 10.1 system, using a fresh SVN checkout (rev 5210). Attached is a patch with changes I had to apply in order to be able to compile pgAdmin. I also got the following warnings while compiling pgAdmin - got them before and after adding the headers, only line numbers differ: ./frm/frmReport.cpp: In member function ‘virtual void reportObjectDataDictionaryFactory::GenerateReport(frmReport*, pgObject*)’: ./frm/frmReport.cpp:1335: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1335: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1335: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1335: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1335: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1341: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1389: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1389: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime ./frm/frmReport.cpp:1389: warning: cannot pass objects of non-POD type ‘class wxString’ through ‘...’; call will abort at runtime Suse 10.1 comes with gcc v 4.1.0 if this info is of any help and with some headaches in order to compile pgAdmin, at least for someone like me :) Regards, Miha -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods Index: src/include/ctl/ctlSQLResult.h === --- src/include/ctl/ctlSQLResult.h (revision 5210) +++ src/include/ctl/ctlSQLResult.h (working copy) @@ -65,7 +65,7 @@ int RunStatus(); wxString GetMessagesAndClear(); wxString GetErrorMessage(); -pgError ctlSQLResult::GetResultError(); +pgError GetResultError(); void DisplayData(bool single=false); Index: src/include/ctl/ctlSQLGrid.h === --- src/include/ctl/ctlSQLGrid.h (revision 5210) +++ src/include/ctl/ctlSQLGrid.h (working copy) @@ -28,8 +28,8 @@ int Copy(); virtual bool CheckRowPresent(int row) { return true; } -wxSize ctlSQLGrid::GetBestSize(int row, int col); -void ctlSQLGrid::OnLabelDoubleClick(wxGridEvent event); +wxSize GetBestSize(int row, int col); +void OnLabelDoubleClick(wxGridEvent event); }; #endif Index: src/frm/frmReport.cpp === --- src/frm/frmReport.cpp (revision 5210) +++ src/frm/frmReport.cpp (working copy) @@ -29,6 +29,9 @@ #include pgColumn.h #include pgConstraints.h #include pgaJob.h +#include pgForeignKey.h +#include pgIndexConstraint.h +#include pgCheck.h // XML2/XSLT headers #include libxml/xmlmemory.h ---(end of broadcast)--- TIP 6: explain analyze is your friend
[pgadmin-hackers] Problem in graphical explain
Hi! I have some tables and playing with a query and graphical explain got me to a strange result - a grey line across the entire window; see http://mcajvar.prkoritu.net/pgadmin/graphic_explain_db1.png . I then made an exact duplicate copy of the users, database, everything I could think of and tried to duplicate the strange display. But the problem wouldn't occur in this local copy; see http://mcajvar.prkoritu.net/pgadmin/graphic_explain_db2.png . Does pgAdmin use the output of the explain query in order to construct the graphic illustration? If so then these may be helpful: This yields foo graphics: Nested Loop (cost=0.00..0.01 rows=1 width=485) Join Filter: (outer.id = inner.id_eventi) - Seq Scan on eventi t1 (cost=0.00..0.00 rows=1 width=12) Filter: ((datum = '2006-04-12 00:00:00'::timestamp without time zone) AND (datum = '2006-05-12 00:00:00'::timestamp without time zone) AND (prikaz = 1::smallint)) - Seq Scan on eventi_vsebina t2 (cost=0.00..0.00 rows=1 width=477) Filter: (narocilnica = 1::smallint) This yields a nice illustration: Nested Loop (cost=0.00..47.26 rows=1 width=485) Join Filter: (outer.id = inner.id_eventi) - Seq Scan on eventi t1 (cost=0.00..35.38 rows=1 width=12) Filter: ((datum = '2006-04-12 00:00:00'::timestamp without time zone) AND (datum = '2006-05-12 00:00:00'::timestamp without time zone) AND (prikaz = 1::smallint)) - Seq Scan on eventi_vsebina t2 (cost=0.00..11.88 rows=1 width=477) Filter: (narocilnica = 1::smallint) I tried refreshing multiple times in both databases, the results were always the same. The foo display happens when working on a remote database on Server 1, while the local tests were done on Server 2: Server 1: 8.0.1 on DragonFlyBSD 1.2.6, compiled by GCC 2.95.4 Server 2: 8.0.3 on SuSE Linux 10.0, compiled by GCC 4.0.2 If there is any other info I can provide in order to help diagnose the problem, let me know. Regards, Miha ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] [pgadmin-support] Feature request - option
Hi! So... something like this? Regards, Miha Dave Page wrote: Looks good to me in principle - my only thought is that --disable-docs should probably disable all docs, not just the slony and PG ones. Perhaps --disable-external-docs? Agreed. A pgadmin-doc-only-without-pg-and-slony option would require a different help index file without pg or slony references. That's a point - in which case, --disable-docs seems correct, except it should disable everything. We aren't going to start maintaining two sets of help indexes (damn things are pita already!). Index: acinclude.m4 === --- acinclude.m4 (revision 5075) +++ acinclude.m4 (working copy) @@ -216,6 +216,25 @@ ]) ]) +# +# Check whether to skip installation of documentation provided with pgAdmin III # +# +AC_DEFUN([DISABLE_DOCS], +[ + AC_ARG_ENABLE(docs, [ --disable-docsdisable installation of documentation], + [ + if test $enableval = yes + then + INSTALL_DOCS=yes + else + INSTALL_DOCS=no + fi + ], + [ + INSTALL_DOCS=yes + ]) +]) + # # Check for libpq libraries and headers # # @@ -447,6 +466,12 @@ else echo Building a Mac OS X appbundle: No fi + if test $INSTALL_DOCS == yes + then + echo Include documentation: Yes + else + echo Include documentation: No + fi echo echo pgAdmin configuration is now complete. You can now compile and Index: configure.ac.in === --- configure.ac.in (revision 5075) +++ configure.ac.in (working copy) @@ -32,7 +32,9 @@ ENABLE_DEBUG ENABLE_STATIC ENABLE_APPBUNDLE +DISABLE_DOCS AM_CONDITIONAL([APPBUNDLE], [test x$BUILD_APPBUNDLE = xyes]) +AM_CONDITIONAL([INSTALL_DOCS], [test x$INSTALL_DOCS = xyes]) LOCATE_POSTGRESQL SETUP_POSTGRESQL Index: Makefile.am === --- Makefile.am (revision 5075) +++ Makefile.am (working copy) @@ -19,19 +19,15 @@ $(top_srcdir)/TODO \ $(top_srcdir)/bootstrap \ $(top_srcdir)/configure.ac.in \ -$(top_srcdir)/languages.hwx \ -$(top_srcdir)/languages.po \ -$(top_srcdir)/pgadmin3-release.pot \ -$(top_srcdir)/pgadmin3.pot \ -$(top_srcdir)/stringextract \ -$(top_srcdir)/stringextract.bat \ -$(top_srcdir)/stringmerge + $(top_srcdir)/languages.hwx \ + $(top_srcdir)/languages.po \ + $(top_srcdir)/pgadmin3-release.pot \ + $(top_srcdir)/pgadmin3.pot \ + $(top_srcdir)/stringextract \ + $(top_srcdir)/stringextract.bat \ + $(top_srcdir)/stringmerge -TMP_docs = \ - $(top_srcdir)/docs/en_US/pg/*.css \ - $(top_srcdir)/docs/en_US/pg/*.html \ - $(top_srcdir)/docs/en_US/slony/*.css \ - $(top_srcdir)/docs/en_US/slony/*.html \ +TMP_docs_local = \ $(top_srcdir)/docs/en_US/hints/*.html \ $(top_srcdir)/docs/en_US/images/*.png \ $(top_srcdir)/docs/en_US/*.html \ @@ -40,7 +36,7 @@ $(top_srcdir)/docs/en_US/tips.txt \ $(top_srcdir)/docs/de_DE/tips.txt \ $(top_srcdir)/docs/de_DE/hints/*.html \ -$(top_srcdir)/docs/es_ES/tips.txt \ + $(top_srcdir)/docs/es_ES/tips.txt \ $(top_srcdir)/docs/es_ES/hints/*.html \ $(top_srcdir)/docs/fr_FR/*.html \ $(top_srcdir)/docs/fr_FR/tips.txt \ @@ -48,6 +44,18 @@ $(top_srcdir)/docs/sl_SI/tips.txt \ $(top_srcdir)/docs/sl_SI/hints/*.html +TMP_docs_external = $(top_srcdir)/docs/en_US/pg/*.css \ + $(top_srcdir)/docs/en_US/pg/*.html \ + $(top_srcdir)/docs/en_US/slony/*.css \ + $(top_srcdir)/docs/en_US/slony/*.html + +if INSTALL_DOCS +TMP_docs = $(TMP_docs_local) \ + $(TMP_docs_external) +else +TMP_docs = +endif + if !APPBUNDLE nobase_dist_pkgdata_DATA = $(TMP_docs) else ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] [pgadmin-support] Feature request - option to exclude docs when
Hi! I've been playing around a bit with this and I am sending attached a patch which Works For Me(tm). Since this was my first stab at anything such as this, I do hope it isn't too horrible :) The thought was to provide a configure option with which to disable installation of non-pgAdmin documentation: PostgreSQL and Slony docs. With the switch omitted, all the documentation should install. Like I said, this works for me, I've played around a bit and it Seems To Work(tm) :) Regards, Miha Dave Page wrote: I have the following feature request: is it possible to add an option (maybe at configure time?) which would cause make install to exclude installation of the documentation (at least the PostgreSQL and Slony docs)? Funny, I had the same thought last night when running 'make install' into a mac appbundle for the umpteenth time! Index: acinclude.m4 === --- acinclude.m4 (revision 5075) +++ acinclude.m4 (working copy) @@ -216,6 +216,25 @@ ]) ]) +# +# Check whether to skip installation of external documentation with pgAdmin III # +# +AC_DEFUN([DISABLE_EXTERN_DOCS], +[ + AC_ARG_ENABLE(docs, [ --disable-docs disable installation of external documentation], + [ + if test $enableval = yes + then + INSTALL_EXTERN_DOCS=yes + else + INSTALL_EXTERN_DOCS=no + fi + ], + [ + INSTALL_EXTERN_DOCS=yes + ]) +]) + # # Check for libpq libraries and headers # # @@ -447,6 +466,12 @@ else echo Building a Mac OS X appbundle: No fi + if test $INSTALL_EXTERN_DOCS == yes + then + echo Include external documentation: Yes + else + echo Include external documentation: No + fi echo echo pgAdmin configuration is now complete. You can now compile and Index: configure.ac.in === --- configure.ac.in (revision 5075) +++ configure.ac.in (working copy) @@ -32,7 +32,9 @@ ENABLE_DEBUG ENABLE_STATIC ENABLE_APPBUNDLE +DISABLE_EXTERN_DOCS AM_CONDITIONAL([APPBUNDLE], [test x$BUILD_APPBUNDLE = xyes]) +AM_CONDITIONAL([EXTERN_DOCS], [test x$INSTALL_EXTERN_DOCS = xyes]) LOCATE_POSTGRESQL SETUP_POSTGRESQL Index: Makefile.am === --- Makefile.am (revision 5075) +++ Makefile.am (working copy) @@ -19,19 +19,15 @@ $(top_srcdir)/TODO \ $(top_srcdir)/bootstrap \ $(top_srcdir)/configure.ac.in \ -$(top_srcdir)/languages.hwx \ -$(top_srcdir)/languages.po \ -$(top_srcdir)/pgadmin3-release.pot \ -$(top_srcdir)/pgadmin3.pot \ -$(top_srcdir)/stringextract \ -$(top_srcdir)/stringextract.bat \ -$(top_srcdir)/stringmerge + $(top_srcdir)/languages.hwx \ + $(top_srcdir)/languages.po \ + $(top_srcdir)/pgadmin3-release.pot \ + $(top_srcdir)/pgadmin3.pot \ + $(top_srcdir)/stringextract \ + $(top_srcdir)/stringextract.bat \ + $(top_srcdir)/stringmerge -TMP_docs = \ - $(top_srcdir)/docs/en_US/pg/*.css \ - $(top_srcdir)/docs/en_US/pg/*.html \ - $(top_srcdir)/docs/en_US/slony/*.css \ - $(top_srcdir)/docs/en_US/slony/*.html \ +TMP_docs_local = \ $(top_srcdir)/docs/en_US/hints/*.html \ $(top_srcdir)/docs/en_US/images/*.png \ $(top_srcdir)/docs/en_US/*.html \ @@ -40,7 +36,7 @@ $(top_srcdir)/docs/en_US/tips.txt \ $(top_srcdir)/docs/de_DE/tips.txt \ $(top_srcdir)/docs/de_DE/hints/*.html \ -$(top_srcdir)/docs/es_ES/tips.txt \ + $(top_srcdir)/docs/es_ES/tips.txt \ $(top_srcdir)/docs/es_ES/hints/*.html \ $(top_srcdir)/docs/fr_FR/*.html \ $(top_srcdir)/docs/fr_FR/tips.txt \ @@ -48,6 +44,18 @@ $(top_srcdir)/docs/sl_SI/tips.txt \ $(top_srcdir)/docs/sl_SI/hints/*.html +TMP_docs_extern = $(top_srcdir)/docs/en_US/pg/*.css \ + $(top_srcdir)/docs/en_US/pg/*.html \ + $(top_srcdir)/docs/en_US/slony/*.css \ + $(top_srcdir)/docs/en_US/slony/*.html + +if EXTERN_DOCS +TMP_docs = $(TMP_docs_local) \ + $(TMP_docs_extern) +else +TMP_docs = $(TMP_docs_local) +endif + if !APPBUNDLE nobase_dist_pkgdata_DATA = $(TMP_docs) else ---(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] view data causes pgadmin to hang or die
Hi! Now that you mention it... I've played around a bit and I've observed the following. The View Data function: crashes or hangs regardless of any settings. The Query tool: it wasn't a problem. I said select * from table; and it happily displayed the results. The result set returned more than 100 rows (the limit set in options) so the query tool asked me if I wanted to display everything. I said Yes and of 204 records only 101 got displayed. I then increased the max number of returned rows to 500 and again I only got 101 row. The View Data works OK on any other table I have so I'm really baffled by this. The query tool however limits the display to 101 tuples, regardless of the row limit settings. Btw, any ideas on the build error in the previous mail? I have no ideas what to do to make it happen :) Regards, Miha Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Miha Radej Sent: 28 March 2006 08:27 To: pgadmin-hackers Subject: Re: [pgadmin-hackers] view data causes pgadmin to hang or die i have a table with 204 rows of data which contain about 700k of text alltogether. when i tried to use view data in the table, pgadmin either crashes or hangs, no apparent pattern so far. in pgadmin log, set to debug, there is nothing to indicate the problem. but according to it (and to pgsql log) it seems pgadmin gets the data, then sends a query to get the column names. here are the last lines from pgsql log: Does the query tool display it properly if you increase the Max characters per column option under File-Options-Query so it is large enough to hold the data? Regards, Dave ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] view data causes pgadmin to hang or die
Hi! Dave Page wrote: Now that you mention it... I've played around a bit and I've observed the following. The View Data function: crashes or hangs regardless of any settings. The Query tool: it wasn't a problem. I said select * from table; and it happily displayed the results. The result set returned more than 100 rows (the limit set in options) so the query tool asked me if I wanted to display everything. I said Yes and of 204 records only 101 got displayed. I then increased the max number of returned rows to 500 and again I only got 101 row. OK, but what if you increase the max column size as I suggested? If it's a grid problem, the data truncation in the query tool might be masking it. Hmm, yes, sorry, I tried it but forgot to report it. I tried increasing the column size to various values, from very small to large, a few hundred kilobytes. Crash/hang still there. The View Data works OK on any other table I have so I'm really baffled by this. The query tool however limits the display to 101 tuples, regardless of the row limit settings. Are those tables of similar structure, with similarly long data items? The closest possible. I am making some copies, where I'll reduce the row set and increase them... I will report back what happens then, however I won't be able to do that today. Btw, any ideas on the build error in the previous mail? I have no ideas what to do to make it happen :) Sorry, you'll have to remind me what the problem is. Of course :) I wanted to see if the problem is present in the latest code from SVN. I can compile revision 5056 just fine, but building revision 5057 yields: 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/lib/wx/include/gtk2-unicode-release-2.6 -I/usr/include/wx-2.6 -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 -DNO_GCC_PRAGMA -O2 -I/usr/include/libxml2 -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 ctlSQLBox.o -MD -MP -MF .deps/ctlSQLBox.Tpo -c -o ctlSQLBox.o `test -f './ctl/ctlSQLBox.cpp' || echo './'`./ctl/ctlSQLBox.cpp; \ then mv -f .deps/ctlSQLBox.Tpo .deps/ctlSQLBox.Po; else rm -f .deps/ctlSQLBox.Tpo; exit 1; fi make[2]: *** No rule to make target `ctl/ctlSQLGrid.cpp', needed by `ctlSQLGrid.o'. Stop. make[2]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3' make: *** [all] Error 2 Thank you, Miha ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] view data causes pgadmin to hang or die
Hi! Dave Page wrote: So, just to be clear, the query tool will display the data correctly, even if the maximum column length option is increased to accommodate the largest data item? I want to be clear about this because in SVN trunk now, the grid code is shared between the two tools so both /should/ fail, but the column length option might be masking the problem in the query tool. I've checked out a fresh copy from SVN today. I've set Max rows to retrieve to 0, Max. characters per column to 70. View data hangs/crashes, as does Query tool. A few days ago when I hadn't had the latest build the Query tool had worked. But that may have been due to the fact that no matter what I had set for Max rows to retrieve, I'd only get 101 rows. I now get everything, including the crash :) And what is even more strange, the original table (I've been playing with copies of it) grew for a few records and now everything works fine - both View data and Query tool. I don't know what to make of it. Thank you for your time and help! Regards, Miha ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] view data causes pgadmin to hang or die
Hi! I'm sorry for bumping this but if it is possible, it would be great if the described problem can be resolved. Even hints as to what I may be doing wrong would help a lot :-) Thank you, Miha Miha Radej wrote: hi! i have a table with 204 rows of data which contain about 700k of text alltogether. when i tried to use view data in the table, pgadmin either crashes or hangs, no apparent pattern so far. in pgadmin log, set to debug, there is nothing to indicate the problem. but according to it (and to pgsql log) it seems pgadmin gets the data, then sends a query to get the column names. here are the last lines from pgsql log: DNEVNIK: statement: SELECT oid, * FROM problematic_table ORDER BY oid ASC DNEVNIK: statement: SELECT n.nspname AS nspname, relname, t.typname, nt.nspname AS typnspname, attname, attnum, COALESCE(b.oid, t.oid) AS basetype, atthasdef, adsrc, CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else t.typtypmod END AS typmod, CASE WHEN t.typbasetype::oid=0 THEN att.attlen else t.typlen END AS typlen FROM pg_attribute att JOIN pg_type t ON t.oid=att.atttypid JOIN pg_namespace nt ON nt.oid=t.typnamespace JOIN pg_class c ON c.oid=attrelid JOIN pg_namespace n ON n.oid=relnamespace LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum WHERE attnum 0 AND NOT attisdropped AND attrelid=56359::oid ORDER BY attnum DNEVNIK: unexpected EOF on client connection dnevnik = log i'm guessing pgadmin gets the data, asks for the column names and then has problems displaying the data. if i copypaste the queries into the query tool, it works without problems (on all pgadmin versions i've tried this on), the data displays very fast. i am using pgadmin3, compiled from cvs, revision 5056, on opensuse 10.0. the same happened with pgadmin3 1.4.x for debian (used on kubuntu 5.10) and revision 5056 built on the same kubuntu. i tried building the latest revision (5057) but it fails with the following error, on both kubuntu and suse: 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/lib/wx/include/gtk2-unicode-release-2.6 -I/usr/include/wx-2.6 -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 -DNO_GCC_PRAGMA -O2 -I/usr/include/libxml2 -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 ctlSQLBox.o -MD -MP -MF .deps/ctlSQLBox.Tpo -c -o ctlSQLBox.o `test -f './ctl/ctlSQLBox.cpp' || echo './'`./ctl/ctlSQLBox.cpp; \ then mv -f .deps/ctlSQLBox.Tpo .deps/ctlSQLBox.Po; else rm -f .deps/ctlSQLBox.Tpo; exit 1; fi make[2]: *** No rule to make target `ctl/ctlSQLGrid.cpp', needed by `ctlSQLGrid.o'. Stop. make[2]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3' make: *** [all] Error 2 i cannot provide the table structure or data unfortunately but if you need any more information, i'd be happy to try to provide it. regards, Miha ---(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
[pgadmin-hackers] view data causes pgadmin to hang or die
hi! i have a table with 204 rows of data which contain about 700k of text alltogether. when i tried to use view data in the table, pgadmin either crashes or hangs, no apparent pattern so far. in pgadmin log, set to debug, there is nothing to indicate the problem. but according to it (and to pgsql log) it seems pgadmin gets the data, then sends a query to get the column names. here are the last lines from pgsql log: DNEVNIK: statement: SELECT oid, * FROM problematic_table ORDER BY oid ASC DNEVNIK: statement: SELECT n.nspname AS nspname, relname, t.typname, nt.nspname AS typnspname, attname, attnum, COALESCE(b.oid, t.oid) AS basetype, atthasdef, adsrc, CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else t.typtypmod END AS typmod, CASE WHEN t.typbasetype::oid=0 THEN att.attlen else t.typlen END AS typlen FROM pg_attribute att JOIN pg_type t ON t.oid=att.atttypid JOIN pg_namespace nt ON nt.oid=t.typnamespace JOIN pg_class c ON c.oid=attrelid JOIN pg_namespace n ON n.oid=relnamespace LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum WHERE attnum 0 AND NOT attisdropped AND attrelid=56359::oid ORDER BY attnum DNEVNIK: unexpected EOF on client connection dnevnik = log i'm guessing pgadmin gets the data, asks for the column names and then has problems displaying the data. if i copypaste the queries into the query tool, it works without problems (on all pgadmin versions i've tried this on), the data displays very fast. i am using pgadmin3, compiled from cvs, revision 5056, on opensuse 10.0. the same happened with pgadmin3 1.4.x for debian (used on kubuntu 5.10) and revision 5056 built on the same kubuntu. i tried building the latest revision (5057) but it fails with the following error, on both kubuntu and suse: 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/lib/wx/include/gtk2-unicode-release-2.6 -I/usr/include/wx-2.6 -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 -DNO_GCC_PRAGMA -O2 -I/usr/include/libxml2 -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 ctlSQLBox.o -MD -MP -MF .deps/ctlSQLBox.Tpo -c -o ctlSQLBox.o `test -f './ctl/ctlSQLBox.cpp' || echo './'`./ctl/ctlSQLBox.cpp; \ then mv -f .deps/ctlSQLBox.Tpo .deps/ctlSQLBox.Po; else rm -f .deps/ctlSQLBox.Tpo; exit 1; fi make[2]: *** No rule to make target `ctl/ctlSQLGrid.cpp', needed by `ctlSQLGrid.o'. Stop. make[2]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3' make: *** [all] Error 2 i cannot provide the table structure or data unfortunately but if you need any more information, i'd be happy to try to provide it. regards, Miha ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-hackers] missing translation strings?
hi! i was wanting to do a bit of an update on slovenian translation, since there are some new features and as of yet untranslated strings. mainly, in the query tool, the new Favourites menu and menu entries therein. however, i couldn't find the string in the .po file nor in the .pot catalogue; i did a fresh cvs checkout first. this is what a search on one of the strings returns: [EMAIL PROTECTED] grep -r Manage favourites * | grep -v svn src/ui/dlgManageFavourites.xrc:titleManage favourites/title src/dlg/dlgManageFavourites.cpp:// dlgManageFavourites.cpp - Manage favourites src/frm/frmQuery.cpp: favouritesMenu-Append(MNU_FAVOURITES_MANAGE, _(Manage favourites), _(Edit and delete favourites)); Binarna datoteka src/pgadmin3 ustreza src/include/dlgManageFavourites.h:// dlgManageFavourites.h - Manage favourites Binarna datoteka src/xrcDialogs.o ustreza there is no sign of the string i searched for in any of the translation files, only in the code. should i manually extract the strings (generate the .pot catalogue) first? iirc this was being done automatically in the past, along with updating the .po files, wasn't it? regards, Miha ---(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] missing translation strings?
hi! Andreas Pflug wrote: We don't create the pot file regularly, but usually only before releases to avoid lots of strings going in and disappearing again. I'd suggest you stick to the current status. If you're creating your own pot, you might translate strings that are dropped/changed just a few days later. ah, i thought as much, just wasn't sure. thank you for clafying that. due to possible incompatibility reasons i also am not inclined to produce my own .pot files. are there any plans to create an updated .pot catalogue in the near future perhaps? :) regards, Miha ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2
hi! Florian G. Pflug wrote: Miha Radej wrote: i don't have osx but i have had problems compiling pgadmin recently. i've been getting various compiler errors about the code in xmlwriter.h as far as i could tell. my libxml2 version was 2.6.20. after upgrading to 2.6.23, pgadmin compiled fine and the errors i got before went away. this was on suse 10.0. i have a 9.3 system also and also have problems compiling pgadmin, however with different errors (an older libxml2 version). Hm.. sounds more like older versions of libxml2 where incompatible with the gcc version that comes with SuSE 10... Is this gcc 3.3, 3.4, or 4.0? [EMAIL PROTECTED]:~ gcc --version gcc (GCC) 4.0.2 20050901 (prerelease) (SUSE Linux) i think suse 9.3 comes with gcc 3.3.5, but i am not certain. i will check when i get my hands in the computer and will try newer libxml versions to see what happens. regards, Miha -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2
hi! i don't have osx but i have had problems compiling pgadmin recently. i've been getting various compiler errors about the code in xmlwriter.h as far as i could tell. my libxml2 version was 2.6.20. after upgrading to 2.6.23, pgadmin compiled fine and the errors i got before went away. this was on suse 10.0. i have a 9.3 system also and also have problems compiling pgadmin, however with different errors (an older libxml2 version). so might there be a problem with libxml2 itself by any chance? just thought this piece of info might help. Florian G. Pflug wrote: Dave Page wrote: From: Florian G. Pflug[EMAIL PROTECTED] 2.6.16 Which is exactly what I have on Tiger. Odd - perhaps Panther (or your installation) is broken? I'd think Panther is broken... So the check should check for xmlwriter.h, and not for a specific version, I'd say. Maybe someone else here still running Panther can confirm that /usr/include/libxml2/libxml/xmlwriter.h is missing? regards, M -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] Missing make files, etc
hi! Susemail wrote: I'm using Suse 10.0. Are there any rpms I could use? I tried the Fedora Core rpm but was blocked by unmet dependencies (libssl.so.5,libcryto.so.5) on suse try using yast to install wxwidgets. from yast, install packages as you need them: wxGTK (yast offers version 2.6.1 where pgadmin builds just fine), wxGTK-copmat, wxGTK-devel, openssl-devel, postgresql-devel and so on. if it is of any help, i use these yast sources which surely must contain all packages you might need: http://ftp.opensuse.org/pub/opensuse/distribution/SL-10.0-OSS/inst-source http://ftp.opensuse.org/pub/opensuse/distribution/SL-10.0-OSS/inst-source-java ftp://ftp.suse.com/pub/suse/i386/10.0/SUSE-Linux10.0-GM-Extra http://packman.iu-bremen.de/suse/10.0 regards, Miha -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods ---(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
[pgadmin-hackers] pgadmin website changes
hi! i've set up a copy of pgadmin's website on my local machine. i am using apache 2.0.54 and php 5.0.4. when i tried to view the site, a bunch of errors popped up in my php error log: [21-Jan-2006 20:43:15] PHP Notice: Undefined index: _SERVER in /net/www/www.pgadmin3.org/index.php on line 3 [21-Jan-2006 20:43:15] PHP Warning: main(/include/page.php) [a href='function.main'function.main/a]: failed to open stream: No such file or directory in /net/www/www.pgadmin3.org/index.php on line 3 [21-Jan-2006 20:43:15] PHP Warning: main() [a href='function.include'function.include/a]: Failed opening '/include/page.php' for inclusion (include_pa th='.:/net/www/libs/adodb:/net/www/libs/Smarty/libs') in /net/www/www.pgadmin3.org/index.php on line 3 [21-Jan-2006 20:43:15] PHP Fatal error: Call to undefined function www_page() in /net/www/www.pgadmin3.org/index.php on line 23 these errors went away after i changed all occurances of $GLOBALS[_SERVER][DOCUMENT_ROOT] to $_SERVER[DOCUMENT_ROOT]. _SERVER is also an autoglobal, used since php 4.1.0. on any php version greater than this the change should therefore have no ill effect. the attached diff file contains these changes. there's also a fix of a typo (an windows installer - a windows installer) and another small change in the include/session.php file. also, what happened to the language selection menu? regards, Miha -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods pgadmin_website_diff.tgz Description: application/compressed-tar ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Website
hi! what i meant and failed to say was that i prefer how the current menu works, ie an entire block works as a link, not only when you hover over the text. please see http://mcajvar.prkoritu.net/pgadmin/menu.html to better see what i mean. i stole the styles and just modified them a little. Dunno what browser you're using, but in my firefox, safari and IE6's, only the text is linked in any case. The new site doesn't have the highlight-on-hover though - we did consider that but the concencus in the office at work was to leave it without. I might play again tonight though. hmm... interesting :) i've tried it in firefox 1.0.1 (winxp) and 1.0.7 (suse 10), konqueror (suse) and ie6 and only in the latter have i observed what you mention. i wasn't aware of that kind of ie's behaviour, haven't used it in the last 2 years at all :) anyway, the thing is, in browsers i've used the entire block (which also changes color) acts as a link, not only the text and is therefore imo easier to navigate: one just needs to move the mouse in the area and click. this is basically following the design rule of bigger targets are easier to hit. so if it is not too much work can it please be included in the styles? thanks, M ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] Website
hi! just a few quickies: http://wwwdevel.pgadmin.org/download/ we recommand installing binary packages: recommand - recommand additional language translations and admin packas: packas - packs http://wwwdevel.pgadmin.org/download/snapshots.php they are 'works in progress': missing period at the end of the sentence http://wwwdevel.pgadmin.org/download/source.php omit all \'Universal and DLL builds: \' should probably be , at \'Universal? at mac osx build instructions: ../configure --with-mac should probably begin with only 1 dot instead of 2, ./configure --with-mac http://wwwdevel.pgadmin.org/index.php may be used on Linux, FreeBSD Solaris, Mac OSX: missing comma after freebsd No external drivers are to communicate with the database server.: no external drivers are needed? http://wwwdevel.pgadmin.org/features.php Powerful query tool with color syntax highlight: i'm really not sure about this one, but shouldn't this end with highlighting? http://wwwdevel.pgadmin.org/contribute.php for the benefit of out worldwide: out - our http://wwwdevel.pgadmin.org/advocacy/ and bug fixes and helping improve pgAdmin: helping - help some of these companies have: some - Some (start of sentence) http://wwwdevel.pgadmin.org/advocacy/information.php just click on your country flag: aren't the country flags gone? :) when pgAdmin new versions are released: perhaps when new versions of pgAdmin are released http://wwwdevel.pgadmin.org/development/ get involved in the project you you wish: i really have no idea what to suggest :) maybe as you wish, if you wish? http://wwwdevel.pgadmin.org/development/svn.php please source the Source code build instructions: source - check || view || see http://wwwdevel.pgadmin.org/development/changelog.php changes to pgAdmin3, as present in svn: is this text extracted from svn already? if not, according to the advocacy page pgAdmin3 should probably be pgAdmin III and svn written in uppercase, as is elsewhere on the site. http://wwwdevel.pgadmin.org/screenshots/ui.php with colour syntax highlight: same question as above. also, i've noticed that in the above note, on the features page, the word color is used whereas here it is colour. it is a sort of a mix between us and british english :) words like color/colour, dialog/dialogue, realize/realise, analyze/analyse, favorite/favourite are some potential problem makers that come to mind atm. http://wwwdevel.pgadmin.org/screenshots/data.php EXPLAIN and/or ANALYSE: postgresql uses ANALYZE, see above note You will soon realise that: see above note re us/british english http://wwwdevel.pgadmin.org/screenshots/mb_i18n.php other multi-byte charactersets: charactersets - character sets? and partially translated into more than 25 more: kill a more :) http://wwwdevel.pgadmin.org/screenshots/serverstatus.php along with summaries of crrent locks: crrent - current http://wwwdevel.pgadmin.org/support/ help out whereever possible: whereever ... dictionary.com suggests wherever or where ever http://wwwdevel.pgadmin.org/translation/howto.php Browser to the translation status page: Browser - Browse The language template serves as empty template: as an empty... ? and set the harset: harset - charset important step because somes strings: somes - some HTML files used by the Guru to notify users: Guru - Guru Hints? or is this referring to the mr.-bearded-guru-guy who offers the hints? in this case, what is his name? does he have one or is he just a guru? or is he The Guru? :) done. but this was just a quick read-through. also, a feature request if i may :) i really like the display: block property in the current left-hand menu. can this please be used in the new layout as well? regards, M -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods Dave Page wrote: Hi, An essentially complete new website is online at http://wwwdevel.pgadmin.org/. I've stuck with pretty much the current design, but with rewritten CSS and a new colour scheme to match the current pgAdmin splash screen. The content has been rewritten to imporve the phrasing, and each of the long single pages has been broken up into multiple smaller pages. I have also added a documentation section in which you can browse the SVN tip and 1.4 docs. Before I make it live, and freeze the strings for translation; - Does anyone see any technical issues? - Does anyone see any typos? - Does anyone have a better design, or tweaks for the work I've done? ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] Website
hi! Dave Page wrote: Seems pretty through to me, thanks heaps :-) no problem. also, a feature request if i may :) i really like the display: block property in the current left-hand menu. can this please be used in the new layout as well? Sorry, I gon't get what you mean. Block puts a break between elements so they flow one below the other, which is already the case for the side menu. Do you mean the background colour change on a:hover? what i meant and failed to say was that i prefer how the current menu works, ie an entire block works as a link, not only when you hover over the text. please see http://mcajvar.prkoritu.net/pgadmin/menu.html to better see what i mean. i stole the styles and just modified them a little. regards. Miha -- ... the small primitive tribes joined up and became huge, powerful primitive tribes with more sophisticated weapons. -- Terry Pratchett, Small Gods ---(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! 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:
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:
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
[pgadmin-hackers] wrong order of drop constraint/column statements
hi! with pgadmin built from a fresh svn checkout i have experienced the following problem, easily reproducible as follows: i am working on an existing table with some columns and constraints placed on them. in the table properties window, columns tab i removed a column and in the constraints tab i removed the constraint placed on that column. pgadmin produced an incorrect statement order, which was drop column... drop constraint... which resulted in an error saying that the constraint specified does not exist (as it got removed along with the column). the statement order should be switched so that the constraint drops are executed before column drops. attached is a patch that works for me (pushes the drop constraint statements before any other statements generated so far) but i do not know if it will break something else somewhere or if there are such things as constraints that depend on other constraints and should therefore be removed in the correct order. cheers, M Index: src/dlg/dlgTable.cpp === --- src/dlg/dlgTable.cpp(revision 4759) +++ src/dlg/dlgTable.cpp(working copy) @@ -513,8 +513,9 @@ definition = definition.Mid(1).BeforeFirst(''); else definition = definition.BeforeFirst(' '); -sql += wxT(ALTER TABLE ) + tabname -+ wxT( DROP CONSTRAINT ) + qtIdent(definition) + wxT(;\n); +sql = wxT(ALTER TABLE ) + tabname ++ wxT( DROP CONSTRAINT ) + qtIdent(definition) + wxT(;\n) ++ sql; } // Add the ADD CONSTRAINTs... sql += tmpsql; ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-hackers] slovenian hints
hi! attached i send the slovenian translation of the html files in hints directory. all save 1 are translated. i really do not know how to translate server instrumentation properly so i have left that file out. any hints on that one? :) regards, Miha sl_hints.tgz Description: GNU Unix tar archive ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-hackers] and now for something completely different
hi again :) oops, wrong button clicked. that wasn't the attach button. i'm sorry. here is the file. regards, Miha Index: docs/de_DE/hints/view-without-pk.html === --- docs/de_DE/hints/view-without-pk.html (revision 4632) +++ docs/de_DE/hints/view-without-pk.html (working copy) @@ -14,7 +14,7 @@ Das Einfügen von neuen Zeilen oder die Änderung existierender Zeilen mit dem Edit Data Tool ist ohne Primärschlüssel nicht möglich. /p -/p +p Um Daten editieren zu können, erfordert pgAdmin III einen Primärschlüssel auf der Tabelle, was i.d.R. ohnehin im Rahmen eines guten Datenbankdesigns vorhanden sein sollte. Alternativ kan die Tabelle auch WITH OIDS angelegt werden. Bitte beachten daß Eindeutigkeit von OIDs Bnicht/B Index: docs/en_US/hints/view-without-pk.html === --- docs/en_US/hints/view-without-pk.html (revision 4632) +++ docs/en_US/hints/view-without-pk.html (working copy) @@ -13,7 +13,7 @@ Since the table INFO doesn't have a primary key or OIDs, you can view the data only. Inserting new rows and changing existing rows isn't possible for the Edit Data tool without primary key. /p -/p +p In order to edit data, pgAdmin III requires a primary key on the table, which is a good database design practice anyway. Alternatively, the table can be created WITH OIDS. Please note that oids are Bnot/B guaranteed to be unique over a very long period of time, so using oids as kind-of primary key is only second choice. Index: docs/en_US/hints/fki.html === --- docs/en_US/hints/fki.html (revision 4632) +++ docs/en_US/hints/fki.html (working copy) @@ -13,8 +13,8 @@ /p p It all starts with a master table, which will be the referenced table. It needs to have a primary key (well, actually the -referenced columns only need to be not null and covered by a unique index, but it's really good advise to have it a -primary key. The slave table depends on the master table, in the sense that the columns on which +referenced columns only need to be not null and covered by a unique index, but it's really good advice to have a +primary key). The slave table depends on the master table, in the sense that the columns on which the foreign key is created must match the master table for any key inserted or updated. The slave table is the referencing table of the foreign key. /p Index: docs/en_US/hints/pk.html === --- docs/en_US/hints/pk.html(revision 4632) +++ docs/en_US/hints/pk.html(working copy) @@ -24,7 +24,7 @@ /p p If you look at PostgreSQL's system tables, you will find that none of them has a primary key, so what's this about? -Actually, All of these tables have one or two columns (usually OID only) which uniquely identifies each row, obeying the +Actually, all of these tables have one or two columns (usually OID only) which uniquely identifies each row, obeying the second rule for a primary key, not allowing zero, and being covered by an index for faster access. Usage of OIDs has historic reasons, and isn't really first choice for designing user tables. PostgreSQL still uses this for backwards compatibility, and while a newer approach would probably use explicit primary keys it won't be changed now any more. Index: docs/en_US/tips.txt === --- docs/en_US/tips.txt (revision 4632) +++ docs/en_US/tips.txt (working copy) @@ -41,6 +41,6 @@ pgAgent can be used to schedule regular batch and SQL jobs, such as the re-creation of date-sensitive partial indexes, or purging of old records. It is good practice to build application logic into the database itself by using functions and views. This ensures that different front-ends to your products will always see the same views of data and update and modify data in the same way. Better yet, you only have to write it all once for all front-ends! To help keep your databases secure, minimise the amount of access you allow to remote hosts when creating your pg_hba.conf file, and always use encrypted connections unless you have good reason not to. -You can restrict access to individual columns of a table for a particular user or group by denying them drect access to it, and creating a view containing only the columns they should see for them to use instead. If your users need to update the data, you can create rules to apply updates to the view to the base table instead. +You can restrict access to individual columns of a table for a particular user or group by denying them direct access to it, and creating a view containing only the columns they should see for them to use instead. If your users need to update the data, you can create rules to apply updates to the view to the base
[pgadmin-hackers] updated slovenian tips.txt and some other stuff
hi! attached i send an updated slovenian tps.txt file and some typo fixes/suggestions. i will also send in some of the translated html files for guru hints. regards, Miha ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] updated slovenian tips.txt and some other
hi! no idea what was up with attachments in the previous mail. i checked the update and the slovenian characters aren't displayed properly. attached i send a tgz file with slovenian tips, which should properly display slovenian characters, it being utf-8 encoded. regards, Miha Dave Page wrote: On 1/11/05 12:01 pm, Miha Radej [EMAIL PROTECTED] wrote: attached i send an updated slovenian tps.txt file and some typo fixes Thanks Miha, update applied. Please check over everything as I had to manually apply much of it. For future reference, it's always better to attach patches rather than send them inline - there's less chance things going wrong! tips_txt.tgz Description: GNU Unix tar archive ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] translation question regarding guru hints
hi! Andreas Pflug wrote: i'm also working on translating the hint files and tips.txt. i presume tips.txt is utf-8 encoded? i saved it as utf-8 and slovenian characters were displayed correctly. Please test it, I don't know what wxWidgets makes from it. Currently, I'm not even sure that we'd display a translated version correctly, pleast test that before spending useless effort. so far as i have been able to test (2 win2k systems and 2 suse linux 9.3 systems) the tips from tips.txt are being displayed correctly if using utf-8 encoding. so i guess i will leave it at that. by the way, i also have some questions regarding this tip: pgAdmin III is a completely new version of pgAdmin written in C++ using the wxWindows framework to allow it to run on Windows and *nix systems. do i keep wxwidgets in the translation or do i use wxwindows? Use the charset that fits your needs best (but use the same encoding throughout that directory, some files may be assembled to a single one at runtime). If it displays correctly in any standard browser, it should be good in pgAdmin as well. that is what i thought, so i have prepared all the files, saved them as latin2 and gave it a try. it was ok on linux and garbage on windows, like i described in a previous post. so here also i will use html codes until a complaint is received :) attached is the slovenian tips.txt file. the guru hints will be arriving shortly, i hope :) thanks for your answers, Miha # Za dodajanje namiga ga le dopiÅ¡i v novo vrstico. # Prazne vrstice se prezrejo, vrstice, ki se zaÄnejo s # so komentarji. # Poba, nucej UTF-8 :) Z redno uporabo VACUUM-a se lahko izboljÅ¡a delovanje PostgreSQL-a. Uradni rojstni dan PostgreSQL je 8. julij. Projekt PostgreSQL je nastal leta 1996. Prvi prototip za izvirni pgADMin projekt se je imenoval pgMAnager, spisan pa je bil za PostgreSQL 6.3.2. Podporo za pgAdmin lahko izrazite na pgadmin-support@postgresql.org dopisnem seznamu. Odgovor na vpraÅ¡anje o Življenju, Vesolju in Sploh Vsem je 42. Älani razvojne ekipe pgAdmina prihajajo med drugim iz Velike Britanije, Francije ter ZDA. pgAdmin II je bil preneÅ¡en preko 10,000-krat *preden* je bila na voljo razliÄica za izdajo! Prva stabilna razliÄica pgAdmina II je bila preneÅ¡ena preko 30,000-krat v prvih 6 mesecih po izdaji. Prva uradna stabilna razliÄica pgAdmina II je bila izdana 16. januarja 2002. Razvoj projekta pgAdmin III se je zaÄel 29. septembra 2002. pgAdmin je izdan pod Open Source licenco 'Artistic Licence'. PostgreSQL v /contrib direktoriju drevesa izvorne kode vkljuÄuje Å¡tevilna uporabna orodja, datoteke in projekte. Na dopisnem seznamu pgadmin-hackers@postgresql.org potekajo diskusije o novih funkcijah ter poteku razvoja. VeÄina knjižnice pgSchema, ki jo uporablja pgAdmin II, je bila razvita na prenosniku z Windows 2000, pred TV ekranom v bližini Oxforda, v Angliji. Svoje geslo lahko spremenite preko menija 'Datoteka', 'Spremeni geslo'. PostgreSQL 7.2 podpira tabele brez OID stolpcev, z namenom manjÅ¡e porabe OID-jev. V PostgreSQLu 7.2 lahko nadzirate aktivnost sistema glede na posamezno povezavo z uporabo 'SELECT * FROM pg_stat_activity'. PostgreSQLov repertoar proceduralnih jezikov vkljuÄuje tudi pl/pgSQL, pl/TCL, pl/Perl ter pl/sh. PostgreSQL 7.3 podpira sheme. To so posamezni imenski prostori znotraj podatkovnih zbirk. Za replikacijo se lahko uporabi projekt rserv v PostgreSQLovem contrib direktoriju. Pano z definicijami vsebuje z obratnim inženiringom pridobljen SQL za izbrani objekt. pgAdmin III je popolnoma nova razliÄica pgAdmina, napisana v C++ z uporabo wxWidgets okolja, ki omogoÄa izvajanje na Windows in *nix sistemih. Domene se lahko uporabi za kreiranje predefiniranih podatkovnih tipov, ki temeljijo na bolj sploÅ¡nih osnovnih tipih. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-hackers] problem compiling, error while checking for wx
hi! after a fresh cvs checkout just now, i get the following error while running configure: snip checking for wxWidgets... yes Warning: No config found to match: /usr/local/bin/wx-config --static=no --libs --unicode=yes --debug=yes --version=2.6 in /usr/local/lib/wx/config If you require this configuration, please install the desired library build. If this is part of an automated configuration test and no other errors occur, you may safely ignore it. You may use wx-config --list to see all configs available in the default prefix. Warning: No config found to match: /usr/local/bin/wx-config --static=no --libs stc,ogl --unicode=yes --debug=yes --version=2.6 in /usr/local/lib/wx/config If you require this configuration, please install the desired library build. If this is part of an automated configuration test and no other errors occur, you may safely ignore it. You may use wx-config --list to see all configs available in the default prefix. configure: error: Your wxWidgets installation cannot support pgAdmin in the selected configuration. This may be because it was configured without the --enable-unicode option, or the combination of dynamic/static linking and debug/non-debug libraries selected did not match any installed wxWidgets libraries. make: *** [config.status] Error 1 /snip the pgadmin configure command was ./configure --prefix=/usr/local/pgadmin-svn the wx configure command was ./configure --with-gtk --enable-gtk2 --enable-unicode --disable-shared --enable-debug --enable-mimetype=yes i've successfully used the above pgadmin configure command until a few days ago. configure goes through and pgadmin compiles ok with the following parameters: ./configure --prefix=/usr/local/pgadmin-svn --enable-debug --enable-static is it necessary to explicitly add these two parameters now? thanks, Miha ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-hackers] link problem on pgadmin3 beta web page
hi! there is a problem on the pgadmin3 beta web page, http://pgadmin.org/beta.php the links pointing to the download center have an extra double-quote character included which is causing problems. cheers, Miha Index: cnt/cnt_beta.php === --- cnt/cnt_beta.php(revision 4573) +++ cnt/cnt_beta.php(working copy) @@ -8,7 +8,7 @@ 2005-10-12 p Beta-2 of pgAdmin 1.4, the graphical PostgreSQL administration tool for Windows, Linux, FreeBSD and Solaris is now available for download from - a href='http://www.postgresql.org/ftp/pgadmin3/beta'postgresql.org download center/a. + a href=http://www.postgresql.org/ftp/pgadmin3/beta;postgresql.org download center/a. /pp This new beta version is made available publicly together with PostgreSQL 8.1 Beta-3, and includes some minor fixes to annoying bugs, esp. a crash when showing a table's properties. @@ -17,7 +17,7 @@ 2004-10-05 p Beta-1 of pgAdmin 1.4, the graphical PostgreSQL administration tool for Windows, Linux, FreeBSD and Solaris is now available for download from - a href='http://www.postgresql.org/ftp/pgadmin3/beta'postgresql.org download center/a. + a href=http://www.postgresql.org/ftp/pgadmin3/beta;postgresql.org download center/a. /pp V1.4.0 contains a number of new features including: ul @@ -45,4 +45,4 @@ Please take some time to test the new beta and report any bugs to the a href=mailto:pgadmin-support@postgresql.org;pgAdmin-support mailing list/a. With your help we can make this the most bug free release possible. -/p \ No newline at end of file +/p ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-hackers] recent file list in conf editor doesn't seem to work
hi! i'm sorry for the mass of emails today but i'm working on the translation atm and am reporting/asking stuff as i go along. sorry for being a nuisance :) i have compiled pgadmin3 on suse linux 9.3, from a fresh cvs checkout and i have downloaded beta3 for windows. in the server (access) configuration editor, the recent files list seems to remain empty, no matter how many files i open/close/save. the recent files entry is clickable, but no file list appears. cheers, Miha ---(end of broadcast)--- TIP 6: explain analyze is your friend
[pgadmin-hackers] incomplete window title in guru hints
hi! guess who (needs sleep) :) i connect to a server. from the tools menu option i select server status and a guru hint pops up. the title of this window with the hint contains pgAdmin III Guru Hint - . according to frm/frmHint.cpp, line 207 says something ought to get appended also, namely wxGetTranslation(hintArray[currentHint].hintCaption) but it doesn't. any ideas? cheers, Miha ---(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
[pgadmin-hackers] does this string need correction?
hi! in src/main/events.cpp, line 145 contains the following string: Maybe your proxy option setting need adjustment. a am not a native english speaker, but there's a feeling i have this should be either Maybe your proxy option settings need adjustment. or Maybe your proxy option setting needs adjustment. or am i seeing things? good night, Miha ---(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
[pgadmin-hackers] cannot disable displaying of system objects
hi! since pgadmin3 was displaying system schemas i didn't need i wanted to disable it. upon checking the menu option, display - system objects, it wasn't checked. upon several tries it seems that the system objects are displayed no matter what the setting in the menu is set to. this works ok in pgadmin3 1.2.2. i am using suse linux 9.3, pgadmin3 built from a fresh svn checkout. regards, M ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] altering table properties
hi again! Miha Radej wrote: also, i wanted to remove a constraint (primary key) and add a new one and pgadmin produced thie following code: CONSTRAINT ALTER TABLE budget_type DROP CONSTRAINT pkey_budgettype; ALTER TABLE budget_type ADDpkey_budget_type PRIMARY KEY (id); there is an unneccesary CONSTRAINT in front of the first query and in the second query there is no space between the ADD keyword and constraint name. i tried fiddling with the code (never touched c++ before so i was a bit afraid i'd mess things up) and a small change fixed this specific issue, here is the svn diff: Index: src/dlg/dlgTable.cpp === --- src/dlg/dlgTable.cpp(revision 4459) +++ src/dlg/dlgTable.cpp(working copy) @@ -377,7 +377,7 @@ tmpsql += wxT(ALTER TABLE ) + tabname + wxT( ADD); if (!conname.IsEmpty()) -sql += wxT( CONSTRAINT ); +tmpsql += wxT( CONSTRAINT ); tmpsql += definition + wxT(;\n); } cheers, Miha ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] compilation errors: wrong actions
hi! i successfully configured and compiled pgadmin from a fresh svn checkout today, without the errors diego had mentioned. i would, however, like to confirm his report about the delete-instead-of-refresh bug. it's alive and kicking :) cheers, M Diego Gil wrote: I noticed that refresh button and refresh menu item (F5) are connected to delete object action. Delete object button and menu item too, as should be. Trying to make a New Connection aborts pgadmin3 without any chance to cancel. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] RFC: pgAgent Scheduler Design
hi! Dave Page wrote: -Original Message- From: Miha Radej - if a job does not execute, i'd like to set an option whether to be executed as soon as possible, delayed or nor, or if execution should be held until the next planned time. You mean the run one missed job and then go back to normal as Andreas suggested, or run *all* missed instances? hmm... i have the innate ability to not properly express what i am thinking about :) what i meant with the above was a setting for this: you set a job to be executed, say, at a certain time. if it doesn't execute at that specified time, then sometimes it might be possible that someone doesn't want the job to be executed at all (eg. heavy duty jobs where it would take up too much resources, time, etc) and rather wait until the next execution time, while other people might like the job to get executed as soon as possible, even if the set time is way in the past. for example, if i have a large database of, say a forum, and have a few jobs set to be executed. one at 0100 to do some magic with it, next one at 0400 to do sth else, last one at 0500. so that when people would come to work at 0600 the jobs would be finished and people would be able to post as usual while at work :) if it should happen that the last job couldn't be executed at 0500, i don't want it to be executed at all, because it might take a lot of time to finish so i risk that the database will be overloaded with work to do and users might experience large load times. which might turn some users away, which i don't want. but if i have some simple tasks planned or have a private database where i don't care what gets executed and when, then i could set the option to simply execute the job when it gets its turn, regardless whether the start time has already passed. the above option, along with this one: - an option whether to execute jobs several times or only once, would be handy. for example, if i have a daily job and have an incrementing value set to n, i'd expect it to be n+5 5 days later. sometimes, when, say, refreshing data in a table, multiple executions aren't necessary, so a checkbox or something would be nice imo. are imho somewhat connected. so some jobs i would like to be executed all at once (those that were delayed), while others i don't need executed more than once. i can't help myself, i like lots of options and checkboxes and so forth :) this was what i was trying to say and i hope i didn't complicate matters too much as i usually do :) regards, M ---(end of broadcast)--- TIP 3: 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] RFC: pgAgent Scheduler Design
hi! Dave Page wrote: I don't completely agree. If a job was stuck unexecuted in the queue for a while, it should run asap, and the next schedule should be calculated in the future, i.e. a daily job not executed for 5 days shouldn't be executed 5x, but only once after pgAgent is up again. Hmm, not sure about that. I definitely want to hear some other opinions on this please!! if i may, i'd very much like to see something like this: - if a job does not execute, i'd like to set an option whether to be executed as soon as possible, delayed or nor, or if execution should be held until the next planned time. - should this be the last planned execution of a job, ie. a job executing monday to friday and then never again, i'd like to be able to set an option in such special case: if the execution was held and the last execution was held also, it'd be great to be able to set an option like the above paragraph for such exceptional cases. - an option whether to execute jobs several times or only once, would be handy. for example, if i have a daily job and have an incrementing value set to n, i'd expect it to be n+5 5 days later. sometimes, when, say, refreshing data in a table, multiple executions aren't necessary, so a checkbox or something would be nice imo. - if it should happen that something is set to execute periodically every 10 minutes but takes more than that to execute, is it possible to set it either to wait until the first job is done and only then launch the next run, or to allow overlapping jobs, ie. execute a job at the next specified time, regardless if the previous run hasn't finished yet. - and another feature request: is it possible to set an execution time frame, from and to a certain date and have a job executed at random times (with a possibility of specifying the number or range (ie. between 5 and 9) of executions) within that specified time frame? right now i have a script that does sth. like that. err, this is a rather exotic request, i know, but it is something i could use so i just had to write this :) i hope i stayed in context and my opinion helps. now i'll just crawl back into my cave and just read the postings here again :) regards, Miha ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] RFC: Update wizard
hi! Andreas Pflug wrote: Annoying, if you don't want to update. Maybe non-flashing. Or toolbar button, which changes appearance if download is available. The download dlg should be accessible even if no update was automatically detected, to enable manual triggered updates. could you also consider checking for a newer binary snapshot (for windows in my case)? so i wouldn't have to go look every now and then :) i know, i'm being lazy :) regards, Miha ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[pgadmin-hackers] slovenian translation minor (typo) fix
hi! this is a minor translation fix as i found some typos. zip file including the .po and .mo files can be found here: http://mcajvar.prkoritu.net/pgadmin/sl_SI.zip (not attaching it because i had problems last time i tried). -- regards, M ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-hackers] slovenian translation, sl_SI
hi! although still not quite done yet, however with some corrections, i'm sending in the slovenian translation. i won't be able to finish it very soon since i'm going away for some time but i will nevertheless still try to provide slovenian translations in the future also. zipped .po and .mo files: http://mcajvar.prkoritu.net/pgadmin/sl_SI.zip (~ 45k) -- regards, M ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] keywords... Is it normal ?
hi! in my case it also quotes only 1 column name (column name is type), although it is lower-case: http://mcajvar.prkoritu.net/pgadmin/pgadmin_quotes.png (in the middle of the query). in another table, the column name password is also quoted and it's also lower-case. using v 1.1.0 devel, sep. 7 2004 on win2k. regards, M Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 September 2004 10:03 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Dave Page; [EMAIL PROTECTED] Subject: Re: Re: [pgadmin-hackers] keywords... Is it normal ? Also add the user name in the grant statements. I've read some thread implying Andreas and quoted keywords. I think Andreas or Dave added such feature to prevent some misbehaviour while using reserved words in some conditions but I don't know/remember/understand the scope of these modifications. IMHO it should be reviewed as it breaks part of the tool. Andreas tweaked it a bit a little while ago: http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3/src/utils/misc.cpp.d iff?r1=1.54r2=1.55 Seems we need a way to exclude keywords when used in their 'keyword defining' context (if that makes any sense :-) ). Regards, Dave ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] Ready for beta 1
umm, i don't really know how this process goes and if this has anything to do with it, but if so, could you please wait a day or two so i try to translate as much as i can of these new strings and send in the .po file? thanks, M Andreas Pflug wrote: Dave Page wrote: Last patch, as in, we can start using cvs tip from now on? I hope so! Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-hackers] pgAdmin3 in BSD ports...
Isn't it 2.4.2, according to this (I've just updated my ports collection prior to executing the following command, so this as current as it gets)? [EMAIL PROTECTED]:/usr/ports]$ make search name=pgadmin3 Port: pgadmin3-1.0.1_1 Path: /usr/ports/databases/pgadmin3 Info: PostgreSQL database design and management system Maint: [EMAIL PROTECTED] Index: databases B-deps: XFree86-fontEncodings-4.3.0 XFree86-fontScalable-4.3.0 XFree86-libraries-4.3.0_6 Xft-2.1.2 atk-1.4.1_1 expat-1.95.6_1 fontconfig-2.2.90_3 freetype2-2.1.5_1 gettext-0.12.1 glib-1.2.10_10 glib-2.2.3 gtk-1.2.10_10 gtk-2.2.4_1 imake-4.3.0_1 jpeg-6b_1 libiconv-1.9.1_3 pango-1.2.5 perl-5.6.1_15 pkgconfig-0.15.0 png-1.2.5_2 postgresql7-client-7.3.4_1 tiff-3.6.0 wxgtk-common-2.4.2 wxgtk-contrib-common-2.4.2 wxgtk2-2.4.2_1 wxgtk2-contrib-2.4.2 R-deps: XFree86-fontEncodings-4.3.0 XFree86-fontScalable-4.3.0 XFree86-libraries-4.3.0_6 Xft-2.1.2 atk-1.4.1_1 expat-1.95.6_1 fontconfig-2.2.90_3 freetype2-2.1.5_1 gettext-0.12.1 glib-1.2.10_10 glib-2.2.3 gtk-1.2.10_10 gtk-2.2.4_1 imake-4.3.0_1 jpeg-6b_1 libiconv-1.9.1_3 pango-1.2.5 perl-5.6.1_15 pkgconfig-0.15.0 png-1.2.5_2 postgresql7-client-7.3.4_1 tiff-3.6.0 wxgtk-common-2.4.2 wxgtk-contrib-common-2.4.2 wxgtk2-2.4.2_1 wxgtk2-contrib-2.4.2 What it says in the Makefile probably means that if you have wx installed, it requires at least 2.4.0. If you don't it'll go for the 2.4.2 version. But I'm relatively fresh with FreeBSD so don't hold my word for it :) At 13:27 3.2.2004, [EMAIL PROTECTED] wrote: Seems they use 2.4.0... :( Have a look to their makefile: LIB_DEPENDS+= wx_gtk2_stc-2.4.0:${PORTSDIR}/x11-toolkits/wxgtk2-contrib CONFIGURE_ARGS+=--with-wx-config=wxgtk2-2.4-config May be Hiroshi or Dave could contact the 'maintainer' to clarify the situation ? MAINTAINER= [EMAIL PROTECTED] Message d'origine Sujet: Re: [pgadmin-hackers] pgAdmin3 in BSD ports... Date: Tue, 3 Feb 2004 12:11:12 - De: Dave Page [EMAIL PROTECTED] A: [EMAIL PROTECTED], [EMAIL PROTECTED] -Original Message- From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] Sent: 03 February 2004 12:10 To: Dave Page; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] pgAdmin3 in BSD ports... Le Mardi 3 Février 2004 12:37, Dave Page a écrit : Did anyone know pgAdmin 3 was in the BSD ports collection? http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/pgadmin3/ What wxGTK2 version are they using? Andreas patched version? No idea, just spotted it whilst browsing the ports. I don't have BSD box to look at it on right now. Regards, Miha ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-hackers] Translation
Hi! I've sent the file a few hours ago and also CCed to this list, but I still haven't received it. I'm resending the translation just in case it got lost. I apologize for any inconvenience! Lp, Miha pgAdmin_slo.zip Description: Zip archive ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] Slovene Translation
Hi! Send us the English and translated names of your language: French and Français, German and Deutsch, etc.. This will allow us to modify pgAdmin src/ui/pgadmin3.lng file to display the language name in pgAdmin. We will also create a directory according to your locale canonical name under /usr/share/pgadmin3/ui (GNU/Linux and other Unixes) or c:\program files\pgadmi3\ui (Win32). The list of language codes can be found on http://www.debian.org/international/l10n/poDebian site. English name: Slovenian Original (translated) name: Slovenèina ( == s with hachek, è == c with hachek) Language code: sl_SI Slovenian is in some ways similar to Croatian, they are both Slavic by origin, but it is quite different nevertheless. It is also one of the few languages which also has, besides singular and plural, dual. So it can be a bit tricky to translate from time to time. At 11:45 19.8.2003 +0200, Jean-Michel POURE wrote: Sorry for the delay. I needed some time to update pgAdmin3 web site in order to display the translation howto. The translation page is available from http://snake.pgadmin.org/pgadmin3/translation.php#howto. Upon reception of your language names, we will update pgAdmin3 and the website. Please note that you can start translating right now downloading pgAdmin3.pot file. Just for information, does Slovenian differ a lot from Croatian which we already support? What is the origin of the Slovenian language? -- Lp, Miha ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] Slovene Translation
Hi! What do I need to do to volunteer as a translator? I'm interested in translating pgAdmin3 into Slovenian language. -- Lp, Miha ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])