Re: [pgadmin-hackers] wxWidgets alert at start

2007-08-09 Thread Florian G. Pflug
Jyrki Wahlstedt wrote: On 4.8.2007, at 13.29, Dave Page wrote: Jyrki Wahlstedt wrote: On 3.8.2007, at 0.15, Jyrki Wahlstedt wrote: Here's what I can do: in building the bundle I can replace the helper apps (pg_dump, pg_dumpall, pg_restore) with symbolic links to the respective apps in the

Re: [pgadmin-hackers] Change for connection name

2007-08-04 Thread Florian G. Pflug
Guillaume Lelarge wrote: Dave Page a écrit : Guillaume Lelarge wrote: I received an interesting request from Kevin Macdonald a few, hum, months ago. Yes, I'm not really that quick :) But I didn't forget. He wished to have the username on the query's window title. This is interesting when you u

Re: [pgadmin-hackers] wxWidgets alert at start

2007-08-04 Thread Florian G. Pflug
Dave Page wrote: Jyrki Wahlstedt wrote: On 3.8.2007, at 0.15, Jyrki Wahlstedt wrote: I soon get used to the fact that I changed my subscriber email, setting it right helps in getting the message through. If this is a double, feel free to erase this (as always)! On 2.8.2007, at 23.20, Dave Pa

Re: [pgadmin-hackers] xlog switch & last record before the switch

2007-07-12 Thread Florian G. Pflug
Florian G. Pflug wrote: Sorry for the noise guys. I'm beginning to think that thunderbird's autocompletion is tricking me on purpose... regards, Florian Pflug ---(end of broadcast)--- TIP 6: explain analyze is your friend

[pgadmin-hackers] xlog switch & last record before the switch

2007-07-12 Thread Florian G. Pflug
Hi To test my PITR-slave readonly-query patch, I continously do insert into test ... pg_switch_xlog() sleep 1 on the master, and let the slave process the generated xlogs The log output on the slave looks the following (unnecessary lines remove) LOG: restored log file "0001016E

Re: [pgadmin-hackers] recovery_target_xid & crashes on the master

2007-06-04 Thread Florian G. Pflug
Magnus Hagander wrote: I think you meant to send that to pgsql-hackers, not pgadmin-hackers... Ups - sorry for the noise. One shouldn't rely on thunderbird's address autocompletion to read one's thoughts ;-) greetings, Florian Pflug ---(end of broadcast)-

[pgadmin-hackers] recovery_target_xid & crashes on the master

2007-06-04 Thread Florian G. Pflug
Hi I'm currently working on splitting StartupXLog into smaller parts, because I need to reuse some of the parts for concurrent wal recovery (for my GSoC project) The function recoveryStopsHere in xlog.c checks if we should stop recovery due to the values of recovery_target_xid and recovery_targe

Re: [pgadmin-hackers] 'Stealing' SQL files association considered harmful

2007-05-18 Thread Florian G. Pflug
Dave Page wrote: Magnus Hagander wrote: Not really. I would've suggested the separate feature thing, but if that doesn't work... Can we make it a checkbox and disable it from there? That's what would require a CA and custom dialogs. The CA because there is no way to put a condition on the app

Re: [pgadmin-hackers] Filetype registration on OS X

2007-05-11 Thread Florian G. Pflug
Dave Page wrote: Anyway, I've implemented this in SVN trunk - both Windows and Mac now allow you to double click a .sql and have it open in pgAdmin's query tool :-) Cool! Can't wait to try it... greetings, Florian Pflug ---(end of broadcast)---

Re: [pgadmin-hackers] Filetype registration on OS X

2007-05-10 Thread Florian G. Pflug
Dave Page wrote: Hi Florian, I've been trying to figure out how to register pgAdmin as a handler for .sql files with Launch Services, however all the documentation I seem to be finding is about using Launch Services to launch a file (as Finder would), rather than registering as we need to. Any

Re: [pgadmin-hackers] build environment

2007-05-03 Thread Florian G. Pflug
Dave Page wrote: Giuseppe Sacco wrote: Hi all, I have a simple question: what is/are the build environment used by pgadmin developers? Windows? Solaris? Redhat? Suse? Debian? other? I'm doing nightly builds on OSX 10.3 with wx 2.8.3, and I also sucessfully built 1.6 on ubuntu edgy a few weeks

Re: [pgadmin-hackers] compile problems

2007-05-02 Thread Florian G. Pflug
Guillaume Lelarge wrote: Dave Page a écrit : Florian G. Pflug wrote: @dave: I think that the "#define DECIMAL DECIMAP_P" isn't needed anymore - or at least "find ./ -name "*.h" | xargs grep DECIMAL" and "find ./ -name "*.c" | xargs grep DEC

Re: [pgadmin-hackers] compile problems

2007-05-01 Thread Florian G. Pflug
Giuseppe Sacco wrote: if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include/postgresql -DSSL -I/usr/local/wxWidgets-2.8.2/lib/wx/include/gtk2-unicode-release-2.8 -I/usr/local/wxWidgets-2.8.2/include/wx-2.8 -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 -D__WXGTK__ -O2 -I/usr/include/l

