Re: [pgadmin-hackers] Debian Packaging
-Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 00:02 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] Debian Packaging Hi all, If my question is stupid or the answer is something like read the faq at the url: bla, please just tell me where I can find the information and I will wash my eyes :) OK, get some soap! :-) Instructions for setting up a build environment are in: doc/en_US/unix_compilation.html In the pgAdmin source tree. This lists the currently recommended wx version, and all the configure options you should need. What it doesn't list is wxWindows dependencies - for those, please check the wxWindows docs. Slackware 9 for example, has everything already installed as standard. I don't know about Debian Woody... Lemme know if you get stuck :-) Regards, Dave ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-hackers] Snapshots downloads
Hi Guys, I need to keep traffic on snake to a minimum, so if advertising snashots or anything, please point users to http://www.pgadmin.org/snapshots. This is rsync'd from snake daily. If you need to point a user at specific fix or whatever though, snake is fine. Cheers, Dave. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-hackers] Snapshots downloads + patch
-Original Message- From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 10:57 To: [EMAIL PROTECTED] Cc: Adam Pendleton; Dave Page Subject: Snapshots downloads + patch On Friday 20 June 2003 11:34, Dave Page wrote: I need to keep traffic on snake to a minimum, so if advertising snashots or anything, please point users to http://www.pgadmin.org/snapshots. This is rsync'd from snake daily. Dear Dave, This morning, I added an Installing binary snapshots page (snapshot.html) to the documentation and will update the links. This page needs more information about installing Debian, Win32, Slackware. Yes, I saw it. Some of the closing tags looked a bit messed up btw. We should probably consider some standards for the docs as well - such as commands etc. being in italics, and html source wrapping at 80 characters. When the page is finished, would it be possible to copy it to http://www.pgadmin.org/snapshots/index.html? I see no reason why not. Also, I am having problems with autoconf and automake: - Mandrake 91 Old autoconf and automake versions are provided. Nothing new on Cooker. It is impossible to update from RedHat versions. Could you connect on the Mandrake host (I need your private key) and try to compile pgAdmi3. Mandrake is as important as SuSE in Germany and we need a more compliant autoconf script. Happy to help, but I cannot give you my private key as it's umm, private. My ssh2-RSA public key is below. BEGIN SSH2 PUBLIC KEY Comment: rsa-key-20030620 B3NzaC1yc2EBJQAAAIEAiXYu7b7UBzUJHq6feNxFXpQ/oPnf5X5zzvF9 qQkhX+evQUYbXtsCHCAZ1JQmE9BRVv0Cq7/WmCQAExIgyzK8dNNByp13Cc92K+GV E5Vb4OMYksjYIPTLvd133eM8Zt0hcyU7bvc+LgGTevB34khPMcOVdsrscTEg6tpL TStrIAs= END SSH2 PUBLIC KEY - SuSE 8.2 The requested PostgreSQL header files cannot be found under SuSE without a patch written by Reinhard. This patch still needs to be reviewed. Please find it included in this email. OK, I'll take a look, but if it doesn't make sense to me I'll leave it for Adam. Regards, Dave ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] Snapshots downloads + patch
-Original Message-
From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]
Sent: 20 June 2003 10:57
To: [EMAIL PROTECTED]
Cc: Adam Pendleton; Dave Page
Subject: Snapshots downloads + patch
- SuSE 8.2
The requested PostgreSQL header files cannot be found under
SuSE without a patch written by Reinhard. This patch still
needs to be reviewed. Please find it included in this email.
OK, just looked at this and it definately conflicts with changes that I
made this morning (which use ${LIBPQ_HOME} to locate libpq.a).
By the looks of it, SUSE include the extra /pgsql in the path for the
include files. Do they do the same for the libs? Perhaps we should allow
--with-pgsql-include to override the directory derived from
--with-pgsql, but leave that option there.
Adam, what do you think?
Regards, Dave.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Re: [pgadmin-hackers] I'm Back
Dave Page wrote: Hi Adam, Hope you're feeling better. Only a couple of things I'm aware of, and they should be in your inbox from earlier. Regards, Dave. Is it possible for them to be re-sent? I believe they got lost in the mass deleting I did when faced with 1000+ messages to read. :) ahp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] I'm Back
Jean-Michel POURE wrote: On Friday 20 June 2003 15:28, Adam H. Pendleton wrote: - pgAdmin3 configuration script should query wxgtk2ud-2.5-config and not wx-config symlink. The reasons is that pgAdmin3 cannot conflict with existing wxGTK 2.4 installations. Otherwise, it will never enter a Linux distribution. The wx-config symlink should point to the most recent (that is the last 'make install'ed) version of wxWindows on the box. If a user has more than one wxWindows installation, and they want to use a version which is *not* symlinked (I can think of all kinds of problems with this), then we can provide a --with-wx-version= option so they can explicity specify the version they want to use (2.5-2ud, 2.4-ud, 2.4-d, etc.). - Mandrake 9.1 provides rather old autoconf (2.13-16mdk) and automake (1.4-21.p6.mdk) packages. No update is provided on Mandrake Cooker, the equivalent of Rawhide. Also, I tried to install these packages from source, but the installation did not pass the test. So can we do? Would it be possible to use a more complex autoconf script ... which would work on old autoconf + automake? I think I can fix the scripts so that they can be used with the old versions of autoconf and automake. I will need you to test them to make sure they work, but this shouldn't be a problem. - SuSE 8.2 installation needs a patch to find PostgreSQL headers. A patch has been sent to Dave. Please find it enclosed. I've looked at this patch and I'm pretty sure it breaks regular pgsql includes on other systems, but I will create a patch that does work. Your help is welcome. Do you think the wxWindows 2.5 CVS libraries are stable enough to produce a MacOsX version? This would be a killing news... No, the Mac port is in pretty bad shape, and I don't know how much of it can be blamed on wxWindows (my wxWindows apps work fine on Mac). Your donated Mac is much too slow for me to use (slow from a network perspective that is), and using my laptop for development is somewhat tedious, though it should work for the time being. I am trying to get a Mac machine to put on my network here, which should speed up my Mac debugging. ahp ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] I'm Back
Adam H. Pendleton wrote: Jean-Michel POURE wrote: On Friday 20 June 2003 15:28, Adam H. Pendleton wrote: - pgAdmin3 configuration script should query wxgtk2ud-2.5-config and not wx-config symlink. The reasons is that pgAdmin3 cannot conflict with existing wxGTK 2.4 installations. Otherwise, it will never enter a Linux distribution. The wx-config symlink should point to the most recent (that is the last 'make install'ed) version of wxWindows on the box. If a user has more than one wxWindows installation, and they want to use a version which is *not* symlinked (I can think of all kinds of problems with this), then we can provide a --with-wx-version= option so they can explicity specify the version they want to use (2.5-2ud, 2.4-ud, 2.4-d, etc.). Why do we need that? There's the --with-wx option, which should point to a valid wxWindows directory, from there the version should be derived. Unicode and debug chars are derived from their appropriate options. - Mandrake 9.1 provides rather old autoconf (2.13-16mdk) and automake (1.4-21.p6.mdk) packages. No update is provided on Mandrake Cooker, the equivalent of Rawhide. Also, I tried to install these packages from source, but the installation did not pass the test. So can we do? Would it be possible to use a more complex autoconf script ... which would work on old autoconf + automake? I think I can fix the scripts so that they can be used with the old versions of autoconf and automake. I will need you to test them to make sure they work, but this shouldn't be a problem. Do we need autoconf to be running on all systems? It's just for creating the configure scripts, and the normal download and compile user will never use autoconf. He'll configure; make; make install and that's ok. An ambitious user who wants to contribute or sth. will be required to use the latest tools, including autoconf. - SuSE 8.2 installation needs a patch to find PostgreSQL headers. A patch has been sent to Dave. Please find it enclosed. Sounds strange to me. I'd expect pgsql lib and include to reside under the same directory (usr/local/include and /usr/local/lib, if no special prefix is applied). Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] I'm Back
Jean-Michel POURE wrote: Agreed. I may take a day or so to compile wxWindows... The Mandrake 8.2 host needs four hours to compile wxWindows... But for daily snapshots, the donated Mac is perfect. If you were living in Europe, I would send you the Mac... Even in Europe I'll bet it's still pretty expensive to ship 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] Autoconf options
Adam H. Pendleton wrote: Here is the list of options that I am going to support. If anyone has comments, changes, etc. please let me know, otherwise I will go ahead with these options: --with-wx=DIR Specifies the root directory of the wxWindows installation (--prefix=DIR passed to configure when building wxWindows). If this setting is *not* specified, then configure will search for wxWindows in /usr, /usr/local, and /usr/local/wx2. --with-pgsql=DIR Same as above, except configure searches for pgsql in /usr, /usr/local, and /usr/local/pgsql --with-pgsql-include=DIR Explicitly specify the pgsql includes directory --enable-debug Compiles a debug version of pgAdmin3. This will override CFLAGS and CXXFLAGS and pass -g -Wall -O0 to both of them, ensuring no optimization code is used. --enable-static Compiles a static (as static as possible, that is) version of pgAdmin3. This will pass a --static and --static-glibc option to the linker, to link against libc statically (this really won't do much, but it doesn't hurt). This will also link against static version of pgsql and wxWindows. DEPRECATED: --enable-wx-gtk2 Compiles against the gtk2 version of wxWindows --enable-wx-unicode Compiles against the unicode version of wxWindows --enable-wx-release Compiles against the release version of wxWindows --with-wx-config=FILE Explicitly specify which wx-config program to use, full path not necessary COMMENTS: Here are my comments about the above options. I, personally, don't like the last four options, because they are only necessary when a user has more than one version of wxWindows on their box. I am *not* going to include them unless I hear otherwise, and here's why. If a user, or a developer, wants to compile against multiple version of wxWindows to test options, etc. (a perfectly reasonable situation), then they can compile and install wxWindows with different prefixes. So pass a different --prefix=DIR to the wxWindows configure, and then pass that directory to the pgAdmin3 configure with --with-wx=DIR, and pgAdmin3 will compile against that version. Installing two different versions of wxWindows to the same prefix is probably bad news anyway (what if there are different versions of headers for Unicode? The old versions would get overwritten). I don't think it's necessary to support different versions in the same directory structure, and I see no need to do so. Correct me if I am wrong, but otherwise the pgAdmin3 configure will automagically detect which version of wxWindows you have specified and link accordingly. I totally agree. As for creating backwards-compatible versions of the autoconf scripts, Andreas is right. There is no need to do this. You do *not* need to run 'bootstrap' to create a snapshot, you only need to run 'configure'. In truth, it's probably not necessary to even distribute bootstrap, configure.ac, Makefile.am, or acinclude.m4 in our snapshots. The only reason for doing so is to help support platforms where the configure code fails (it happens, but not very often). Distributing those files would allow a user to re-generate configure if needed. In most cases, it is not necessary. So unless 'configure' doesn't run on Mandrake or SuSE or Debian or whatever, I feel no need to produce backwards-compatible scripts. Obviously I bow to the core developers on this one, just let me know. dito. Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[pgadmin-hackers] pgAdmin3 feature freeze?
Exporting of data from the sql window is implemented now. I had a deep look at CREATE OPERATOR CLASS, and decided to to implement a property dialog these days. To program it in a way that's worth it, the dialog should be really intelligent about those strategy numbers. That's not a problem per se, but a lot of work for very few people using it. I believe missing this won't be a big drawback. TODO.txt is updated accordingly. To give some hints about bug reporting, I added an entry to the help menu. It uses the file src/bugreport.html. For release, we could either remove that menu or replace it with a real form, that posts to the pgadmin website/mailing list. Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[pgadmin-hackers] pga2: fix and add
Hi Dave, I have fix and add new functionality. frmmain - fix drop - fix properties frmSQLOutput - add f5 refresh - add canc delete record - add f2 edit rcord - add ins add record - add esc close edit/add record - add f4 save record frmoptions - add Show Users For Privileges - fix form Privileges - add Ask Delete Object Database frmconnect - add description connection Bye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-ooo--- -- GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt WebSite: http://users.jc-hosting.co.uk/frank_lupo -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: L'interpretazione dei doni di orti, frutteti, prati e giardini nel nostro Ristoro Sunflower. Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1478d=20-6 pgadmin.zip Description: Zip compressed data ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] I'm Back
Jean-Michel POURE wrote: This also means we should run autoconf latest version and commit the files to CVS. Any idea? I would prefer generating a snapshot of configure nightly, instead of including it in CVS. Keep in mind that bootstrap also generates two Makefile.in files, so the snapshot would have to include more than just 'configure'. 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] I'm Back
On Friday 20 June 2003 19:26, Adam H. Pendleton wrote: I would prefer generating a snapshot of configure nightly, instead of including it in CVS. Keep in mind that bootstrap also generates two Makefile.in files, so the snapshot would have to include more than just 'configure'. OK, thanks. This is what I did. I only have problems finding PostgreSQL header files under SuSE and Mandrake. Also, could it be possible to support the make distro option? It is sometimes used to ease the making of RPMs. When make distro is run, %(date +%Y%m%d) in pgadmin.spec should be replaced with mmdd. Then, making RPMs becomes easy: rpm -tb pgadmin3.tar.bz2. I added this request to the TODO.txt file in CVS. Don't do it now, it is not urgent at all. Cheers, Jean-Michel ---(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] CVS version does not compile
Cheers, Jean-Michel *** if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -I/usr/lib/wx/include/gtk2ud-2.5 -D__WXDEBUG__ -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -I/usr/include -DDATA_DIR=\/usr/local/pgadmin3/share/pgadmin3/\ -Wall -g -I./include/ -I -g -O2 -MT ctlSQLResult.o -MD -MP -MF .deps/ctlSQLResult.Tpo \ -c -o ctlSQLResult.o `test -f 'ui/ctlSQLResult.cpp' || echo './'`ui/ctlSQLResult.cpp; \ then mv -f .deps/ctlSQLResult.Tpo .deps/ctlSQLResult.Po; \ else rm -f .deps/ctlSQLResult.Tpo; exit 1; \ fi ui/ctlSQLResult.cpp: Dans member function « bool ctlSQLResult::Export() »: ui/ctlSQLResult.cpp:39: erreur d'analyse syntaxique avant « export » make[2]: *** [ctlSQLResult.o] Erreur 1 make[2]: Quitte le répertoire `/usr/src/redhat/BUILD/pgadmin3-0.1.1/src' make[1]: *** [all-recursive] Erreur 1 make[1]: Quitte le répertoire `/usr/src/redhat/BUILD/pgadmin3-0.1.1' make: *** [all] Erreur 2 error: Bad exit status from /var/tmp/rpm-tmp.83769 (%build) ---(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] I'm Back
-Original Message- From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 18:27 To: [EMAIL PROTECTED] Cc: Andreas Pflug; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] I'm Back Jean-Michel POURE wrote: This also means we should run autoconf latest version and commit the files to CVS. Any idea? I would prefer generating a snapshot of configure nightly, instead of including it in CVS. Keep in mind that bootstrap also generates two Makefile.in files, so the snapshot would have to include more than just 'configure'. We do, it's on Snake and www.pgadmin.org. The build-snapshot script does it by getting a clean tree, bootstrapping, configuring and then running make dist. If you need pre-bootstrapped source, grab that. Regards, Dave. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
