Re: [pgadmin-hackers] pgAdmin3 on Intel
On Apr 9, 2006, at 3:08 AM, Dave Page wrote: -Original Message- From: Adam H. Pendleton[EMAIL PROTECTED] Sent: 09/04/06 05:14:22 To: pgadmin-hackers@postgresql.orgpgadmin-hackers@postgresql.org Subject: [pgadmin-hackers] pgAdmin3 on Intel Hi Adam While pgAdmin3 compiles great on my MacBook, Cool, that's good news. Does the appbundle build OK as well? Yes, appbundle builds great! pgAdmin3 runs well, too. creating a Universal Binary will be a challenge. I spent all night trying to get autoconf to create one, but it's not working. :-( Yeah, it's a pain. I tried to get it to work the same way the wx folks did, but it just doesn't seem to want to come together. I'll try and get XCode to work tomorrow. I'm also working on creating a frmEditGrid sample app for testing. Ok - I'd be interested in keeping an Xcode project in SVN if you build one - it'd make debugging on Mac infinitely easier for one thing. Okay, then I'll focus on getting a XCode project built. It will make lots of things easier on the mac. ahp ---(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] pgAdmin3 on Intel
While pgAdmin3 compiles great on my MacBook, creating a Universal Binary will be a challenge. I spent all night trying to get autoconf to create one, but it's not working. I'll try and get XCode to work tomorrow. I'm also working on creating a frmEditGrid sample app for testing. ahp ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] [pgadmin-support] mac osX edit table data
Here's what I've got: Program received signal EXC_BAD_ACCESS, Could not access memory. Reason: KERN_INVALID_ADDRESS at address: 0xbf7fffc0 0x93120364 in BSearch () (gdb) bt #0 0x93120364 in BSearch () #1 0x931207e4 in TEventTypeIndex::ContainsType () #2 0x93121dac in GenerateHandlerStackForEventTypeFromTarget () #3 0x931218f0 in DispatchEventToHandlers () #4 0x9312120c in SendEventToEventTargetInternal () #5 0x93121088 in SendEventToEventTargetWithOptions () #6 0x9316602c in SendControlDefGetFocusPart () #7 0x93161d20 in HIView::SetFocusPart () #8 0x93161ae8 in SetKeyboardFocus () #9 0x00313500 in ?? () #10 0x00262890 in ?? () #11 0x002fb810 in ?? () #12 0x00301760 in ?? () #13 0x006a89e8 in wxGrid::DisableCellEditControl () #14 0x00302048 in ?? () #15 0x001b6d38 in ?? () #16 0x001bd670 in ?? () #17 0x001bdcd0 in ?? () #18 0x001bf4d0 in ?? () #19 0x0026be74 in ?? () #20 0x0026c6b8 in ?? () #21 0x93121ab4 in DispatchEventToHandlers () #22 0x9312120c in SendEventToEventTargetInternal () #23 0x93121088 in SendEventToEventTargetWithOptions () #24 0x931621b0 in SendControlDefSetFocusPart () #25 0x93161edc in HIView::SetFocusPartInternal () #26 0x93161d44 in HIView::SetFocusPart () #27 0x93161ae8 in SetKeyboardFocus () ... #10680 0x93121ab4 in DispatchEventToHandlers () #10681 0x9312120c in SendEventToEventTargetInternal () #10682 0x93121088 in SendEventToEventTargetWithOptions () #10683 0x931621b0 in SendControlDefSetFocusPart () #10684 0x93161edc in HIView::SetFocusPartInternal () #10685 0x93161d44 in HIView::SetFocusPart () #10686 0x93161ae8 in SetKeyboardFocus () #10687 0x00313500 in ?? () #10688 0x00262890 in ?? () #10689 0x002fb810 in ?? () #10690 0x00301760 in ?? () #10691 0x006a89e8 in wxGrid::DisableCellEditControl () That backtrace goes on forever until I hit Ctrl+C. Never seen anything like it. Any ideas? On Jun 27, 2005, at 5:59 AM, Adam H. Pendleton wrote: I'll take a look at it today and see what I can come up with. On Jun 27, 2005, at 3:17 AM, Dave Page wrote: Hi Richard/Florian/Adam, I don't know if any of you are on the support list, hence this forward. Could one of you find a few minutes to look at this please? Thanks, Dave. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Iannicello Sent: 26 June 2005 17:31 To: pgadmin-support@postgresql.org Subject: [pgadmin-support] mac osX edit table data When I try to add a new data to the table in the 'Table/View Data' window, the program crashes after putting data in one column and trying to go to the next column to put data. I'm using OsX 10.3.9 and pgadmin version 1.2.2. If this bug could fixed the rest of the app's interface looks great. John ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] New acinclude.m4
On May 19, 2005, at 4:34 AM, Dave Page wrote:It's already mode 755 on a fresh checkout here.Hmmm, it seems that everything gets a mode of 644 when I use the "download tarball" option from the cvsweb interface (still waiting for a Fink binary for Tiger!).ahp
Re: [pgadmin-hackers] New acinclude.m4
Yes. Nice catch. On May 19, 2005, at 1:07 PM, Raphaël Enrici wrote: Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adam H. Pendleton Sent: 18 May 2005 22:26 To: pgadmin-hackers@postgresql.org Subject: [pgadmin-hackers] New acinclude.m4 Attached is a new acinclude.m4, and a patch to our current acinclude, that relies on wx-config for all the flags. Gone is all the complicated stuff. The only thing this new acinclude doesn't do is warn about a missing stc or ogl. It will link against them, but if a user doesn't have them, their compile will fail. I'll be adding in stub programs to test for this in my next version. In the meantime, test and enjoy. Great, thanks Adam - committed. I have warning concerning ENABLE_STATIC in configure script. Shouldn't we also remove it crom configure.ac ? (patch attached). Regards, Raphaël Index: configure.ac === --- configure.ac(revision 4219) +++ configure.ac(working copy) @@ -35,7 +35,6 @@ CHECK_WX_CONFIG_BINARY CHECK_PGSQL_INCLUDE ENABLE_DEBUG -ENABLE_STATIC CHECK_PGSQL CHECK_WXWINDOWS ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] New acinclude.m4
On May 19, 2005, at 3:24 PM, Florian G. Pflug wrote: Raphaël Enrici wrote: Florian G. Pflug wrote: Raphaël Enrici wrote: I have warning concerning ENABLE_STATIC in configure script. Shouldn't we also remove it crom configure.ac ? (patch attached). Does this mean the linking statically is not possible anymore? Or has the check just moved to another place? To me, as Adam is making the build relying on wx-config flags, the build is considered static if wxWid was built with --disabled-shared passed to its configure. In the case where wxWidgets has been built with --enable-shared, pgadmin will inherit this default and build dynamically (same thing if both shared and static wxWid libs were built, the shared build will become the default...). Will a statically-built wx make the _whole_ pgadmin link statically too, or will only the wx-libraries be linkes statically and e.g. libpq dynamically. It would be the right thing to do, I guess - but then there would be need for a global --enable-static flag, that defined the linking-type for all other libs beside wx. At least for OSX, linking the release-versions statically it the most reliable method, while keeping the resulting app small. I ran into some real problems trying to link the whole app statically, especially on Linux. There is a flag that can be passed (to ld I think) that makes all linking static, but IIRC I found that some linux libraries didn't like that much, and would require dynamic linking. Besides, in this day and age, there really isn't any reason to completely statically link, except for debugging purposes, and it's really only statically linking against wx that we care about in that case. ahp ---(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] New acinclude.m4
On May 19, 2005, at 3:46 PM, Raphaël Enrici wrote: Can you try the patch attached on OSX with a fresh checkout (don't apply the configure.ac I just sent) ? (I need to rebuild wxWid to generate static libs... it may take a moment). Your attached patch isn't going to do anything. `wx-config --libs` and `wx-config --libs --static` both return the same thing, unless you have both a static and dynamic version of wx2 in the same tree. For 99% of us, adding the --static flag makes no difference. ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] New acinclude.m4
On May 19, 2005, at 2:13 PM, Florian G. Pflug wrote: Raphaël Enrici wrote: I have warning concerning ENABLE_STATIC in configure script. Shouldn't we also remove it crom configure.ac ? (patch attached). Does this mean the linking statically is not possible anymore? Or has the check just moved to another place? Static linking is totally dependent on how wx2 was built. If wx2 was built statically, we link statically. If it was not a static build we dynamically link. ahp ---(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] New acinclude.m4
On May 19, 2005, at 4:30 PM, Raphaël Enrici wrote: Adam H. Pendleton wrote: I'm glad to be so rare... It seems I belong to the 1%: I have a dynamic build. ;) Please also note that the patch attached reintroduce your code concerning the static link of the rest of the libs (libpq and sons). However, you are the ac guru and I'm fully satisfied by a dynamic linking with the new acinclude.m4 (+ the configure.ac patch). The real question is: - do we still need full static linking (at least libpq, ssl,..?). If yes, then the new acinclude.m4 does not provide it anymore and we need to rework on it. Are you saying that `wx-config --libs` and `wx-config --libs -- static` produce two different outputs on your system? If you built wx dynamically then either a) the output from --libs --static is nonsense, or b) it's the same as --libs. Either way, the current acinclude will link the same way you linked wx. As for the full static linking, --enable-static never performed a full static link, it only statically linked against wxWindows. Personally, I don't like static linking. It creates huge executables, eats up memory, and slows down performance. We should link dynamically wherever possible. ahp ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] New acinclude.m4
On May 19, 2005, at 4:54 PM, Raphaël Enrici wrote: What I'm trying to say is this: I've a dynamic only build. So, wx-config --libs is ok. wx-config --static --libs gives an error. According to what I understand from the wx-config --help output is: if I had both built and would like to get informations concerning the static wxWid libs, then I'd need to pass --static to wx-config. Right? Yes. The --static flag is only useful in the case where a user has both a static and dynamic build of wxWidgets in the same tree. yup, _I HATE STATIC BUILDS TOO_ :)) But, it seems that at least for Florian this is important. The latest patch I sent just does two things: a) force static parameters of wxWid, just in case the wx-config --libs would not give the _static_ lib informations when both shared and static are installed on the system. Yes, your patch would add support for those people with both build types. b) re-introduce the pg_static_build=yes variable which is later interpreted just as in previous versions because the old code is still there. There are no references to pg_static_build in acinclude any more. Well, okay there's one, but it doesn't do anything because pg_static_build isn't set anywhere (sans your patch, of course). Your patch is fine, just know that it terms of statically linking pgAdmin3 as a whole it does nothing. It only helps any user with both a dynamic and static wx select the one they want. ahp ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-hackers] New acinclude.m4
Attached is a new acinclude.m4, and a patch to our current acinclude, that relies on wx-config for all the flags. Gone is all the complicated stuff. The only thing this new acinclude doesn't do is warn about a missing stc or ogl. It will link against them, but if a user doesn't have them, their compile will fail. I'll be adding in stub programs to test for this in my next version. In the meantime, test and enjoy. On another note, could someone please check out ./pkg/mac/complete- bundle.sh and chmod +x it? The compile on mac fails with an error because the execute bit is not set. ahp acinclude.m4.patch Description: Binary data acinclude.m4 Description: Binary data ---(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] acinclude.m4 and wx detection question
On May 5, 2005, at 4:47 PM, Raphaël Enrici wrote: Hi Adam, I have a small question in mind I never asked concerning the way we check for wxwidgets files installed while in configure scripts (for example stc headers). Why don't we try to build small C or C++ examples which includes the required files and check to see if the build failed instead of hardcoding some test on file existance ? Or maybe we could parse the '-I' outputs of wx-confg --cflags or cxxflags to take as a base for the tests ? We do use the wx-confg output for our basis: WX_NEW_LDFLAGS=`${WX_CONFIG} --static --libs` IMHO we would gain in both portability (it would be easier to take care of specific configuration) and maintenance (no more change needed to acinclude.m4 if we change the version of wxwidgets we support). As an example, my wx-config outputs is this one: wx-config --cflags -I/usr/lib/wx/include/gtk2-unicode-debug-static-2.6-pga3 -I/usr/include/wx-2.6-pga3 -D__WXDEBUG__ -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 Yes, but how would we go about finding the wx-config file in the first place? If I want the configure script to pass with such a configuration, I must patch acinclude.m4 so that it refers to the correct path. If not, it just fails and tells me that I did not install stc which is not true. If we were trying to detect this with a small program like this: #include wx/stc/stc.h ... void main(void) { } Again, you have to find wx-config. The other problem is that wx programs will fail if you don't link against the wx libraries. Since the wx library names are not reported by wx-config, we have to try all the possible wx lib names (because they've changed to many times). I'll take another look at this and see if we can't make some improvements, but the acinclude.m4 has to be able to handle all the one-offs, which usually requires a lot of manual checking, but we'll see what we can do! ahp ---(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] acinclude.m4 and wx detection question
On May 5, 2005, at 5:23 PM, Raphaël Enrici wrote: Yes, but how would we go about finding the wx-config file in the first place? Aren't the --with-wx* flags you gave to us useable for this ? I personnaly use them each time I build pga3 like this: --with-wx=/usr --with-wx-config=wx-config Absolutely, but the configure script must be able to deal with situations in which the user does not pass that flag. In theory, a user should be able to do the following to build pgAdmin3: ./configure make make install Again, you have to find wx-config. The other problem is that wx programs will fail if you don't link against the wx libraries. Since the wx library names are not reported by wx-config, we have to try all the possible wx lib names (because they've changed to many times). mmmh, I missed that part of the process, but: wx-config --libs gives some informations. In my case : -pthread -L/usr/X11R6/lib /usr/lib/libwx_gtk2ud_pga3_xrc-2.6.a /usr/lib/libwx_gtk2ud_pga3_html-2.6.a /usr/lib/libwx_gtk2ud_pga3_adv-2.6.a /usr/lib/libwx_gtk2ud_pga3_core-2.6.a /usr/lib/libwx_baseud_pga3_xml-2.6.a /usr/lib/libwx_baseud_pga3_net-2.6.a /usr/lib/libwx_baseud_pga3-2.6.a -Wl,--export-dynamic -pthread -lgtk-x11-2.0 -lgdk-x11-2.0 -latk-1.0 -lgdk_pixbuf-2.0 -lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -lgthread-2.0 -lglib-2.0 -lXinerama -lXxf86vm -lpng - ljpeg -ltiff -lexpat -lwxregexud_pga3-2.6 -lz -ldl -lm See this is new. wx-config didn't use to return this. With this information I can make the autoconf script much cleaner! ahp ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] CVS HEAD compile error
I'm trying to compile pgadmin3, but I get this error: ./ui/frmHint.cpp:47: error: non-local variable 'anonymous struct hintArray []' uses anonymous type Any idea what's going on? ahp ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] CVS HEAD compile error
Did you commit a fix? ahp On May 2, 2005, at 1:13 PM, Andreas Pflug wrote: Adam H. Pendleton wrote: I'm trying to compile pgadmin3, but I get this error: ./ui/frmHint.cpp:47: error: non-local variable 'anonymous struct hintArray []' uses anonymous type Any idea what's going on? DCE (Dumb Compiler Error :-) Seems we must name it. Regards, Andreas ---(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] CVS HEAD compile error
Is this really a dumb compiler error? What data type is hintArray []? It needs a data type, not a name. ahp On May 2, 2005, at 1:13 PM, Andreas Pflug wrote: Adam H. Pendleton wrote: I'm trying to compile pgadmin3, but I get this error: ./ui/frmHint.cpp:47: error: non-local variable 'anonymous struct hintArray []' uses anonymous type Any idea what's going on? DCE (Dumb Compiler Error :-) Seems we must name it. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] configure doesn't find my pgsql installation
Here's the culprit: configure:4912: checking for PQexec in -lpq configure:4942: gcc -o conftest -Wall -g -O0 -I/local/pkg/pgsql8.0//include -L/local/pkg/pgsql8.0//lib conftest.c -lpq -lssl -lcrypto -lpq 5 /usr/bin/ld: cannot find -lssl This is the old -lssl bug. I submitted a fix for this a while back, but I guess it never made it. :-) Try the attached patch and see if fixes your problems. You'll have to re-run bootstrap after applying the patch. ahp --- pgadmin3/acinclude.m4 Tue Nov 23 15:31:49 2004 +++ pgadmin3.new/acinclude.m4 Tue Nov 23 15:31:30 2004 @@ -119,14 +119,24 @@ fi if test $pg_static_build = yes then -LIBS=${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lssl -lcrypto +if test $pgsql_ssl_libpq = yes +then +LIBS=${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lssl -lcrypto +else +LIBS=${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lcrypto +fi else -LIBS=$LIBS -lssl -lcrypto -lpq +if test $pgsql_ssl_libpq = yes +then +LIBS=$LIBS -lssl -lcrypto -lpq +else +LIBS=$LIBS -lcrypto -lpq +fi fi AC_LANG_SAVE AC_LANG_C AC_CHECK_LIB(pq, PQexec, [pgsql_cv_libpq=yes], [pgsql_cv_libpq=no]) -AC_CHECK_LIB(pq, SSL_connect, [pgsql_ssl_libpq=yes], [pgsql_ssl_libpq=np]) +AC_CHECK_LIB(pq, SSL_connect, [pgsql_ssl_libpq=yes], [pgsql_ssl_libpq=no]) AC_CHECK_HEADER(libpq-fe.h, [pgsql_cv_libpqfe_h=yes], [pgsql_cv_libpqfe_h=no]) AC_LANG_RESTORE if test $pgsql_cv_libpq = yes -a $pgsql_cv_libpqfe_h = yes ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] configure doesn't find my pgsql installation
Could you send the config.log file generated by configure? This will help in debugging the problem. Serguei A. Mokhov wrote: Hello, My pgsql is installed in /local/pkg/pgsql8.0, but configure of pgadmin can't seem to be persuaded to believe that or anything else for that matter. Could you hint me what am I doing wrong? (I have pg in fact in two different locations, one is fresh from CVS the other is 8.0.1, none is found by the pgadmin's configure). [EMAIL PROTECTED] pgadmin3] % uname -srvpio Linux 2.6.5-1.358 #1 Sat May 8 09:04:50 EDT 2004 i686 i386 GNU/Linux pg version: bleeding edge padmin version: alike [EMAIL PROTECTED] pgadmin3] % ./configure --prefix=/local/pkg/pgadmin3 --enable-debug --with-pgsql=/local/pkg/pgsql8.0/ checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking for style of include used by make... GNU checking dependency style of gcc... gcc3 checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... gcc3 checking how to run the C preprocessor... gcc -E checking for egrep... grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking arpa/inet.h usability... yes checking arpa/inet.h presence... yes checking for arpa/inet.h... yes checking netdb.h usability... yes checking netdb.h presence... yes checking for netdb.h... yes checking netinet/in.h usability... yes checking netinet/in.h presence... yes checking for netinet/in.h... yes checking for stdlib.h... (cached) yes checking for stdbool.h that conforms to C99... yes checking for _Bool... yes checking for an ANSI C-conforming const... yes checking for size_t... yes checking whether time.h and sys/time.h may both be included... yes checking for working strtod... yes checking for gethostbyname... yes checking for inet_ntoa... yes checking for memmove... yes checking for memset... yes checking for strchr... yes checking for wx-config binary... yes checking for pgsql include files... yes checking for pgsql... yes checking for PQexec in -lpq... no checking for SSL_connect in -lpq... no checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes checking pgsql in /local/pkg/pgsql8.0/... failed configure: error: you must specify a valid pgsql installation with --with-pgsql=DIR Thanks, ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-hackers] acinclude.m4 patch
Attached is a patch that fixes the SSL pq library problem (hopefully!!). Can someone who has encountered these problems please test it? ahp acinclude.m4.patch Description: Binary data ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] Mac Language and _()
On Sep 21, 2004, at 1:30 PM, Andreas Pflug wrote: Maybe your mac detects the missing the slant eyes :-) First you can remove language files, in that case it should fall back to english. Still, in any case a wrong/missing translation may not result in an invalid string, apparently that's what's happening. It might be quite hard to locate this with pgadmin sources. AFAIR there's a locale sample in wx, can you try that? Sorry it's taken so long to get back to you on this. The internat wxWidgets sample works correctly on my Mac. When I run it, I get the language selection dialog, then I get French, English, German, etc. menus depending on which language I select. Looks like I'm probably doing something wrong when I build pgAdmin3. ahp ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] pgAdmin3 on Mac
So I've gotten pgAdmin3 to run on the Mac, but I'm having some problems. For starters I had to change where all the resources are located, since Mac puts them in a specific location. Now, when I startup I see the attached error. Shouldn't the assert message look different? In other words, shouldn't this line: #define chkXRC(id) XRCID(#id) == id prevent chkXRC(id) from actually appearing in the assert? In any event, I would assume that pgAdmin3 can't find the xrc files, perhaps? ahpinline: Assert.jpg ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] Further Mac woes
Okay, from my last post you can see that pgAdmin3 isn't doing a good job of selecting my default language. Now, when I continue after the assert dialog, the program crashes with this backtrace: #0 0x90006e40 in strlen () #1 0x1286296c in wxMacStringToPascal(wxString const, unsigned char*) ([EMAIL PROTECTED], to=0xb124 \022\177= ) at ../src/mac/carbon/utils.cpp:692 #2 0x0e813644 in wxNotebook::MacSetupTabs() (this=0x1f6db6a0) at ../src/mac/carbon/notebmac.cpp:372 #3 0x0e8133d8 in wxNotebook::InsertPage(unsigned long, wxWindow*, wxString const, bool, int) (this=0x1f6db6a0, nPage=0, pPage=0x1f6dc570, [EMAIL PROTECTED], bSelect=false, imageId=-1) at ../src/mac/carbon/notebmac.cpp:317 #4 0x0e992f44 in wxBookCtrl::AddPage(wxWindow*, wxString const, bool, int) (this=0x1f6db6a0, page=0x1f6dc570, [EMAIL PROTECTED], bSelect=false, imageId=-1) at ../include/wx/bookctrl.h:146 #5 0x17f719f0 in frmMain::frmMain(wxString const) (this=0x2816000, [EMAIL PROTECTED]) at /Users/fmonkey/Projects/pgadmin3/src/ui/frmMain.cpp:287 #6 0x17f6dfcc in frmMain::frmMain(wxString const) (this=0x2816000, [EMAIL PROTECTED]) at /Users/fmonkey/Projects/pgadmin3/src/ui/frmMain.cpp:113 #7 0x13990dcc in pgAdmin3::OnInit() (this=0x111ad40) at /Users/fmonkey/Projects/pgadmin3/src/pgAdmin3.cpp:488 #8 0x13996e84 in wxAppConsole::CallOnInit() (this=0x111ad40) at ../../wx2/include/wx-2.5/wx/app.h:87 #9 0x12816ac4 in wxEntry(int, wchar_t**) ([EMAIL PROTECTED], argv=0x111aa00) at ../src/common/init.cpp:394 #10 0x12816c2c in wxEntry(int, char**) ([EMAIL PROTECTED], argv=0xbc88) at ../src/common/init.cpp:457 #11 0x1398fc04 in main (argc=1, argv=0xbc88) at /Users/fmonkey/Projects/pgadmin3/src/pgAdmin3.cpp:96 #1, wxMacStringToPascal is below: void wxMacStringToPascal( const wxStringfrom , StringPtr to ) { wxCharBuffer buf = from.mb_str( wxConvLocal ) ; int len = strlen(buf) ; if ( len 255 ) len = 255 ; to[0] = len ; memcpy( (char*) to[1] , buf , len ) ; } The program crashes on the int len = strlen(buf) because buf = NULL before that call, which means the conversion to a c-string fails in the previous line, which I think might have something to do with language, since it appears that from is properly defined when the function is called (can't tell for sure since wxStrings don't really show well in a debugger). Any ideas? ahp ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] Further Mac woes
Okay, from my last post you can see that pgAdmin3 isn't doing a good job of selecting my default language. Now, when I continue after the assert dialog, the program crashes with this backtrace: #0 0x90006e40 in strlen () #1 0x1286296c in wxMacStringToPascal(wxString const, unsigned char*) ([EMAIL PROTECTED], to=0xb124 \022\177= ) at .../src/mac/carbon/utils.cpp:692 #2 0x0e813644 in wxNotebook::MacSetupTabs() (this=0x1f6db6a0) at .../src/mac/carbon/notebmac.cpp:372 #3 0x0e8133d8 in wxNotebook::InsertPage(unsigned long, wxWindow*, wxString const, bool, int) (this=0x1f6db6a0, nPage=0, pPage=0x1f6dc570, [EMAIL PROTECTED], bSelect=false, imageId=-1) at .../src/mac/carbon/notebmac.cpp:317 #4 0x0e992f44 in wxBookCtrl::AddPage(wxWindow*, wxString const, bool, int) (this=0x1f6db6a0, page=0x1f6dc570, [EMAIL PROTECTED], bSelect=false, imageId=-1) at ../include/wx/bookctrl.h:146 #5 0x17f719f0 in frmMain::frmMain(wxString const) (this=0x2816000, [EMAIL PROTECTED]) at /Users/fmonkey/Projects/pgadmin3/src/ui/frmMain.cpp:287 #6 0x17f6dfcc in frmMain::frmMain(wxString const) (this=0x2816000, [EMAIL PROTECTED]) at /Users/fmonkey/Projects/pgadmin3/src/ui/frmMain.cpp:113 #7 0x13990dcc in pgAdmin3::OnInit() (this=0x111ad40) at /Users/fmonkey/Projects/pgadmin3/src/pgAdmin3.cpp:488 #8 0x13996e84 in wxAppConsole::CallOnInit() (this=0x111ad40) at .../../wx2/include/wx-2.5/wx/app.h:87 #9 0x12816ac4 in wxEntry(int, wchar_t**) ([EMAIL PROTECTED], argv=0x111aa00) at ../src/common/init.cpp:394 #10 0x12816c2c in wxEntry(int, char**) ([EMAIL PROTECTED], argv=0xbc88) at ../src/common/init.cpp:457 #11 0x1398fc04 in main (argc=1, argv=0xbc88) at /Users/fmonkey/Projects/pgadmin3/src/pgAdmin3.cpp:96 #1, wxMacStringToPascal is below: void wxMacStringToPascal( const wxStringfrom , StringPtr to ) { wxCharBuffer buf = from.mb_str( wxConvLocal ) ; int len = strlen(buf) ; if ( len 255 ) len = 255 ; to[0] = len ; memcpy( (char*) to[1] , buf , len ) ; } The program crashes on the int len = strlen(buf) because buf = NULL before that call, which means the conversion to a c-string fails in the previous line, which I think might have something to do with language, since it appears that from is properly defined when the function is called (can't tell for sure since wxStrings don't really show well in a debugger). Any ideas? ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] Mac Language and _()
I've isolated the pgAdmin3 crash on Mac: listViews-AddPage(properties, _(Properties));// NBP_PROPERTIES This fails, but this: listViews-AddPage(properties, wxT(Properties));// NBP_PROPERTIES succeeds, so clearly there is something amiss with the unicode/translation stuff. It probably has something to do with the fact that pgAdmin3 thinks I'm Chinese. I'm not sure what to do next...any ideas? ahp ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [pgadmin-hackers] ssl configure
On Aug 11, 2004, at 7:46 AM, Dave Page wrote: -Original Message- From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] Sent: 11 August 2004 12:22 To: Dave Page Cc: Andreas Pflug; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] ssl configure Can you send me a config.log from a system that has SSL, but didn't build with it? Attached. H, this line should have failed with SSL dependency errors: configure:4619: checking for PQexec in -lpq configure:4650: gcc -o conftest -Wall -g -O0 -I/usr/local/pgsql/include -L/usr/local/pgsql/lib conftest.c -lpq 5 But it didn't, so you should roll back the patch until I can figure something better out. Sorry. :-( ahp ---(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
[pgadmin-hackers] acinclude.m4 patch
This patch addresses problems with compiling pgadmin3 against a non-ssl postgres installation. Can someone without ssl please test it? ahp acinclude.m4.patch Description: Binary data ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [pgadmin-hackers] [pgadmin-support] pgAdmin3 doesn't work after
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Devrim GUNDUZ wrote: | I got the same error while building the rpm: Hmmm, I built pgAdmin3 on FC2 without issue. Of course I was messing with the CVS version of wxWidgets, but Did you use a binary package of wxWidgets or did you re-build that package on FC2 before you build pgAdmin3? ahp -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAyJZ6f/U4M//FQ/URAhF1AJ9g7z3CQR9MMF7s3/W8m3aCB4g+YQCeO2nf 0nUPIx4EaOH2KllkfLBEO84= =7oqA -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] [pgadmin-support] pgAdmin3 doesn't work after
Jean-Michel POURE wrote: Le jeudi 10 Juin 2004 19:12, Adam H. Pendleton a écrit : Did you use a binary package of wxWidgets or did you re-build that package on FC2 before you build pgAdmin3? Dear Adam, Did you try building wx RPMs using the wx custom script? Last time I used the script (nearly one year ago, a decade in computing!), the script was of good quality. This is quite a pitty that they do not release RPMs more often. I never build the RPMs...:-( ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Another MacOS install attempt
David Hustace wrote: I really have tried to resolve this issue googling and searching the list... I have successfully compiled and installed wxWindows-pgAdmin3-20031010-7 and postgresql-7.4.2. My configure error looks like other posts I have seen but the resolutions I haven't been able to match: ./configure --enable-static --enable-debug --with-pgsql=/usr/local ... checking pgsql in /usr/local... failed configure: error: you must specify a valid pgsql installation with --with-pgsql=DIR I have postgresql installed in /usr/local/pgsql. I have tried creating symbolic links to /usr/local for lib and include and bin from under /usr/local/pgsql to no avail. Any help or ideas would be appreciated. Panther 10.3.3 Try looking in the config.log that configure generates to see if you can tell why it's failing. If you can't find, try posting your config.log to the list and I will take a look at it. ahp ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [pgadmin-hackers] Mac OS X configuration
Andreas Pflug wrote: Didn't 10.3 supply wchar_t (in contrast to 10.2, which lacks it)?!? I believe that it does, but since I don't have 10.3 yet, I can't say for sure. What I can say is that the error we're talking about has to do with the lack of Unicode support compiled into wxWindows on Mac OS X. Perhaps a --with-unicode might solve the problem? ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] [pgadmin-support] SSL connections and Query
Jean-Michel POURE wrote: Le Mardi 25 Novembre 2003 22:14, Andreas Pflug a écrit : Can somebody please find out what's the difference between today's FC1 snapshot and previous crashing ones? Hopefully, we can nail this problem down to some compile/linker option. We didn't have any code change in this section for quite a while. Dear Andreas, Fantastic, we are getting close to explaining the prolem. To my knowledge, there is no difference in the RPM spec. Devrim, do you have any idea? IMHO, it should be a problem with shared libraries. Timothy, did you happen to upgrade some RPMs from Fedora when installing pgAdmin3 RC1 snapshot? Is it a difference in wxWindows versions, perhaps? ahp ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] Build errors on Fedora, latest snapshot
On Sunday, Nov 23, 2003, at 11:32 US/Eastern, Devrim GUNDUZ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I was trying to rebuild pgadmin3 package for FC1 using the srpm on snake, and I got the following error: + make all make all-recursive make[1]: Entering directory `/usr/src/redhat/BUILD/pgadmin3-1.1.0' Making all in src make[2]: Entering directory `/usr/src/redhat/BUILD/pgadmin3-1.1.0/src' cd .. \ /bin/sh /usr/src/redhat/BUILD/pgadmin3-1.1.0/config/missing --run automake-1.7 --foreign src/Makefile configure.ac:9: version mismatch. This is Automake 1.7.8, configure.ac:9: but the definition used by this AM_INIT_AUTOMAKE configure.ac:9: comes from Automake 1.7.5. You should recreate configure.ac:9: aclocal.m4 with aclocal and run automake again. Did you make any modifications to the source files before rebuilding? This happens when the configure script detects a change in the automake/autoconf files (or the source files I suppose) files, and tries to re-build them. Since configure is not distributed with the SRPM, this is the error you get. ahp PGP.sig Description: PGP signature
Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies
Dave Page wrote: No. They cannot retroactively change the licence on what we already have. I was thinking more in terms of future wxWindows snapshots. Are we going to be stuck with what we currently have, or will we be able to integrate future wxWindows code? ahp
Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies
Jean-Michel POURE wrote: Dear Devrim, Finally, I commented out the BuildRequires dependencies for wxGTK2ud in CVS. It appears that library names needed at build time are not the same under RedHat, Mandrake and SuSE. So, my 'stupid' recommended way is: rpmbuild --rebuild wxGTK2ud-2.5-.src.rpm 21 | tee wxGTK2ud-2.5-.log I realize it's a pain, but is it not possible to work the different sets of BuildRequires into the spec file, using distribution-dependent conditional statements? and read the log to make sure all needed libraries display 'sys'. Do not hesitate to send me by email the wxGTK2ud (with 'sys' libraries) and pgAdmin3 (S)RPMs and I will publish them in a new Fedora section. Do not hesitate to sign your email with OpenPGP. By the way, would you be interested in releasing daily snapshots for Fedora? We always need help... Incidentally, why are we building snapshots specifically for FC1? Is there a problem with the binary RPMs on Fedora? I have built the SRPMs with no trouble. ahp ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies
Jean-Michel POURE wrote: Yes, it is perfectly possible. But, there are so many-many build-time depencies in wxWindows. Listing them all is quite difficult. Really? Am I missing something, or would this line suffice (granted, this is the RH line, but...): BuildRequires: gtk2-devel, libjpeg-devel, libpng-devel, libtiff-devel On the other hand, the upcoming stable version of wxWindows 2.5.1 will provide a new set of RPMs. These "new" RPMs are very well designed. They include both buildtime and binary dependencies. Personaly, I think it is a waste of time to invest in the wxGTK2ud direction when a new set of RPMs is coming along. If you think the converse, do not hesitate to submit a patch and I will apply it immediately. This is free software... You are free to do what you want... So are we going to be using the official wxWindows RPMs from now on? Are we going to run into any problems since we currently use a build of wxWindows that differs from the "official" build? ahp
Re: [pgadmin-hackers] acinclude Patch
Dave Page wrote: Hi Adam, I have backed out this patch because it is breaking the Slackware build :-( Looks like we need something platform specific Yeah, I figured as much. Okay, I'll go back to the drawing board. :-) ahp ---(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] acinclude Patch
Dave Page wrote: Hi Adam, I can see what the patch does, but why? On the Mac platform, there is no libcrypt, so compilation fails if the static mode is selected. If it's not necessary to link against that library on any of our platforms, then I can take it out, instead of creating a Mac-specific LIBS string. ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] SSL detection bug is back under debian...
Raphaël Enrici wrote: Dear Adam, Jean-Michel reported to me this morning that the SSL menu was empty under debian builds. I had a quick look to the build process and it seems that we still have -I -DSSL while in the make all-recursive. The attached patch should solve this pesky SSL bug once and for all. Let me know if you have any problems with it. ahp --- pgadmin3/acinclude.m4 2003-10-09 16:40:21.0 -0400 +++ pgadmin3.new/acinclude.m4 2003-10-16 08:23:32.0 -0400 @@ -93,8 +93,6 @@ fi ]) -CPPFLAGS=$CPPFLAGS -DSSL - # # Check for libpq libraries and headers # @@ -118,6 +116,7 @@ AC_LANG_SAVE AC_LANG_C AC_CHECK_LIB(pq, PQexec, [pgsql_cv_libpq=yes], [pgsql_cv_libpq=no]) +AC_CHECK_LIB(pq, SSL_connect, [pgsql_ssl_libpq=yes], [pgsql_ssl_libpq=np]) AC_CHECK_HEADER(libpq-fe.h, [pgsql_cv_libpqfe_h=yes], [pgsql_cv_libpqfe_h=no]) AC_LANG_RESTORE if test $pgsql_cv_libpq = yes -a $pgsql_cv_libpqfe_h = yes @@ -131,6 +130,11 @@ CPPFLAGS=$PGSQL_OLD_CPPFLAGS AC_MSG_ERROR([you must specify a valid pgsql installation with --with-pgsql=DIR]) fi + +if test $pgsql_ssl_libpq = yes +then +CPPFLAGS=$CPPFLAGS -DSSL +fi fi ]) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] SSL detection bug is back under debian...
Raphaël Enrici wrote: Adam, thank you for this fast released patch. I haven't tried it for now but AFAICS it does not seem to handle the fact that WX_HOME is undef after configure on my system. I think that the real problem comes from this. In fact, SSL was correctly detected but was ignored due to the fact that WX_HOME was empty which gave the '-I -DSSL'. Do you have any idea concerning this ? I'll try your patch tonight or tomorrow. I've been looking at this -I$(WX_HOME) code for some time now, and I can't figure out why it's there, or what it is supposed to do (I mean I know ostensibly what it's supposed to do, but that's obviously not what it's doing), so I've removed it. The following patch gets rid of the offender. If anyone experiences any problems, please let me know. ahp --- pgadmin3/src/Makefile.am2003-10-06 05:49:40.0 -0400 +++ pgadmin3.new/src/Makefile.am2003-10-16 09:54:11.0 -0400 @@ -162,5 +162,5 @@ ui/tr_TR/wxstd.mo \ ui/zh_CN/wxstd.mo -AM_CXXFLAGS = -DDATA_DIR=\$(pkgdatadir)/\ -Wall -g -I$(top_srcdir)/src/include -I$(top_srcdir)/src/agent/include -I$(WX_HOME) -AM_CPPFLAGS = -DDATA_DIR=\$(pkgdatadir)/\ -Wall -g -I$(top_srcdir)/src/include -I$(top_srcdir)/src/agent/include -I$(WX_HOME) +AM_CXXFLAGS = -DDATA_DIR=\$(pkgdatadir)/\ -Wall -g -I$(top_srcdir)/src/include -I$(top_srcdir)/src/agent/include +AM_CPPFLAGS = -DDATA_DIR=\$(pkgdatadir)/\ -Wall -g -I$(top_srcdir)/src/include -I$(top_srcdir)/src/agent/include ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-hackers] acinclude Patch
Could the port maintainers please apply this patch to acinclude.m4 and let my know if anyone has any problems? This patch is against CVS HEAD, but it should apply to any recent acinclude. ahp --- pgadmin3/acinclude.m4 2003-10-09 16:40:21.0 -0400 +++ pgadmin3.new/acinclude.m4 2003-10-15 12:01:17.0 -0400 @@ -111,7 +111,7 @@ fi if test $pg_static_build = yes then -LIBS=${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lssl -lcrypto +LIBS=${LIBPQ_HOME}/lib/libpq.a $LIBS -lssl -lcrypto else LIBS=$LIBS -lssl -lcrypto -lpq fi ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] wx snapshot compile failure
The wxWindows snapshot, wxWindows-pgAdmin3-20031010.tar.bz2, currently on snake, fails to compile on Mac OS X with the following error: src/mac/textctrl.cpp: In member function `virtual void wxTextCtrl::Replace(long int, long int, const wxString)': src/mac/textctrl.cpp:1177: `st' undeclared (first use this function) src/mac/textctrl.cpp:1177: (Each undeclared identifier is reported only once for each function it appears in.) make: *** [corelib_textctrl.o] Error 1 ahp PGP.sig Description: PGP signature
Re: [pgadmin-hackers] wx snapshot compile failure
On Monday, Oct 13, 2003, at 18:45 US/Eastern, Andreas Pflug wrote: I've seen this mentioned on wx-dev today by Stephane Gully; st should be value. What's irritating me a bit is that *my* version 2003.10.10.00.00.00 (textctrl.cpp rev.1.170, cvs -D 2003-10-10 GMT ) has a line 1177 of value.Replace(wxT(\n), wxT(\r)); so it seems that our snapshot isn't exactly what I have locally. Maybe another timezone? The version of this file was changed to 1.171 on 10/10, 4:26 So do we need to create a new wxWindows snapshot? BTW, I'm wondering if you could have a look at wxWindow's main makefiles, to have contrib/src/stc and contrib/srx/xrc compiled in the main run. This would make the package a bit more fool-proof. I'm not quite sure if that works, because the contrib modules like the base to be installed before the should be made. Maybe some make complete tag that makes all in the correct row installed? This shouldn't be too difficult. Just a new target, 'complete' sounds good. ahp PGP.sig Description: PGP signature
[pgadmin-hackers] acinclude patch
This patch allows autoconf to handle the new wxWindows library naming. ahp P.S. -- Can someone confirm that the library naming has changed under cygwin (on Win32)? --- pgadmin3/acinclude.m4 2003-10-09 10:02:27.0 -0400 +++ pgadmin3.new/acinclude.m4 2003-10-09 10:02:15.0 -0400 @@ -243,38 +243,74 @@ LIBS=$LIBS ${WX_HOME}/lib/libwx_macud_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_macud_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_macud_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_macud_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_macud_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_macd-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_macd_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_macd_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_macd_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_macd_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_macd_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_mac-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_mac_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_mac_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_mac_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_mac_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_mac_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_gtk2ud-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk2ud_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk2ud_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_gtk2ud_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk2ud_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk2ud_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_gtk2d-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk2d_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk2d_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_gtk2d_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk2d_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk2d_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_gtk2u-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk2u_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk2u_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_gtk2u_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk2u_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk2u_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_gtkud-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_gtkud_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtkud_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_gtkud_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_gtkud_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtkud_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_gtkd-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_gtkd_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtkd_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_gtkd_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_gtkd_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtkd_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *libwx_gtk-*) LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk_xrc-${WX_VERSION}.a LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*libwx_gtk_core*) +LIBS=$LIBS ${WX_HOME}/lib/libwx_gtk_stc-${WX_VERSION}.a ${WX_HOME}/lib/libwx_gtk_xrc-${WX_VERSION}.a +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *) ;; esac @@ -304,38 +340,74 @@ LIBS=$LIBS -lwx_macud_stc-${WX_VERSION} -lwx_macud_xrc-${WX_VERSION} LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*wx_macud_core*) +LIBS=$LIBS -lwx_macud_stc-${WX_VERSION} -lwx_macud_xrc-${WX_VERSION} +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *wx_macd-*) LIBS=$LIBS -lwx_macd_stc-${WX_VERSION} -lwx_macd_xrc-${WX_VERSION} LIBS=$LIBS $WX_NEW_LDFLAGS ;; +*wx_macd_core*) +LIBS=$LIBS -lwx_macd_stc-${WX_VERSION} -lwx_macd_xrc-${WX_VERSION} +LIBS=$LIBS $WX_NEW_LDFLAGS +;; *wx_mac-*) LIBS=$LIBS
Re: [pgadmin-hackers] CVS compile error
Stefan Csomor wrote: Hi it is not really difficult but if you don't know the MacOS Unicode calls it's getting tiresome, I will try to make an assessment of the trouble involved in solving this for 10.2 by next week, I see we need it... Thanks, Stefan, we really appreciate your continuing support. Let me know if there is anything I can do to help you. ahp ---(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] Update
Dave Page wrote: It would be cool if there were a generic mechanism we could use to write the version number into scripts 'n' stuff at configure time. The would certainly make my life easier with various build scripts. By "write them into scripts" what do you mean? Can you provide an example of what you would like to see? ahp
[pgadmin-hackers] CVS compile error
I still get this compile error, on Mac, with the CVS HEAD from both pgadmin3 and wxWindows: utils/utffile.cpp: In member function `off_t wxUtfFile::Read(wxString, long long int)': utils/utffile.cpp:85: no matching function for call to `wxMBConv::MB2WC( wxStringBuffer, char*, long unsigned int)' /usr/local/wx2/include/wx/strconv.h:46: candidates are: virtual size_t wxMBConv::MB2WC(wchar_t*, const char*, long unsigned int) const ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-hackers] Update
Hello everyone! I've been out of town for the weekend, so I wasn't able to work on any pgAdmin stuff while I was gone. I'm going to get back into it, so I wanted to make sure that I've got everything on my to-do list: *) Fix -DSSL compilation problem *) Make static build more static *) Fix J-M's xpm include problem *) RH 7.3 SRPM building *) Mac OS X port Did I miss anything? ahp ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] gcc ignoring defined macros?
Dave Page wrote: Ah-ha!! Right, I editted the line in src/Makefile that compiles frmConnect.cpp. I added -DSSL so the final command read: if g++ -DSSL -DHAVE_CONFIG_H -I. And that works. :-) Further investigation of the command line: if g++ -DHAVE_CONFIG_H -I. -I. -I.. -DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -I -DSSL -I/usr/local/pgsql/include -I/usr/local/lib/wx/include/gtk2ud-2.5 -D__WXDEBUG__ -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -I/usr/local/include -DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -I -g -O2 -MT frmConnect.o -MD -MP -MF ".deps/frmConnect.Tpo" \ -c -o frmConnect.o `test -f 'ui/frmConnect.cpp' || echo './'`ui/frmConnect.cpp; \ then mv ".deps/frmConnect.Tpo" ".deps/frmConnect.Po"; \ else rm -f ".deps/frmConnect.Tpo"; exit 1; \ fi shows up the problem. Firstly, a bunch of it seems to be included twice. Note the double inclusion of: -DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -I Then secondly, notice the -I on the end which does not have a path - that's what seems to be losing the SSL definition because it gets picked up as the argument to -I. Further investigation shows that that path is set to ${WXHOME} which is ovbviously empty when the command is created. Adding a / to the end of it makes things work nicely. Not sure about the best way to fix this properly, so I guess it's over to you Adam :-) Regards, Dave. I was about to fix this, when I realized that I was about to add -DSSL to the command-line for *all* situations. Is this what we want, or is this supposed to be a conditional compile option? If it's needed for *all* situations, then why included it at all, why not just remove the #ifdefs and always compile the SSL code? ahp
[pgadmin-hackers] CVS compile error
ui/ctlSQLResult.cpp: In member function `int ctlSQLResult::Execute(const wxString, int)': ui/ctlSQLResult.cpp:53: error: no matching function for call to `pgQueryThread ::pgQueryThread(pgConn*, const wxString, int)' ../src/include/pgSet.h:89: error: candidates are: pgQueryThread::pgQueryThread(const pgQueryThread) ../src/include/pgSet.h:91: error: pgQueryThread::pgQueryThread(PGconn*, const wxString, int) make[2]: *** [ctlSQLResult.o] Error 1 ahp ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] wxWindows Upgrade
Dave Page wrote: -Original Message- From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] Sent: 03 October 2003 08:31 To: Dave Page Cc: pgadmin-hackers Subject: Re: [pgadmin-hackers] wxWindows Upgrade Le Jeudi 2 Octobre 2003 16:28, Dave Page a crit : Add --enable-monolithic when you configure it to get the old single library. Thanks for the information. wxGTK 2.5.1 will be released this week-end. Therefore, it is high time I compile the official RPMs (which are not monolithic) today and hand them to the wxWindows team. OK. If you want something to do, perhaps you could look into what's required to get pgAdmin to build with a non-monolithic wx? I'm guessing it's just an appropriate patch to /acinclude.m4 Yes, just a patch to acinclude. I will take care of this one while I am fixing the -DSSL bug. ahp
Re: [pgadmin-hackers] [pgadmin-support] Bug in pgadmin III displaying/exporting dat
Andreas Pflug wrote: Godshall Michael wrote: I use linux at home and would test it there if I can get pgadminIII installed on it. Last time I tried it failed because I did not have ssl and crypto so.4 libraries. My Redhat 8.0 box has versions so.2. Maybe I downloaded the wrong version of pgadminIII. Adam, can't we link ssl and crypto static too? Alternatively, we'd have to distribute non-SSL versions too.. I'm not sure I follow. ahp ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] [pgadmin-support] Bug in pgadmin III displaying/exporting
Andreas Pflug wrote: Hi Adam, obviously the Redhat binary distribution needs dynamically linked libcrypto and libssl. IMHO we should spend the additional 10kb and have both libs statically linked to pgAdmin3, to avoid these dependencies. Or did Jean-Michel just forget to use --enable-static when building? AFAIR we confirmed that by default dynamic linking should be used, while our binary distributions should be as static as possible to minimize dependencies. Okay, I will take a look at this again and see if the --disable-shared flag can statically link as much as possible. ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] CVS compile error
Dave Page wrote: -Original Message- From: Adam H.Pendleton [mailto:[EMAIL PROTECTED]] Sent: 02 October 2003 23:32 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] CVS compile error I get this when compiling a fresh CVS tree: utils/utffile.cpp: In member function `off_t wxUtfFile::Read(wxString, long long int)': utils/utffile.cpp:85: no matching function for call to `wxMBConv::MB2WC( wxStringBuffer, char*, long unsigned int)' /usr/local/wx2/include/wx/strconv.h:46: candidates are: virtual size_t wxMBConv::MB2WC(wchar_t*, const char*, long unsigned int) const make[2]: *** [utffile.o] Error 1 make[2]: *** Waiting for unfinished jobs make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 You need the 20031001 wx snapshot from the wxWindows site. Currently we haven't patched it. Regards, Dave. Does this mean that the CVS head from wxWindows doesn't work? ahp
Re: [pgadmin-hackers] pgAdmin III under wxCocoa
Adam Witney wrote: Not much really: configure:4824: checking for wxWindows configure:4841: result: yes configure:5061: error: you need to install the xrc package from wxWindows/contrib/src/xrc There is only one check for the xrc package, and that is for the prescense of ${WX_HOME}/include/wx/xrc/xmlres.h, where ${WX_HOME} is the directory wxWindows is installed under (--prefix or /usr/local/wx2). Check to see that this file exists on your machine. If not, could you print a directory listing of that directory? autoconf (GNU Autoconf) 2.57 automake (GNU automake) 1.6.1 What should they be? automake (GNU automake) 1.7.7 I don't remember exactly when automake dropped the AM_ vs. AC_ requirement, but it was definitely in a later version than 1.6.1. ahp
Re: [pgadmin-hackers] gcc ignoring defined macros?
On Thursday, Oct 2, 2003, at 10:08 US/Eastern, Dave Page wrote: Hi Adam, Tried that in frmConnect, and the SSL combo box is correctly populated, so the preprocessor is working, just not seeing the externally defined macros. by the sound of it. Regards, Dave. How are you adding the -DSSL flag to the command line? It might be mistaken for a linker flag because of its location in the args. Just a shot in the dark, really... ahp ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [pgadmin-hackers] pgAdmin III under wxCocoa
Dave Page wrote: Dynamic build works, static does not. Incidently, --disable-static doesn't work, despite prompts indicating that it should. I also note that snake is linking with libwx_gtk2ud-2.5.a no matter what build type is performed - I assume this is because that's what wx-config tells it to do? Most likely. The output from 'wx-config --libs' and 'wx-config --libs --static' seem the same, and seems to be dependent on the wxWindows build. ahp ---(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] Mac Port
Jean-Michel POURE wrote: Nice Macintosh. Is this a new platform? How wide is your screen? Sorry for the late reply because of the jet lag :) It's a PowerBook G4 15 running Mac OS X 10.2.6. The language list is displayed in UTF-8 because our translations are stored in Unicode. wxMac does not support Unicode and hence fails to display some languages. If you compile pgAdmin3 without Unicode, you should be able to view pgAdmin3 English interface. Most European languages should display (with accent problems). Because Unicode is based on ASCII characters, it should not break pgAdmin logic. Could Andreas confirm? The problem isn't the language display, per se, but rather that I can't click on the dialog, there is no dock icon, etc. It's because I forgot to link against the Mac resource files. I will work on it some more tonight. ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] make install icons and desktop files
Jean-Michel POURE wrote: Dear Adam H., In the RPM spec, after make install, we install the icon and desktop file manually using: cp ./src/include/images/elephant48.xpm %{buildroot}/%{_datadir}/%{name}/%{name}.xpm cp ./pkg/%{name}.desktop %{buildroot}/%{_datadir}/%{name}/%{name}.desktop Could it be part of make install itself? Yes. I've have to get back to you on specifically how, though. :-) ahp ---(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] MacOSX compilation steps
Jean-Michel POURE wrote: Dear Friends, I added information about wxWindows compilation under MacOsX on http://www.pgadmin.org/pgadmin3/download.php#source. It will take some time to replicate from snake development server. Dear Adam H.: could you describe the needed steps for pgAdmin3 compilation? Is it the same as under GNU/Linux? Cheers, Jean-Michel I will post my steps for compiling wxWindows and pgAdmin3 to the list tonight. It is very similar to Linux, but not quite the same. There is, at a minumum, one additional step required. ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] GPL code issue?
Dave Page wrote: /* A Bison parser, made by GNU Bison 1.875. */ Given that this file appears to be produced *by* Bison, and given this exception: /* As a special exception, when this file is copied by Bison into a Bison output file, you may use that output file without restriction. This special exception was added by the Free Software Foundation in version 1.24 of Bison. */ it would appear that the file can be used without restriction. Any output from bison or flex is non-GPL, AIUI. Any input *into* bison, which is GPL'd before processing, *is* restricted. Given that bison doesn't take .h files as input, doesn't it make sense that this was produced *by* bison, and thus unrestricted? ahp ---(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
[pgadmin-hackers] wxWindows lib name changes
I just grabbed the CVS tree for wxWindows, and I noticed that the library naming convention seems to have changed. Where it used to be -lwx_macd-2.5 it is now -lwx_macd_core-2.5, etc. This causes the autoconf code to fail, since it is looking for wx_macd- not wx_macd_. Can anyone else confirm that this change takes place on other platforms (I realize we don't use the CVS tree for our builds, but it may be necessary for Mac support). ahp PGP.sig Description: PGP signature
Re: [pgadmin-hackers] pgAdmin III under wxCocoa
On Tuesday, Sep 30, 2003, at 05:40 US/Eastern, Adam Witney wrote: And the relevant part of config.log says configure:4634: gcc -o conftest -Wall -g -O0 -DSSL -I/usr/local/pgsql/include -L/usr/local/pgsql/lib conftest.c -lpq /usr/local/pgsql/l ib/libpq.a -lcrypt -lssl -lcrypto 5 ld: can't locate file for: -lcrypt configure:4637: $? = 1 configure: failed program was: | #line 4610 configure I don't think this part is a problem with the wxWindows part is it? No, this is a problem with the autoconf code. Mac OS X doesn't have a libcrypt, at least not by default. I'll need to modify the code so that we don't link against it. Let me take a look at it. ahp PGP.sig Description: PGP signature
[pgadmin-hackers] acinclude.m4.patch
This is a small patch that changes the file we check for to validate a wxWindows xrc installation (this file is not installed on Mac). Before applying, could someone verify that this file is installed on all autoconf platforms? ahp acinclude.m4.patch Description: Binary data PGP.sig Description: PGP signature
Re: [pgadmin-hackers] [ANNOUNCE] pgAdmin III v1.0.0 Released
Jean-Michel POURE wrote: 1) Compile pgAdmin3 in non-unicode mode. In which case, pgAdmin3 port would be unable to display non-european languages and query PostgreSQL Unicode databases. 2) Use the iconv library linked against wxWindows in order to bring a Unicode abstraction layer to wxWindows. Julian, I had this idea in my sleep, is this a workable solution? 3) Wait for MacOsX 10.3 which should be Unicode compliant. We already discussed this opportunity, which does not fit our ideas because it would require MacOsX users to upgrade. 4) Use donated proprietary compilers in order to compile pgAdmin3 under MacOsX. My opinion is not to use proprietary software, but other members in the team are not agains this idea. This needs to be dicussed. 5) Compile pgAdmin as a fink package (http://www.fink.org). Maybe too complicated for MacOsX users. Could we discuss these opportunities? My opinion would be to go for 2), 1) and 4) and 5) in order of preference. What is the opinion of other members and contributors? I like this order as well (with one caveat), although I think that #5 is unnecessary. Whatever method we use for compiling pgAdmin3, distribution will almost certainly be done as in binary form, so there will be no need to involve fink, which AIUI, is largely for compiling ported packages for Mac OS X. My caveat to the above order is that item #3, assuming we have no problem with the compiler, should be #1, since it offers us the oppurtunity to have a Unicode pgAdmin3 on Mac OS X. If there are philosophical problems with #3, then let's compile a non-unicode version, at least to get something to beta test. There's a pretty good chance that we're going to have bugs in the Mac version, since the last time I had pgAdmin3 running on the Mac, it crashed on startup. As soon as we decide which direction we want to go, I can contribute however much time is neccessary to get the port to work. ahp ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] pgAdmin3 port to MacOsX
Jean-Michel POURE wrote: Dear Friends, What does Stefan think of the Fink project? Does it make sense to produce wxGTK2ud snapshots for Fink and compile pgAdmin3 with GTK2 bindings. I don't think we can reasonably expect Mac users of pgAdmin to install and use GTK libraries just for this one application. ahp
Re: [pgadmin-hackers] [pgadmin-support] problem installing pgAdmin 3 on red hat 7.3
pginfo wrote: Hi Ivan, I quite agree, a Redhat 7.3 binary would be useful - the problem is that none of the developers have such a machine to build it on that I'm aware of. Any volunteers out there with a sutable machine? Regards, Dave. I can certainly come up with a RedHat 7.3 machine. I'll have to look around for some hardware, but I'm pretty sure I can get one up today or tomorrow. ahp ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] pgAdmin3 port to MacOsX
On Sunday, Sep 14, 2003, at 12:41 US/Eastern, Stefan Csomor wrote: Hi basically we have two options : I have implemented unicode for wxMac a few weeks ago with one restriction : for 10.2 we need the Metrowerks Compiler environement, since their C-runtime supports wchar, whereas Apple's Dev Tools don't , rewriting wxMac to use apple's own unicode support at the moment for me is out of the question due to time constraints for 10.3 we can work with the apple developer tools So I guess it would be the easiest way to go for 10.3 only... Hmmm. Well, I don't have the Metrowerks compiler, but I could probably get my hands on it if I needed to. I am not using Mac OS X 10.3, but I probably could if I needed to (though I don't know how this would help us). What is needed to get wxMac to support Apple's Unicode on 10.2? Is there anything I can do to help? I've got the time, but I don't know the particulars about what would need to be done. I don't think that supporting 10.3 only is a good idea, only because 10.3 is still in beta, and would be just a useful as producing no Mac port at all. OTOH, I can take a look at getting a Metrowerks compiler to produce binary snapshots. Dave, what do you think? ahp PGP.sig Description: PGP signature
Re: [pgadmin-hackers] autoconf compiling *.c
Andreas Pflug wrote: Adam, there's a new patch for acinclude.m4 statinc search for PostgreSQL includes in /usr/include and usr/include/pgsql is this supposed to fix this topic? It doesn't; try adding db/keywords.c to Makefile.am yourself. The files that keywords.c is missing are *not* to be used from a PostgreSQL installation, but should be found in our pgAdmin include directory. Some of the files needed are indeed original PostgreSQL backend files, and some are new pgAdmin versions. Regards, Andreas No, this patch is for a different issue. I am still working on yours. ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] autoconf compiling *.c
Attached is a patch to src/Makefile.am that fixes your problems. ahp --- pgadmin3/src/Makefile.am2003-09-12 11:11:04.0 -0400 +++ pgadmin3.new/src/Makefile.am2003-09-12 11:04:50.0 -0400 @@ -8,7 +8,7 @@ # db/keywords.c needs to be added pgadmin3_SOURCES = pgAdmin3.cpp \ -db/pgConn.cpp db/pgSet.cpp \ +db/pgConn.cpp db/pgSet.cpp db/keywords.c \ schema/pgAggregate.cpp schema/pgCast.cpp \ schema/pgCheck.cpp schema/pgCollection.cpp \ schema/pgColumn.cpp schema/pgConstraints.cpp \ @@ -188,3 +188,4 @@ ui/zh_CN/wxstd.mo AM_CXXFLAGS = -DDATA_DIR=\$(pkgdatadir)/\ -Wall -g -I$(top_srcdir)/src/include -I$(WX_HOME) +AM_CPPFLAGS = -DDATA_DIR=\$(pkgdatadir)/\ -Wall -g -I$(top_srcdir)/src/include -I$(WX_HOME) ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] pgAdmin3 icon under RPM platform
Dave Page wrote: Any objections to me moving it? No objections here. ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] autoconf compiling *.c
Andreas Pflug wrote: Hi Adam, for support of keyword checking, we need to include keywords.c. I added this to makefile.am, but the compile flags will lacke the including of the main include dir (../src/include in my build). While we have agreed not to activate this for the 1.0 release, we'll need this quite soon. Please have a look where to add the options so we can compile *.c successfully. Regards, Andreas I'm not sure I quite understand; what happens when you add db/keywords.c to Makefile.am, run bootstrap, re-run configure, and re-compile? ahp ---(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] SSL option
Andreas Pflug wrote: Hi Adam, I've been reviewing SSL code in pgAdmin3 and libpq7.4 for win32 (and got it running with several patches). I added a compile time option to reflect SSL availability, it needs the compile time flag -DSSL, which I added to acinclude.m4. We should have this configurable, in case a libpq is compiled without openssl (without -lssl and -lcrypto). Best way would be if it was possible to examine libpq if it's ssl enabled or not(compiled with USE_SSL), I don't know if this is possible. Otherwise, we'd need --with-openssl. I'll take a look at libpq today and see if there is any way to determine its build flags. Otherwise I will add a --with-openssl option. ahp ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] Smallint
Am I missing something obvious, or is the SMALLINT datatype missing from the appliation (add column on Columns tab of database property sheet)? ahp ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] Smallint
Duh! Obviously it's not, it's just that pgAdmin3 calls it an int2? Any reason not to call it a smallint, since that's they way it's referred to in the documentation? ahp ---(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] Some remarks to pgadmin III
Andreas Pflug wrote: Claus Helbing wrote: Andreas Pflug wrote: Data is NOT held in the grid, but on the server, and only retrieved when requested, so sorting would require a re-query. Hmm ... you are the developper ... but since I can scroll up and down ... I guess the data is on the client somewhere? Also the button refresh and the status line Refreshing data, please wait indicate that data is tranfered to the client. Since it is on the client (in a grid or another datastructure) couldn't it just be sorted localy ? It is done on the server, and only rows needed are transferred on demand to the client. There's only a cache on the client side. Believe me, no chance to sort! I assume when you say that sorting the rows would require a re-query, you are referring to a new SQL statement with a ORDER BY clause. I think what he's asking for is perfectly do-able without a new query. Since the rows are stored in a grid control of some sort, then you should be able to sort the rows using the function of that grid control itself. This sort would have *no* impact on the actual data, where it is in the database, etc. I would imagine that this sort of this would be possible only if the wxWindows control used to display the data supported it. I will do some reasearch and see if it can be done. Query Tool: No Ctrl-A ... (Ctrl-.Shift-End works) Andreas is right about this one. Ctrl-A (select all text) is only going to work if wxWindows supports it. Really it should be a function of the control/widget that the text boxes are natively implemented in (comctrl32.dll on win), so I see no reason that it shouldn't work. Again, I will do some reasearch and see what I can dig up. ahp ---(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] Some remarks to pgadmin III
Andreas Pflug wrote: You maybe use it in the main edit field, but certainly not in any simple text field! This would be needed to be implemented deep in wxWindows anyway. BTW, mozilla doesn't support this even in the compose window; Ctrl-A is emacs-like beginning-of-line Actually, this behaviour (that is selecting all the text in the current window/field) *is* supported by Mozilla, on ALL platforms, including Linux, Mac, and Windows. On Linux, the key sequence is Alt-A. Mac Command-A. Win Ctrl-A. ahp ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] Some remarks to pgadmin III
Dave Page wrote: Ctrl-A is standard as far as I am aware - I use it all the time in numerous apps. I'll chime in and agree here on Ctrl-A, especially since the same behaviour is supported on Mac with Apple-A. ahp
Re: [pgadmin-hackers] Some remarks to pgadmin III
Andreas Pflug wrote: Adam, I believe it's time you have a look at the source what's really going on there. The grid doesn't have control over the data, it's pgadmin3 managing it. Yeah, that's a good idea. :-) Not today, though, my head hurts. Besides, I don't really want to be able to sort the data, I just just trying to help claudius. :) Minimize/Maximize is implemented by GDI and gtk, Select All is not. You want to change the Win API? Good luck BTW, Alt-A is quite a bad idea, Alt keys should be left free for application shortcuts, not used by controls. Okay, as much as I hate to admit it, I was wrong. It looks like (at least as far as wxWindows is concerned) if we want to support Ctrl-A, we would have to implement it ourself. It shouldn't be too hard, though, the question would be: *) What key sequence(s) are we going to support? *) What does Ctrl-A (or whatever) mean depending on what window/box/control is selected. A Ctrl-A in the tree view would be very different from a Ctrl-A in the SQL pane. Do we want to do this, if so, what are the answers to the above questions. ahp ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] Bug in 0.9.1
If I right-click a table and change a security setting (using the show users for privileges option), and that table has a foreign key constraint, when trying to update the table, I get this error: ERROR: parser: parse error at or near CONSTRAINT at character 2 On the SQL tab of the properties dialog, it reads: CONSTRAINT $1 $1 FOREIGN KEY where it should read: CONSTRAINT $1 FOREIGN KEY which it does in the SQL pane when I select the table using the left mouse button. ahp ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] pga3 website
Dave Page wrote: Were they? :-( I thought Adam bundled them in with one of his updates after reviewing them. Please send them again and I will make sure they get applied. I didn't mean to ignore them:-) At the time I release my last acinclude patch, I didn't include the mingw patch because, the last that I heard, even *with* the patches it wasn't possible to get pgadmin3 to compile under mingw. I didn't think it should be included until we were sure it was going to work. If that's the case, then by all means, let's include it. Dave, if you want me to submit another patch I can do it tonight, since I'll be working on the Mac buld then. ahp
Re: [pgadmin-hackers] pga3 Beta 1 Release
Dave Page wrote: Under that directory are currently src, win32 and slackware9 directories. Could all packagers please create a suitable directory for their OS, and upload binaries as soon as possible (please use the src tarball for consistancy, though I have tagged CVS with REL-0_9_0 as well). I would love to do this for the Mac platform, but I don't have a clue about how to do it. :-) Assuming that I get the Mac port to built tonight (wxWindows now builds on Mac), do you want to release Mac binaries? ahp ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] acinclude.m4_patch
Hiroshi Saito wrote: Hi Andreas. Adam is busy.? If so,want you to check it. I want to solve this before the beta distribution. (There was a part of the mistake in the last patch stealthily) Is there a problem in this with linux? --Jean-Michel This modification is very important with FreeBSD. Regards, Hiroshi-Saito This patch looks fine. ahp ---(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] patch for the tips.txt translation.
On Friday, Jul 18, 2003, at 16:32 US/Eastern, Dave Page wrote: Hi Hiroshi, I've committed a different version of you code that falls back to en_US if the localised file cannot be found. It also errors out nicely if the English version cannot be found. The tips.txt file itself now lives in /docs/xx_XX/. I have updated makefiles etc, and build scripts where required. Wouldn't translation of the tips be easier if we used embedded tips rather than loading them from a file? Then, rather than maintaining a separate tips.txt for each locale, we could include the tip strings in the .po file for each language. ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Trouble with wxWindows (XRC and STC linking
Dave Page wrote: That's how we usually do compile wx so we wouldn't have noticed. Adam, can you fix this in the patch you were preparing please? Regards, Dave. Sure, but it won't be until the weekend. Should still meet the 21st deadline. BTW, do we have a plan to get beta testers? ahp
Re: [pgadmin-hackers] Trouble with wxWindows (XRC and STC linking
This new acinclude.m4 file looks fine to me. I'm going to submit a cleaner version later this week, but the functionality of the two will be the same. ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-hackers] make distcheck
I never got an update on whether my patch fixed the make distcheck for everyone. ahp ---(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
[pgadmin-hackers] executable_name.patch
Fixes autoconf to produce lowercase executable name. Please apply. ahp diff -urN pgadmin3/configure.ac pgadmin3.new/configure.ac --- pgadmin3/configure.ac 2003-06-27 10:55:56.0 -0400 +++ pgadmin3.new/configure.ac 2003-07-07 10:55:29.0 -0400 @@ -1,7 +1,7 @@ AC_PREREQ(2.57) AC_REVISION($Revision: 1.12 $) AC_COPYRIGHT(Copyright 2002 - 2003 The pgAdmin3 Development Team) -AC_INIT(pgAdmin3, 0.1.1, [EMAIL PROTECTED], pgadmin3) +AC_INIT(pgadmin3, 0.1.1, [EMAIL PROTECTED]) AC_CONFIG_AUX_DIR(config) AC_CONFIG_SRCDIR([src/pgAdmin3.cpp]) AC_CONFIG_HEADER([config.h]) diff -urN pgadmin3/src/Makefile.am pgadmin3.new/src/Makefile.am --- pgadmin3/src/Makefile.am2003-07-07 05:10:08.0 -0400 +++ pgadmin3.new/src/Makefile.am2003-07-07 10:58:28.0 -0400 @@ -3,9 +3,9 @@ # This software is released under the Artistic Licence # # Makefile - Makefile for *nix systems -bin_PROGRAMS = pgAdmin3 +bin_PROGRAMS = pgadmin3 -pgAdmin3_SOURCES = pgAdmin3.cpp db/pgConn.cpp db/pgSet.cpp \ +pgadmin3_SOURCES = pgAdmin3.cpp db/pgConn.cpp db/pgSet.cpp \ schema/pgAggregate.cpp schema/pgCast.cpp \ schema/pgCheck.cpp schema/pgCollection.cpp \ schema/pgColumn.cpp schema/pgConstraints.cpp \ ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] Fixed Makefile.am.patch
Hmmm, it worked for me, but I set it back to the old way. ahp Makefile.am.patch Description: Binary data ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [pgadmin-hackers] make distcheck
On Thursday, Jul 3, 2003, at 17:37 US/Eastern, Dave Page wrote: Hi Adam, Just tried make dist and make distcheck following our earlier emails. make dist works fine as I thought (we use it in build-snapshot anyway), however make distcheck fails as below. cd'ing into the test build directory and running make from there works fine, so I guess it's a simple problem caused by building from one directory above. More or less. The problem has to do with the way I pass the pgadmin3/src/include directory to the compiler. I will re-work this and submit a patch. ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] [pgadmin-support] copy paste ?
Dave Page wrote: Hi John, The major part of the problem is that copy/paste is handled by the window manager not pgAdmin, so it's quite difficult for us to fix. Jean-Michel has tested on the same platform as you (Kde 3/Redhat 9 iirc), and it works fine for him, so it's presumably something specific to your configuration. Anyone on -hackers have any ideas? My first question would be what exactly is the method he is using for cutting/pasting? There are esentially two ways to copy/paste, one done largely by X and the other done by the window manager. The first involves highlighting the text to copy, then using the middle mouse button to paste. The other involves the Edit-Copy menu item. Which method is he using? ahp
Re: [pgadmin-hackers] COMMENT ON FUNCTION
Darko Prenosil wrote: When function has arguments, for example : foo(varchar,int) extracted metadata from pgadmin is: COMMENT ON FUNCTION foo IS 'Comment'; which is wrong, it shoul'd be : COMMENT ON FUNCTION foo(varchar,int) IS 'Comment'; Regards ! ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] I thought I'd take a crack at this one, and pretend to be a real developer for a moment. Here is a patch. ahp --- pgadmin3/src/ui/dlgFunction.cpp 2003-06-20 05:26:57.0 -0400 +++ pgadmin3.new/src/ui/dlgFunction.cpp 2003-07-02 13:11:20.0 -0400 @@ -381,6 +381,7 @@ || (!function !comment.IsEmpty())) { sql += wxT(COMMENT ON FUNCTION ) + name ++ wxT(() + GetArgs(true) + wxT()) + wxT( IS ) + qtString(comment) + wxT(;\n); } ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] Todo item
I noticed the todo list has an item about supporting 'make dist'. What's the deal with this? I thought we had this taken care of a while ago? What doesn't work, specifically? ahp ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] COMMENT ON FUNCTION
Andreas Pflug wrote: dlgFunction.cpp is ok (name already contains the arguments), the problem was in pgFunction.cpp... Fixed and commited. Damn!! ahp ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] Analyze only support
Here is a patch that enable analyze only support. For the time being (unless there are objections), this feature is manifested as another check box on the Vacuum dialog, which says Analyze only (don't vacuum). This will perform a ANALYZE ... instead of a VACUUM ANALYZE There is also a small bug fix in this patch, in that since analzye doesn't return any data, there is no thread-DataSet() created, so a call to thread-DataSet()-NumRows() when thread-DataSet() == NULL will cause a segfault. If this patch is acceptable to everyone (read Andreas...:-P), then please apply. ahp diff -ur pgadmin3/src/ui/common/frmVacuum.xrc pgadmin3.new/src/ui/common/frmVacuum.xrc --- pgadmin3/src/ui/common/frmVacuum.xrc2003-05-02 11:34:37.0 -0400 +++ pgadmin3.new/src/ui/common/frmVacuum.xrc2003-07-02 14:46:02.0 -0400 @@ -2,12 +2,12 @@ resource object class=wxDialog name=frmVacuum titleVACUUM an object/title -size300, 190/size +size300, 210/size stylewxSTAY_ON_TOP|wxCAPTION|wxSYSTEM_MENU/style object class=wxStaticBox name=stbBox labelVACUUM options/label pos10,10/pos - size280,85/size + size280,105/size /object object class=wxCheckBox name=chkFull labelFull/label @@ -22,22 +22,26 @@ checked1/checked pos35, 70/pos /object +object class=wxCheckBox name=chkAnalyzeOnly +labelAnalyze only (don't vacuum)/label +pos75, 90/pos +/object object class=wxStaticBitmap name=stBitmap bitmap stock_id=wxART_MISSING_IMAGE/bitmap - pos100,100/pos + pos100,110/pos size64,64/size /object object class=wxButton name=btnOK labelamp;OK/label default1/default - pos130, 160/pos + pos130, 180/pos size80, 25/size /object object class=wxButton name=btnCancel labelamp;Cancel/label default0/default - pos215, 160/pos + pos215, 180/pos size80, 25/size /object /object -/resource \ No newline at end of file +/resource diff -ur pgadmin3/src/ui/frmVacuum.cpp pgadmin3.new/src/ui/frmVacuum.cpp --- pgadmin3/src/ui/frmVacuum.cpp 2003-06-17 10:00:20.0 -0400 +++ pgadmin3.new/src/ui/frmVacuum.cpp 2003-07-02 15:01:30.0 -0400 @@ -29,12 +29,13 @@ EVT_CLOSE( frmVacuum::OnClose) END_EVENT_TABLE() -#define chkFull CTRL(chkFull, wxCheckBox) -#define chkFreeze CTRL(chkFreeze, wxCheckBox) -#define chkAnalyze CTRL(chkAnalyze, wxCheckBox) -#define stBitmapCTRL(stBitmap, wxStaticBitmap) -#define btnOK CTRL(btnOK, wxButton) -#define btnCancel CTRL(btnCancel, wxButton) +#define chkFull CTRL(chkFull, wxCheckBox) +#define chkFreeze CTRL(chkFreeze, wxCheckBox) +#define chkAnalyze CTRL(chkAnalyze, wxCheckBox) +#define chkAnalyzeOnly CTRL(chkAnalyzeOnly, wxCheckBox) +#define stBitmapCTRL(stBitmap, wxStaticBitmap) +#define btnOK CTRL(btnOK, wxButton) +#define btnCancel CTRL(btnCancel, wxButton) @@ -86,14 +87,20 @@ { btnOK-Disable(); -wxString sql=wxT(VACUUM ); +wxString sql; +if (chkAnalyzeOnly-GetValue()) +sql = wxT(ANALYZE ); +else +{ +sql=wxT(VACUUM ); -if (chkFull-GetValue()) -sql += wxT(FULL ); -if (chkFreeze-GetValue()) -sql += wxT(FREEZE ); -if (chkAnalyze-GetValue()) -sql += wxT(ANALYZE ); +if (chkFull-GetValue()) +sql += wxT(FULL ); +if (chkFreeze-GetValue()) +sql += wxT(FREEZE ); +if (chkAnalyze-GetValue()) +sql += wxT(ANALYZE ); +} if (object-GetType() != PG_DATABASE) sql += object-GetTypeName() + wxT( ) @@ -115,6 +122,8 @@ // here could be the animation } +if (thread-DataSet() != NULL) +wxLogDebug(wxString::Format(_(%d rows.), thread-DataSet()-NumRows())); if (thread) { btnOK-SetLabel(_(Done)); ---(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] [pgadmin-support] CVS
John Bercik wrote: [EMAIL PROTECTED] lib]# ls -l total 7192 lrwxrwxrwx1 root root 24 Jul 2 09:40 libwx_gtk2u-2.5.so - libwx_gtk2u-2.5.so.0.0.0 lrwxrwxrwx1 root root 24 Jul 2 09:40 libwx_gtk2u-2.5.so.0 - libwx_gtk2u-2.5.so.0.0.0 -rwxr-xr-x1 root root 6087805 Jul 2 09:40 libwx_gtk2u-2.5.so.0.0.0 lrwxrwxrwx1 root root 28 Jul 2 14:43 libwx_gtk2u_stc-2.5.so - libwx_gtk2u_stc-2.5.so.0.0.0 lrwxrwxrwx1 root root 28 Jul 2 14:43 libwx_gtk2u_stc-2.5.so.0 - libwx_gtk2u_stc-2.5.so.0.0.0 -rwxr-xr-x1 root root 701402 Jul 2 14:43 libwx_gtk2u_stc-2.5.so.0.0.0 lrwxrwxrwx1 root root 28 Jul 2 14:43 libwx_gtk2u_xrc-2.5.so - libwx_gtk2u_xrc-2.5.so.0.0.0 lrwxrwxrwx1 root root 28 Jul 2 14:43 libwx_gtk2u_xrc-2.5.so.0 - libwx_gtk2u_xrc-2.5.so.0.0.0 -rwxr-xr-x1 root root 541570 Jul 2 14:43 libwx_gtk2u_xrc-2.5.so.0.0.0 drwxr-xr-x3 root root 4096 Jul 2 09:40 wx [EMAIL PROTECTED] lib]# Right, okay. So here you need to add /usr/local/wx2/lib to your LD_LIBRARY_PATH. You can do this by manipulating /etc/ld.so.conf and then running ldconfig, or you can simply: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/wx2/lib before you run pgAdmin3. Try this second method first, to make sure this solves the problem, the you can can add /usr/local/wx2/lib to your /etc/ld.so.conf, then run ldconfig(8). ahp ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] Edit Data dialog
When using the edit data dialog, there should be a way to add a new row to a table with no data. Right now, I can edit the data of an empty table, enter my data, but then there doesn't seem to be any way for me to add the data. Also, when using the edit data dialog, a column named OIDS exists, which I don't really understand. Isn't that a database-specific column? Should it even be visible? ahp ---(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] wxWindows Build
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 June 2003 02:38 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] wxWindows Build I should point out (perhaps as I should have before) that the 2003-06-07 CVS tree of wxWindows does not build on Mac OS X. That should be reason enough to upgrade the CVS tree. OK, is there a newe[r|st] one that does? Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html Damned if I know. I tried a few last night, and had problems with all of them. The program builds, but the include files are screwed up, so I couldn't build anything against wxWindows. I will keep trying to find a good one. ahp
[pgadmin-hackers] frmQueryBuilder.cpp.patch
Here is a patch that fixes bug #2 in QB. I have, of course, encountered another fatal bug right away :-(, but at least here's another one down. This code actually overcomes a problem with the wxWindows code, not our own, per se, but until it is fixed in wx (I have notified them of the problem), this will have to do. ahp --- pgadmin3/src/ui/frmQueryBuilder.cpp 2003-06-26 05:38:24.0 -0400 +++ pgadmin3.new/src/ui/frmQueryBuilder.cpp 2003-06-26 14:05:53.0 -0400 @@ -299,8 +299,10 @@ wxMDIClientWindow* frmQueryBuilder::OnCreateClient() { - myClientWindow *tmpwin = new myClientWindow(); - return tmpwin; + m_clientWindow = new myClientWindow(); + return m_clientWindow; +// myClientWindow *tmpwin = new myClientWindow(); +// return tmpwin; } ---(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] pgConn.cpp.patch
Dave Page wrote: Message Yes, this is because the PQsetClientEncoding fails becausethe connection failed. I've changed the preceeding code to: // Set client encoding to Unicode/Ascii if (PQstatus(conn) == CONNECTION_OK) { #if wxUSE_UNICODE wxLogInfo(wxT("Setting client_encoding to 'UNICODE'")); ... ... which takes care of it. Regards, Dave. Doh! Of course it fails. Well, at least this saves me from having to figure out what I missed. BTW, if PQsetClientEncoding fails, which it does, then why would the error come up as a password error? Does that mean that PQsetClientEncoding doesn't change the Postgres errors like other PQ functions? ahp
Re: [pgadmin-hackers] Localisation strings
Andreas Pflug wrote: I skipped recoding these because Keith had stated there was work going on. I'm a bit unhappy that we don't know about the state of QB (while that nasty bug seems to be under control. While I don't know what the current state of the QB is, I can say that I fixed the initial QB segfault only to find another one right away. I am currently working on trying to track down why this is happening, but it's slow going. ahp ---(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