Re: [pgadmin-hackers] Debugger status

2007-04-20 Thread Florian G. Pflug
Dave Page wrote: Hi guys, Following the last three days hacking the debugger about to strip it of dead code, and bring it vaguely in line with pgAdmin it's become more and more clear to me that it just doesn't work nicely as a standalone app. So, with apologies to Florian for his wasted time

Re: [pgadmin-hackers] [PATCH] Nested app support for complete-bundle.sh

2007-04-15 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug wrote: Hi That symlinking-Framworks idea proved to be easier than I initially thought - here is a patch ;-) This patch also moves pkg to the end of the list of subdirs in the main Makefile.am. If pkg is listed before debugger, than complete-bundle.sh is run

[pgadmin-hackers] [PATCH] Nested app support for complete-bundle.sh

2007-04-14 Thread Florian G. Pflug
Hi That symlinking-Framworks idea proved to be easier than I initially thought - here is a patch ;-) This patch also moves pkg to the end of the list of subdirs in the main Makefile.am. If pkg is listed before debugger, than complete-bundle.sh is run _before_ the debugger binary is copied into t

[pgadmin-hackers] Debugger, Nested Bundles & @executable_path

2007-04-14 Thread Florian G. Pflug
Hi I've done a bit of research on the Debugger integration issue on OSX. As it turns out, there is a nearly perfect solution for our problem - with one little downside. There is a macro @loader_path similar to @executeable_path - only that it refers not to path of the top executable that was orig

Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug wrote: Dave Page wrote: Florian G. Pflug wrote: I'm currently thinking that unconditionally adding the output of pg_config --libs to LIBS if linking statically might be a better approach - thoughts? That whole section of the file seems a bit kooky to me

Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug wrote: I'm currently thinking that unconditionally adding the output of pg_config --libs to LIBS if linking statically might be a better approach - thoughts? That whole section of the file seems a bit kooky to me - it does some weird stuff on Solaris as

Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug wrote: BTW, I've been working on an i386 binary of pgadmin3 that is statically linked. If've managed to compile static version of libxml, libxslt, wxwidgets and libpq, but configure fails for pgadmin3 because it doesn't know that it has to pa

Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Florian G. Pflug
Dave Page wrote: The existing complete-bundle.sh code works fine, and rewrites the paths to the wx libraries as expected, however the debugger crashes when run. As best I can figure, this is because although the debugger has the correct relative paths to the libraries, some of those (wx) librarie

Re: [pgadmin-hackers] GUI glitch (1.6.3)

2007-04-02 Thread Florian G. Pflug
Dave Page wrote: Guillaume Lelarge wrote: Dave Page a ecrit le 02/04/2007 17:04: Guillaume Lelarge wrote: [...] I see it on trunk on Win32, and to a far lesser extent on 1.6.3 on OSX. Are you still intending to fix it? If you want to do it, go ahead. I have another bug to work on. No, no

Re: [pgadmin-hackers] [PATCH] Buildfailure on OSX (10.3.9) + fix

2007-03-31 Thread Florian G. Pflug
Hiroshi Saito wrote: Hi Florian-san. It was applied. Is the screen of OSX comfortable?:-) Yeah, it builds now. Thanks for applying! I'd still like to understand why this patch is needed, though - to me it seems like a blatant bug in the gcc c++ parser, but I somehow doubt this. Any ideas? gr

[pgadmin-hackers] [PATCH] Buildfailure on OSX (10.3.9) + fix

2007-03-30 Thread Florian G. Pflug
Hi I've finally fixed my buildserver today, and discovered that the build of pgadmin3 trunk on OSX 10.3.9 (gcc 3.3) fails when compiling the debugger. Attached is a patch that fixes the problem, though I must admit that I soley found the fix through trial and error. I have absolutly no idea why

Re: [pgadmin-hackers] Debugger integration

2007-03-30 Thread Florian G. Pflug
Dave Page wrote: Hiroshi Saito wrote: Umm, There may also be structure which debugger is connected with PostgreSQL by itself and waits for a response, and it may not be desirable on a constitution. Yeah, that's a good point. In case that doesn't retranslate to German well, what Hiroshi is sa

Re: [pgadmin-hackers] Debugger integration

2007-03-30 Thread Florian G. Pflug
Dave Page wrote: Hi all, So far, the code has been modified mainly to get rid of it's use of MDI windows, and to use wxAUI instead, and to integrate it into the pgAdmin build system. Cool. Having tried it on OS X, I find we have a problem. On that platform, executables are distributed inside

Re: [pgadmin-hackers] Fedora package status for 1.6.3 and above

2007-03-28 Thread Florian G. Pflug
Dave Page wrote: --- Original Message --- From: "Florian G. Pflug" <[EMAIL PROTECTED]> To: Dave Page <[EMAIL PROTECTED]> Sent: 27/03/07, 21:31:59 Subject: Re: [pgadmin-hackers] Fedora package status for 1.6.3 and above Maybe we could build a generic statically l

[pgadmin-hackers] Small glitch on the Homepage

2007-03-27 Thread Florian G. Pflug
Hi On the OSX download page, below the links to the various versions, is this text: "These packages are Mac OSX appbundles. To install them, simply unpack the archive, and move the appbundle into the desired location." This is not true for at least 1.6.x - it's a pkg ;-) AFAIK, for 1.8.x it w

Re: [pgadmin-hackers] Fedora package status for 1.6.3 and above

2007-03-27 Thread Florian G. Pflug
Dave Page wrote: Devrim GÜNDÜZ wrote: The package builder ( ghenry ~~ suretecsystems dot com ) is a bit late on building packages: Fedora Core 6 has 1.4.3 ( the reason is stated below ) , and development has 1.6.1. So please bug him, not me, about Fedora pgadmin3 package in Fedora repository. T

Re: [pgadmin-hackers] Google SoC idea: FTS support in GUI tools

2007-03-22 Thread Florian G. Pflug
Dave Page wrote: It's always worth researching the approaches used in other products where possible. Of course, you must be careful not to use patented algorithms but that is rarely an issue in UI design. You might want to check if amazon hasn't acquired a patent on One-Click-FTS though ;-) gr

[pgadmin-hackers] Refreshing Objects when their SQL-Script is copied into new SQL Window

2007-03-06 Thread Florian G. Pflug
Hi When debugging plpgsql functions, I usually click on the function I want to edit, and then on the SQL Icon. This opens a new SQL Window, with the "CREATE FUNCTION.." Statement already filled on. If I now change the function, hit F5, close the window, and reopen it, I see the old version of the

[pgadmin-hackers] The "dependent" list shows _RULE if a view depends on something

2007-03-06 Thread Florian G. Pflug
Hi I just noticed that the list if dependents of an object list the _RULE, and not the view if that objects is being used in a rule. This is technically correct - but I think it'd be more userfriend to show the view instead. Would a patch for this be accepted, or is this "by design"? greetings,

Re: [pgadmin-hackers] pgadmin3 1.6.2 + wxGTK 2.8.0 on Ubuntu Edgy ( gcc 4.1)

2007-03-05 Thread Florian G. Pflug
Florian G. Pflug wrote: Dave Page wrote: --- Original Message --- From: "Florian G. Pflug" <[EMAIL PROTECTED]> To: pgadmin-hackers Sent: 05/03/07, 19:40:09 Subject: [pgadmin-hackers] pgadmin3 1.6.2 + wxGTK 2.8.0 on Ubuntu Edgy (gcc 4.1) Hi I just tried compilin

Re: [pgadmin-hackers] pgadmin3 1.6.2 + wxGTK 2.8.0 on Ubuntu Edgy ( gcc 4.1)

2007-03-05 Thread Florian G. Pflug
Dave Page wrote: --- Original Message --- From: "Florian G. Pflug" <[EMAIL PROTECTED]> To: pgadmin-hackers Sent: 05/03/07, 19:40:09 Subject: [pgadmin-hackers] pgadmin3 1.6.2 + wxGTK 2.8.0 on Ubuntu Edgy (gcc 4.1) Hi I just tried compiling pgadmin3 1.6.2 + wxGTK 2.8.

[pgadmin-hackers] pgadmin3 1.6.2 + wxGTK 2.8.0 on Ubuntu Edgy (gcc 4.1)

2007-03-05 Thread Florian G. Pflug
Hi I just tried compiling pgadmin3 1.6.2 + wxGTK 2.8.0 on Ubuntu Edgy, which by default uses gcc 4.1 I got lots of "undefined symbols" errors for string-related classes during linking. I work fine when I use gcc 3.4. Is anyone else seeing these problems, or is there something strange going on o

Re: [pgadmin-hackers] Patch for column properties

2007-03-02 Thread Florian G. Pflug
Dave Page wrote: Guillaume Lelarge wrote: Hi, When someone set a default value for a column and set NOT NULL at the same time, the query could fail if the table already contains NULL values for this column. This patch adds an UPDATE statement to put the DEFAULT value in this column for all N

Re: [pgadmin-hackers] [PATCH] Patches for pg_dumpall, complete-bundle.sh and dmg creation

2007-02-16 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug wrote: 3) The last patch ist a first shot at a create-dmg script. It seems to work quite fine - it even attaches a license to the dmg that the user has to accept before the dmg is mounted ;-) Cool - works a treat here so I've replaced the installer wi

[pgadmin-hackers] [PATCH] Patches for pg_dumpall, complete-bundle.sh and dmg creation

2007-02-15 Thread Florian G. Pflug
Hi Here are various small patches I created today. 1) The first (pgadmin3-dumpall.patch) adds pg_dumpall to the list of postgres binaries that are copied into the app bundle. 2) When testing that one, I noticed that complete-bundle.sh seems to be broken - at lost on my 10.3.9 buildserver. The r

Re: [pgadmin-hackers] SVN Commit by dpage: r5916 - in trunk/pgadmin 3:. pgadmin pgadmin/frm pgadmin/include/frm pgadmin/include/schema pgadmin/u ipkg/win32/src

2007-02-14 Thread Florian G. Pflug
Dave Page wrote: --- Original Message --- From: "Florian G. Pflug" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: 14/02/07, 17:32:59 Subject: Re: [pgadmin-hackers] SVN Commit by dpage: r5916 - in trunk/pgadmin3:. pgadmin pgadmin/frm pgadmin/include/frm pgadmin/include

Re: [pgadmin-hackers] SVN Commit by dpage: r5916 - in trunk/pgadmin3: . pgadmin pgadmin/frm pgadmin/include/frm pgadmin/include/schema pgadmin/ui pkg/win32/src

2007-02-14 Thread Florian G. Pflug
[EMAIL PROTECTED] wrote: Author: dpage Date: 2007-02-14 11:34:37 + (Wed, 14 Feb 2007) New Revision: 5916 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=5916&view=rev Log: Allow global server objects (roles, tablespaces) to be backed up. Does this mean that pgadmin now

[pgadmin-hackers] Why is pgadmin3 distributet as a .pkg?

2007-01-09 Thread Florian G. Pflug
Hi I just noticed that the official builds of pgadmin3 for OSX are distributed as a .pkg. Since this package only installs a single Folder (pgAdmin3.app) into /Applications, I believe that distribution as a .pkg creates more trouble for a user than a plain zip/bz2/dmg containing pgAdmin3.app Add

Re: [pgadmin-hackers] Build failure on OSX 10.3 with wx 2.8.0

2006-12-30 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug wrote: My night build on osx 10.3.9 with wx widgest 2.8 fails with agent/pgaJob.cpp:303: error: `Refresh' undeclared (first use this function) agent/pgaJob.cpp:303: error: (Each undeclared identifier is reported only once Does anyone know a plausible

[pgadmin-hackers] Build failure on OSX 10.3 with wx 2.8.0

2006-12-29 Thread Florian G. Pflug
Hi My night build on osx 10.3.9 with wx widgest 2.8 fails with agent/pgaJob.cpp:303: error: `Refresh' undeclared (first use this function) agent/pgaJob.cpp:303: error: (Each undeclared identifier is reported only once Does anyone know a plausible cause for this, or shall I go investigating? gre

Re: [pgadmin-hackers] Buid fails on OSX 10.3.9

2006-10-25 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug Sent: 24 October 2006 09:46 Hi The build fails since yesterday on OSX 10.3.9, using wx-2.7.0 This is the error message: dlg/dlgIndex.cpp:42: error: invalid static_cast from type `' to type `void (wxEvtHandler::*)(wxListEvent&)' dlg/dlgIndex

[pgadmin-hackers] Buid fails on OSX 10.3.9

2006-10-24 Thread Florian G. Pflug
Hi The build fails since yesterday on OSX 10.3.9, using wx-2.7.0 This is the error message: dlg/dlgIndex.cpp:42: error: invalid static_cast from type `' to type `void (wxEvtHandler::*)(wxListEvent&)' dlg/dlgIndex.cpp:43: error: invalid static_cast from type `' to type `void (wxEvtHandler::*

Re: [pgadmin-hackers] Suggested query editor improvements: Tabs and

2006-09-26 Thread Florian G. Pflug
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 19 September 2006 23:57 To: pgadmin-hackers@postgresql.org Subject: [pgadmin-hackers] Suggested query editor improvements: Tabs and Indentation I work really ap

Re: [pgadmin-hackers] Mac Universal build

2006-09-01 Thread Florian G. Pflug
Dave Page wrote: Hi Chris, Florian I've managed to produce a Universal OSX appbundle, which I've uploaded to: http://developer.pgadmin.org/snapshots/osx/pgadmin3-1.5.0-mac-universal.tar. bz2 Otool reports the executable and libs are all Universal, and complete-bundle.sh appears to have rewritt

Re: [pgadmin-hackers] Build fails on OSX using wx 2.7.0

2006-08-31 Thread Florian G. Pflug
Florian G. Pflug wrote: Dave Page wrote: On 31/8/06 16:17, "Chris Campbell" <[EMAIL PROTECTED]> wrote: On Aug 31, 2006, at 11:00, Dave Page wrote: Yeah. They can include ppc64 as well. GCC will create them just fine, or you can build them individually and combine the resul

Re: [pgadmin-hackers] Build fails on OSX using wx 2.7.0

2006-08-31 Thread Florian G. Pflug
Dave Page wrote: On 31/8/06 16:17, "Chris Campbell" <[EMAIL PROTECTED]> wrote: On Aug 31, 2006, at 11:00, Dave Page wrote: Yeah. They can include ppc64 as well. GCC will create them just fine, or you can build them individually and combine the resulting executables and libs using the lipo t

Re: [pgadmin-hackers] Build fails on OSX using wx 2.7.0

2006-08-31 Thread Florian G. Pflug
Dave Page wrote: -Original Message- From: Florian G. Pflug [mailto:[EMAIL PROTECTED] Sent: 31 August 2006 16:00 To: Dave Page Cc: pgadmin-hackers Subject: Re: [pgadmin-hackers] Build fails on OSX using wx 2.7.0 *Putting brown paper bag over my head*. Arg! Forget it, it was not g

Re: [pgadmin-hackers] Build fails on OSX using wx 2.7.0

2006-08-31 Thread Florian G. Pflug
Dave Page wrote: -Original Message- From: Florian G. Pflug [mailto:[EMAIL PROTECTED] Sent: 31 August 2006 15:14 To: Dave Page Cc: pgadmin-hackers Subject: Re: [pgadmin-hackers] Build fails on OSX using wx 2.7.0 Dave Page wrote: -Original Message- From: [EMAIL PROTECTED

Re: [pgadmin-hackers] Build fails on OSX using wx 2.7.0

2006-08-31 Thread Florian G. Pflug
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Florian G. Pflug Sent: 31 August 2006 09:35 To: pgadmin-hackers Subject: [pgadmin-hackers] Build fails on OSX using wx 2.7.0 ld: Undefined symbols: wxString::mb_str(wxMBConv&) c

[pgadmin-hackers] Build fails on OSX using wx 2.7.0

2006-08-31 Thread Florian G. Pflug
Hi I upgraded to wxMac 2.7.0 yesterday, and I'm getting the following error now. g++ -Wall -Wno-non-virtual-dtor -I../src/include -I../src/agent/include -I../src/slony/include -L/Users/pgadmin3/Installs/PostgreSQL/8.1.3/lib -L/Users/pgadmin3/Installs/wxMac//2.7.0/lib -o pgadmin3 svnversion.o

Re: [pgadmin-hackers] Bugs created by new UI / Introduction of

2006-07-07 Thread Florian G. Pflug
Dave Page wrote: From: Florian G. Pflug [mailto:[EMAIL PROTECTED] Dave Page wrote: .) Disabling an reenabling panes is broken for most cases. An example: 1) Disable results pane 2) Disable messages pane 3) Reenable both 4) Now the are displayed on top of each other, which no

Re: [pgadmin-hackers] debian package splitting: pgagent should be

2006-07-06 Thread Florian G. Pflug
Raphaël Enrici wrote: Hi Dave, as you know, I'm about to split the debian package so that pgagent can be installed separately from pgAdmin III on a server for example. I'm asking to myself if it would not be a good thing to distribute it separately upstream. I mean, something like adminpacks th

Re: [pgadmin-hackers] Bugs created by new UI / Introduction of

2006-07-05 Thread Florian G. Pflug
Dave Page wrote: .) Disabling an reenabling panes is broken for most cases. An example: 1) Disable results pane 2) Disable messages pane 3) Reenable both 4) Now the are displayed on top of each other, which no way to restore the default split-screen configuration. I canno

[pgadmin-hackers] Bugs created by new UI / Introduction of wxaui

2006-07-05 Thread Florian G. Pflug
Hi I tried my nightly build of trunk on OSX now, and noticed the following bugs and problems .) When I remove the "Object Browser" pane by clickng the little "x", I found now way to get that pane to display again. The corresponding entry in the view-menu is still checked, and even uncheckin

Re: [pgadmin-hackers] Bug in configure-detection of wxaui

2006-07-05 Thread Florian G. Pflug
Florian G. Pflug wrote: Hi Building currently fails at least on OSX, but I guess it fails on *nix too. WXAUI_HOME gets set to the _root_ auf the wxaui sources, but is later (when doing CPPFLAGS = -I$WXAUI_HOME) assumed to contain the include directory (/include). And here is why the error

[pgadmin-hackers] Bug in configure-detection of wxaui

2006-07-05 Thread Florian G. Pflug
Hi Building currently fails at least on OSX, but I guess it fails on *nix too. WXAUI_HOME gets set to the _root_ auf the wxaui sources, but is later (when doing CPPFLAGS = -I$WXAUI_HOME) assumed to contain the include directory (/include). The following (trivial) patch helps: Index: acinclude

Re: [pgadmin-hackers] pgAdmin3 1.4 stability issues on ubuntu/dapper

2006-06-23 Thread Florian G. Pflug
Dave Page wrote: Florian G. Pflug Sent: 23 June 2006 14:01 To: pgadmin-hackers I'm using Ubuntu Dapper at work now, and I'm having a hard time getting it to work properly. Ubuntu comes with wxGTK 2.6.1 (+ quite a few ubuntu/debian patches...). Using this version leads to Whole-Xserv

[pgadmin-hackers] pgAdmin3 1.4 stability issues on ubuntu/dapper

2006-06-23 Thread Florian G. Pflug
Hi I'm using Ubuntu Dapper at work now, and I'm having a hard time getting it to work properly. Ubuntu comes with wxGTK 2.6.1 (+ quite a few ubuntu/debian patches...). Using this version leads to Whole-Xserver-Lockups when doubleclicking selected text (This was discussed here a week or two ago

[pgadmin-hackers] /sw/share/aclocal/pkg.m4:5: warning: underquoted definition of PKG_CHECK_MODULES

2006-05-14 Thread Florian G. Pflug
Hi I'm getting this warning: /sw/share/aclocal/pkg.m4:5: warning: underquoted definition of PKG_CHECK_MODULES run info '(automake)Extending aclocal' or see http://sources.redhat.com/automake/automake.html#Extending-aclocal on osx, using aclocal-1.9 and autoconf-2.5 (installed from fink) sinc

[pgadmin-hackers] Help-Viewer awefully slow when using the trackpad to scroll

2006-05-07 Thread Florian G. Pflug
Hi I just noticed that the Help-View of pgadmin3 is awefully slow on osx when I scroll using the trackpad (Putting two fingers on the trackpad, and moving them up and down is the "scroll-wheel" äquivalent for trackpads on osx). This scrolling-method isn't natively support on my notebook by apple

[pgadmin-hackers] OSX build of pgadmin 1.4 still broken

2006-05-01 Thread Florian G. Pflug
Hi TRUNK builds fine now, but the 1.4 branch ist still broken (::GetLastError undeclared). I case you already knew this, nevermind my email ;-) greetings, Florian Pflug ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [pgadmin-hackers] Commits 5097(1.4 branch) and 5096(trunk) break

2006-04-29 Thread Florian G. Pflug
Andreas Pflug wrote: Florian G. Pflug wrote: Hi Starting from revisions 5097 (for 1.4) and 5096 (trunk) the OSX build failes for me. Seems like ::GetLastError() is undefined when using wxMac 2.6.2. Any ideas? Man, you really should upgrade your operating system to a compatible one

[pgadmin-hackers] Commits 5097(1.4 branch) and 5096(trunk) break the OSX build

2006-04-29 Thread Florian G. Pflug
Hi Starting from revisions 5097 (for 1.4) and 5096 (trunk) the OSX build failes for me. Seems like ::GetLastError() is undefined when using wxMac 2.6.2. Any ideas? -- diff --- Index: src/frm/frmQuery.cpp ==

Re: [pgadmin-hackers] Build failure on OSX (Solved)

2006-04-23 Thread Florian G. Pflug
Florian G. Pflug wrote: OpenMacNews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 I'm getting linker error on OSX since about two days. Any idea why the symbol __ftol is missing, and which library should provide it? ... /Users/pgadmin3/Installs/PostgreSQL/8.1.3/lib/li

Re: [pgadmin-hackers] Build failure on OSX

2006-04-23 Thread Florian G. Pflug
OpenMacNews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 I'm getting linker error on OSX since about two days. Any idea why the symbol __ftol is missing, and which library should provide it? ... /Users/pgadmin3/Installs/PostgreSQL/8.1.3/lib/libpq.a -lssl -lcrypto ld: Undefined

[pgadmin-hackers] Build failure on OSX

2006-04-23 Thread Florian G. Pflug
Hi I'm getting linker error on OSX since about two days. Any idea why the symbol __ftol is missing, and which library should provide it? g++ -Wall -Wno-non-virtual-dtor -I../src/include -I../src/agent/include -I../src/slony/include -L/Users/pgadmin3/Installs/PostgreSQL/8.1.3/lib -L/Users/pgad

Re: [pgadmin-hackers] Anyone got an Intel Mac yet?

2006-03-23 Thread Florian G. Pflug
Dave Page wrote: Does anyone have an Intel Mac that they would be willing do try building pgAdmin on? There's certainly one script that will fail, but I'm kinda hoping that will be all :-). It would be good to know for sure, and be able to fix the script (lines 20/26 of http://svn.pgadmin.org/cgi

Re: [pgadmin-hackers] Query results in grid, new patch

2006-03-06 Thread Florian G. Pflug
Andreas Pflug wrote: Dave Page wrote: On 6/3/06 19:04, "Andreas Pflug" <[EMAIL PROTECTED]> wrote: Dave Page wrote: NOT a todo. I found the result something between annoying and useless when I implemented column sizing preserving, esp. in case of many columns. I still didn't have the time to h

Re: [pgadmin-hackers] Query results in grid, new patch

2006-03-06 Thread Florian G. Pflug
Andreas Pflug wrote: > Dave Page wrote: >>> -Original Message- >>> From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 06 March >>> 2006 09:42 >>> To: Florian G. Pflug >>> Cc: Dave Page; Edward Di Geronimo Jr.; pgadmin-hackers@postgre

Re: [pgadmin-hackers] Query results in grid, new patch

2006-03-05 Thread Florian G. Pflug
Florian G. Pflug wrote: Dave Page wrote: I have been unable to make it misbehave on XP. I haven't tried OSX or Linux as I don't have either to hand atm. Can you give me a precise example to test? I have had complete success copying individual cells, groups of rows, groups of c

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

2006-02-27 Thread Florian G. Pflug
OpenMacNews wrote: hi all, % uname -a Darwin server 8.5.0 Darwin Kernel Version 8.5.0: Sun Jan 22 10:38:46 PST 2006; root:xnu-792.6.61.obj~1/RELEASE_PPC Power Macintosh powerpc You get this on Panther (10.3)? Strange... I get Darwin yosemite.solution-x.com 7.9.0 Darwin Kernel Version

Re: [pgadmin-hackers] Query results in grid, new patch

2006-02-27 Thread Florian G. Pflug
Dave Page wrote: I have been unable to make it misbehave on XP. I haven't tried OSX or Linux as I don't have either to hand atm. Can you give me a precise example to test? I have had complete success copying individual cells, groups of rows, groups of columns and arbitrary blocks of cells. I'm

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

2006-02-26 Thread Florian G. Pflug
Miha Radej wrote: 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 befor

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

2006-02-26 Thread Florian G. Pflug
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 ver

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

2006-02-26 Thread Florian G. Pflug
Dave Page wrote: On 26/2/06 16:27, "Florian G. Pflug" <[EMAIL PROTECTED]> wrote: Since this will plague more people than me, I'd suggest changing the configure-check for libxml2 to explicitly check for xmlwriter.h. Hmm, no problem on Tiger. What's the output of xml2-

[pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

2006-02-26 Thread Florian G. Pflug
Hi As you might (or might not ;-) ) have noticed, there where no nightly pgadmin-trunk builds for a few weeks now. The build broke because of problems with libxml2. I solved this now by adding a custom-built libxml2 to my buildserver and passing --with-libxml2= to configure. The funny thing, ho

Re: [pgadmin-hackers] Schema bug

2005-12-12 Thread Florian G. Pflug
Andreas Pflug wrote: > Florian G. Pflug wrote: >> I'd prefer system-catalogs being excluded by name - preferably the >> exclusion-list would be editable, and part of the pgadmin preferences. >> Seems more transparent to me - and future-proof, in the sense that >> e

Re: [pgadmin-hackers] Schema bug

2005-12-12 Thread Florian G. Pflug
Dave Page wrote: I had two ways to fix this bug : detect system schemas on their names, or detect public schema by its OID. I think it's better to only keep the public schema with its OID, it's much less risky to have a wrong one. That's what the patch is doing : AND nspname != 'public' is

Re: [pgadmin-hackers] SVN Commit by dpage: r4809 - branches/REL-1_4_0_PATCHES/pgadmin3/i18n/fr_FR

2005-12-09 Thread Florian G. Pflug
[EMAIL PROTECTED] wrote: #: src/frm/frmMain.cpp:726 msgid "Translator attention: must match backend translation!Ident authentication failed" -msgstr "" +msgstr "Translator attention: must match backend translation!Échec de l'authentification ident" #: src/frm/frmMain.cpp:724 msgid "Trans

Re: [pgadmin-hackers] Schema bug

2005-12-08 Thread Florian G. Pflug
Dave Page wrote: Andreas Pflug wrote: Guillaume LELARGE wrote: Hi, I found a weird bug today. If you rename the public schema, it becomes unavailable. Here is a patch to fix it. It modifies the query to use the oid instead of the schema's name. Works great on Linux, should'nt be a problem

Re: [pgadmin-hackers] Schema bug

2005-12-08 Thread Florian G. Pflug
Andreas Pflug wrote: Guillaume LELARGE wrote: Hi, I found a weird bug today. If you rename the public schema, it becomes unavailable. Here is a patch to fix it. It modifies the query to use the oid instead of the schema's name. Works great on Linux, should'nt be a problem on win32. Actual

Re: [pgadmin-hackers] [GENERAL] Missing variable "role" in "pg_settings"?

2005-12-05 Thread Florian G. Pflug
Tom Lane wrote: Bruce Momjian writes: Based on this email, should we be showing ROLE from SHOW ALL? Only if you think we should be showing session_authorization too. That was marked "no_show_all" quite a long time ago, and we have not got complaints about it... Hm, but before 8.1 there was n

Re: [pgadmin-hackers] pgadmin 1.4.1?

2005-11-30 Thread Florian G. Pflug
Andreas Pflug wrote: Dave Page wrote: Before would be good, for the installer! Agreed, but we should fix the grant combobox issue first. Maybe tomorrow. Please apply my "fix appbundle build breakage due to missing PG_CONFIG variable" quickfix then. Otherwise, 1.4.1 will be unbuildable on OSX.

[pgadmin-hackers] 1.4 Branch & pg_config

2005-11-30 Thread Florian G. Pflug
Hi I just noted that the OSX-build of the 1.4 build is broken due to the inclusion of the pg_dump-in-appbundle patch. The patch assumes that PG_CONFIG is available inside pkg/mac/Makefile.am, but the 1.4 buildsystem doesn't know about PG_CONFIG. Would it be feasable to backport the postgres-spec

Re: [pgadmin-hackers] [PATCH] Add pg_dump/pg_restore to appbundle

2005-11-24 Thread Florian G. Pflug
Florian G. Pflug wrote: Florian G. Pflug wrote: [snipped my own mail] [snipped again] Aagg. Again. Should go to bed, I guess ;-) The replacement-patch is broken too - This time I messed up while generating the patch with "svn diff", and of course only noticed after hit

Re: [pgadmin-hackers] [PATCH] Add pg_dump/pg_restore to appbundle

2005-11-24 Thread Florian G. Pflug
Florian G. Pflug wrote: [snipped my own mail] Aaarg.. Missed a bug. With the previous patch, pg_dump wouldn't start, because it can't find libpq. Fixed now - here is a replacement for pgadmin3.addhelper.patch, calles pgadmin3.addhelper.fixed.patch. The other patches are ok.

[pgadmin-hackers] [PATCH] Add pg_dump/pg_restore to appbundle + some cleanups.

2005-11-24 Thread Florian G. Pflug
Hi Here is a patch to copy pg_dump and pg_restore into $bundledir/Contents/SharedSupport/helper/. pgAdmin3.app should find it there, but I didn't test this yet (I just have access to my build-machine over ssh ATM - I'll need my powerbook to test this). The other patches are mostly cleanups pgadm

[pgadmin-hackers] Nightly Builds

2005-11-10 Thread Florian G. Pflug
Hi FYI, I do nightly builds of the PGADMIN3_PATCHES_1_4 (or however it is actually called ;-) ) branch, as well as of trunk. greetings, Florian Pflug smime.p7s Description: S/MIME Cryptographic Signature

Re: [pgadmin-hackers] SVN Commit by dpage: r4685 - trunk/pgadmin3

2005-11-08 Thread Florian G. Pflug
Dave Page wrote: Oddly, I did notice that it wasn't required on Mac, but possibly didn't test what happened with it there. I'll try it out on Panther tonight. A quick update to autoconf 2.59 and automake 1.9.6 did the trick on Panther. Yep, a "fink selfupdate; fink update-all" did the trick f

Re: [pgadmin-hackers] SVN Commit by dpage: r4685 - trunk/pgadmin3

2005-11-06 Thread Florian G. Pflug
[EMAIL PROTECTED] wrote: Modified: trunk/pgadmin3/configure.ac === --- trunk/pgadmin3/configure.ac 2005-11-06 10:56:54 UTC (rev 4684) +++ trunk/pgadmin3/configure.ac 2005-11-06 11:13:18 UTC (rev 4685) @@ -6,7 +6,7 @@ AC_CONFIG_SRCDI

Re: [pgadmin-hackers] [GENERAL] Duplicate Row Removal

2005-11-05 Thread Florian G. Pflug
Berend Tober wrote: Dean Gibson (DB Administrator) wrote: CREATE TABLE new_name AS SELECT DISTINCT * FROM old_name; DROP TABLE old_name; ALTER TABLE new_name RENAME TO old_name; The problem with this technique is that it doesn't account for indexes, foreign key references, and other depend

Re: [pgadmin-hackers] [GENERAL] Missing variable "role" in "pg_settings"?

2005-11-05 Thread Florian G. Pflug
Tom Lane wrote: "Florian G. Pflug" <[EMAIL PROTECTED]> writes: The per-session variable "role" is not shown when doing "select pg_settings". It is, however, possible to set it using "set role ...", and to query it using "show role&qu

Re: [pgadmin-hackers] Missing per-user variable?

2005-11-05 Thread Florian G. Pflug
Andreas Pflug wrote: In the variables tab in the user settings, the dropdown lacks the variable "role", but in psql "alter user set role " works (It make the user assume role immediatly upon login, without having to type "set role ". Well, it's not been displayed because pg_settings won't r

[pgadmin-hackers] Missing per-user variable?

2005-11-04 Thread Florian G. Pflug
Hi In the variables tab in the user settings, the dropdown lacks the variable "role", but in psql "alter user set role " works (It make the user assume role immediatly upon login, without having to type "set role ". But this is probably post 1.4... greetings, Florian Pflug smime.p7s Descri

Re: [pgadmin-hackers] RC1 uploaded

2005-11-01 Thread Florian G. Pflug
Dave Page wrote: Howdy, I've uploaded RC1 in src, win32, slackware and osx formats to http://developer.pgadmin.org/ftp/beta. Please take a quick look and report any serious issues before I announce it more widely. OSX Version seems fine. I found one small bug. When you open a query window, and

Re: [pgadmin-hackers] Default extension for sql scripts

2005-10-27 Thread Florian G. Pflug
Dave Page wrote: >>But I didn't plan to submit patches for actually opening a saved query >>with a double-click before 1.4 was branched. I just wanted to make >>pgAdmin3 announce the extension .sql, and provide an icon for it - >>something I more or less consider to be part of "behaving like a goo

Re: [pgadmin-hackers] Default extension for sql scripts

2005-10-26 Thread Florian G. Pflug
Dave Page wrote: On a related note - Does it work on windows to double-click a saved query, and have pgadmin3 start _and_ open the query in a query window? No, because pgAdmin can't guess from your script which server it should connect to. Well, thats fixed in 1.4 afaik - one can now swit

  1   2   >