Re: [pgadmin-hackers] Web site updates
-Original Message- From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 23:59 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] Web site updates Dear all, I added a compiling from source section in pgAdmin3 web site. Also, I moved the known bugs to the support page. Could you check the download page and validate it? I don't have much time to validate it as I am on holidays. Will continue with the other pending issues later on this week. Looks OK to me :-) Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Some remarks to pgadmin III
-Original Message- From: claus [mailto:[EMAIL PROTECTED] Sent: 14 August 2003 16:00 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] Some remarks to pgadmin III Hello again List, I just tried pgadmin III for the first time, a great piece of work. I just have some very minor remarks that could be useful while beta testing is still in progress. I post them on this list since I could not find a bug tracker. Most of my remarks may be due to the fact that I do not know your cross-plattform development constraints and implementation choices. Personaly I used it on M$ XP for the moment. Please forgive me if the remarks sound stupid. Also I used pgadmin III only for a very short time. (in no particular order) o Quick drill down in treeview is painfull:. When drilling down the + indicating that there are other elements below does not appear at once. The node must be selected first (like pgadmin II 1.6) If double-click the node the properties show up (not like pgadmin II 1.6) I suggest either to display a + per default even if it is not certain that other elements exist. The plus may disappear when trying to open with no nodes below. Or allow double-click to drill down quickly and use right click for properties. Whilst you cannot easily make the + appear quickly, under File - Options you can turn off 'Double-Click for Properties' to allow quicker browsing. The + appear automatically if there are child nodes so we cannot easily put it there by default unless we add dummy nodes. o Context-Menu key (the one between the right windows key and the control key) does not work. Added to Bugs. o Empty icon when changing task using Alt-Tab Added to Bugs. o Help menu - Bugreport - no http link works (do you use the proxy settings?) Added to Bugs. o Right click works only on tree view not in the properties frame(feature ?) Yes, that's by design. o Dropped servers reappear when changing display system objects due to the disconnect/tree refresh Added to Bugs o Crtl-A (select all) does not work in most of the text boxes e.g. analyse/vacuum message window Databse properties comment ... Added to Bugs. o Query tool shows up with objects creation SQL. Ok this is a feature but could it be an optional one :-) It is - check the Options form :-) Thanks for the bug reports. Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] FW: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh /usr/local/src/pgadmin3/pkg/slackware/build-package
-Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 17:38 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] FW: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh /usr/local/src/pgadmin3/pkg/slackware/build-package Dave Page wrote: Something is still broken... Own up, who did it? make[1]: Entering directory `/usr/local/src/pgadmin3/src' make[1]: *** No rule to make target `include/version.h', Gosh, it was me... forgot to put version.h into cvs... Tut-tut. And I'll bet you still haven't got a longer name yet! :-) Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Web site updates
Righto, will take a look. Might be tomorrow though. BTW, did I tell you that the translation status' doesn't work anymore on www? I checked permissions, and that files exist and all looks OK. I can't figure out what's wrong. The cache files appear to have stored the incorrect values in them. Any ideas? Regards, Dave. -Original Message- From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 23:59 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] Web site updates Dear all, I added a compiling from source section in pgAdmin3 web site. Also, I moved the known bugs to the support page. Could you check the download page and validate it? I don't have much time to validate it as I am on holidays. Will continue with the other pending issues later on this week. Cheers, Jean-Michel ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] ConnSettings
-Original Message- From: claus [mailto:[EMAIL PROTECTED] Sent: 14 August 2003 13:46 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] ConnSettings Hello list, I am trying to convince pgadmin 1.6.0 to display my Unicode encode databases as WIN1250 per default (not launching a SET CLIENT ENCODING command on each connection). The problem is that pgadmin does not use a DNS but uses ODBC dynamically setting up the connection string by explicitely. Hello, The problem is not the DSNless connection, but rather the fact the VB (in which pga2 is written) will not handle Unicode. Beleive me, if it did, the connection string would be set as required :-) If you wish to use Unicode, you can do so in pgAdmin III which can be downlaoded at http://www.pgadmin.org/pgadmin3/download.php. The most recent release is beta 1, but it's pretty stable now for most tasks. Bug reports for issues you may find are appreciated though! Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] pga3 website
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 05 August 2003 22:09 To: Dave Page Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] pga3 website Dave Page wrote: I'm not after state of the art for the sake of it. The major reasons I use MSI are: a) Easily scriptable for any msi file for automated installation pgAdmin3 probably won't be distributed widely in a company, so I doubt pgAdmin3 will ever be distributed automatically. I know of at least one case where pgAdmin II is used in this way though I cannot go into details of that particular site. It also allows easy, seamless installation as a post intall step of other installers. b) Allows use/creation of merge modules for easy bundling of software - something Jean-Michel is extremely keen on. Bundle with what? PostgreSQL, psqlODBC, Npgsql, WinMaster... I don't believe it until I see it happening. So there's a monopolization for D.P. at the moment for compiling the releases... Not really. You could get the Installer SDK from Microsoft (it's free), or Wise, Installshield or anything else that supports MSI. Most will open the MSI file directly, not requiring the Wise project file at all. The pkg\win32 is tied to Wise now. AFAICS MS Installer seems to be *not* free (I believed that too, until I tried to locate it today, it's free for licensed customers of any VS6 Prof or Enterprise), and VS6SP3 is a prerequisite either. While running in a MS-only development world is easy, we should provide non-MS ways too. Currently, using the MS Installer SDK would be consistent since we still need MS to compile. BTW, to anticipate Jean-Michel: a multi-language installation process would be nice :-) Besides which, so what if I make the builds? I've done it for the last 6 years anyway, and as Jean-Michel said quite recently, the installers I build are of good quality. There's no doubt about the quality, just do it Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] BUGS.txt and TODO.txt files
On Sunday 10 August 2003 10:24, Dave Page wrote: Now that we have gone to beta, perhaps we should have a CHANGELOG.txt as well? CVS logs are way too verbose for that, and I usually include the changelog for pgAdmin II in release announcements... Regards, Dave. OK. 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
Re: [pgadmin-hackers] pgAdmin3 help system
Darko Prenosil wrote: pgsql content was done acording content html page (Not even one item more or less). Darko, it was only the first-level content. There is a second level and often also a third level. They all fit smoothly in the contents tree, each addressing a single html file (no tags). So far, I added the sql-xxx pages, so there are about 450 entries left. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] dlgDomain_patch
I am sorry. Attached mistake - Original Message - From: Hiroshi Saito [EMAIL PROTECTED] To: Andreas Pflug [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Dave Page [EMAIL PROTECTED] Sent: Friday, August 08, 2003 11:12 AM Subject: [pgadmin-hackers] dlgDomain_patch Hi Andreas. A comment is lost. Please apply it. Regards, Hiroshi Saito ---(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 dlgDomain_patch Description: Binary data ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] pga3 website
Dave Page wrote: Yes, it is Wise. I don't think the snapshots need an installer anyway - we can keep that for official releases. Sure, snapshots don't need it. But betas and RCs should be packaged. Regards, Andreas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] pgadmin3 web problem
-Original Message- From: Howard Bagcat [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 13:53 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [pgadmin-hackers] pgadmin3 web problem Hi, I tried surfing translation site [1] and I end up having the following errors [2]. [1] http://www.pgadmin.org/pgadmin3/translation.php [2] Warning: fopen(/usr/local/www/pgadmin.postgresql.org/pgadmin3/cache/cac he_translated.txt.new): failed to open stream: Permission denied in /usr/local/www/pgadmin.postgresql.org/pgadmin3/class/pgadmin_p o.php on line 22 Cannot open file (/usr/local/www/pgadmin.postgresql.org/pgadmin3/cache/cache_tr anslated.txt) Thanks Howard - should be OK now. Regards, Dave. ---(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] pga3 website
-Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 05 August 2003 22:09 To: Dave Page Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] pga3 website Dave Page wrote: I'm not after state of the art for the sake of it. The major reasons I use MSI are: a) Easily scriptable for any msi file for automated installation pgAdmin3 probably won't be distributed widely in a company, so I doubt pgAdmin3 will ever be distributed automatically. I know of at least one case where pgAdmin II is used in this way though I cannot go into details of that particular site. It also allows easy, seamless installation as a post intall step of other installers. b) Allows use/creation of merge modules for easy bundling of software - something Jean-Michel is extremely keen on. Bundle with what? PostgreSQL, psqlODBC, Npgsql, WinMaster... So there's a monopolization for D.P. at the moment for compiling the releases... Not really. You could get the Installer SDK from Microsoft (it's free), or Wise, Installshield or anything else that supports MSI. Most will open the MSI file directly, not requiring the Wise project file at all. Besides which, so what if I make the builds? I've done it for the last 6 years anyway, and as Jean-Michel said quite recently, the installers I build are of good quality. I really don't see the problem here anyway. MSI has some advantages which are useful to some, and we have a working installer already. Why must we change? Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] FW: Bug Report
Dave Page wrote: Forwarded to list... -Original Message- *From:* Ali AYEN [mailto:[EMAIL PROTECTED] *Sent:* 07 August 2003 12:19 *To:* [EMAIL PROTECTED] *Subject:* Bug Report Hello Dave, I am using PgAdmin III now. I started to use it today and I found a bug. I just looked at known bugs it is not in. I am using Windows Server 2003. My PgSQL server is on my local network, a Redhat 9.0 with PgSQL 7.3.2. The problem description is: I connect my server with password. Select my database, right click, Properties, In security tab, when I try to right click on any item, I get following error: Hi Ali, this is quite weird because the dialog and its controls don't have a right mouse handling at all. So if I understand you right, all you do is selecting an item in the Security list view, causing that crash, which would mean that this crash should happen also if you use the left mouse button, please verify that. When selecting an item in the list view, its values are copied to the controls below, maybe something's wrong with that. Please check this: - bring up the database properties dialog but do *not* select any item. - What items do appear in the Groups combobox? - Try selecting one, add some privileges and add it to the listview. Does this work? do you still have a crash when selecting an item? Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] Package naming conventions
Hi Guys, I have corrected the naming on some of the uploaded beta releases as they were inconsistant. For reference, let's try to use something like: Snapshots = pgadmin3-mmdd.tgz pgadmin3-mmdd.txt pgadmin3-mmdd.tar.gz pgadmin3-mmdd.i386.rpm Releases pgadmin3-x.y.z.tgz pgadmin3-x.y.z.txt pgadmin3-x.y.z.tar.gz pgadmin3-x.y.z.i386.rpm Of course, local conventions may dictate slightly different formats, but for anything other than snapshots, let's keep to the version number in the filename. Cheers, Dave. ---(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] Contributed packages and trust problem ?
On Monday 11 August 2003 10:57, Dave Page wrote: OK, I've signed the source tarball for now. Jean-Michel, can you add my PGP key to the website somewhere please: No problem. Jean-Michel ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] pga3 website
-Original Message- From: Darko Prenosil [mailto:[EMAIL PROTECTED] Sent: 07 August 2003 18:23 To: Dave Page; Adam H. Pendleton Cc: Andreas Pflug; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] pga3 website 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 It is working, but with precompilled libpq (there is no way to compile libpq using MinGW jet). I used wxWindows 2.5 from CVS also compiled using MinGW and precompilled libpq downloaded with pgaccess. Everithing is working just fine, and I do not see any differences in compare to downloaded pgadmin binary compilled with VC. Just so we're clear on this - I am leaving this for Adam to handle as he offered seeing as he's the autoconf guru :-) Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] Package naming conventions
Dave Page wrote: -Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 15:28 To: Dave Page Subject: Re: [pgadmin-hackers] Package naming conventions If you look to what I did in debian packages, the actual beta is 0.9.0-0.1 if we build a snapshot release of a new 0.9.0 (what we shouldn't as it would be incompatible with what we said before), it will be named 0.9.0-0.1+cvsMMDD.1 which is greater than 0.9.0-0.1 so it's ok. if we build a snapshot release of a new devel branch i.e 0.9.1 (what should be the right way of handling this), it will be named 0.9.0-0.0[AND NOT 1]+cvsMMDD.1 which is also greater than 0.9.0-0.1, so upgrade is also ok. In pure version number terms, 0.9.0 *is* beta 1. It will not be on any other release. That's ok for me, that's why I said that we shouldn't have another snap build with 0.9.0 version. I just add that we may have to release new packages to correct some breaks coming from the package itself for example and that this will be followed by the minor number incremented in the package number. (0.9.0-0.1, 0.9.0-0.2,... and finally 0.9.0-1.0 if the package become an official member of debian... May be one day... Who knows ?) Snapshots will now be 0.9.1 + date, and then beta 2 will be 0.9.2, then snapshots will be 0.9.3 + date and so on. Still ok for me :) but the date is just part of the package release for snapshots. Do we need anything more complicated? No that's what I tried to told in my previous mail (I surely badly explained it), with only some considerations regarding packages. But that's not what is actually done for some packages on the ftp site: I just wanted to cath your eyes on this So shall the rpm packages, and may be some other, be rebuilt for this beta release ? If so, Jean Michel do you need some help concerning this work ? Regards, Raphaël Regards, Dave. PS. In pgAdmin II we didn't use dates, but each build incremented the build number (z in x.y.z). That relied on VB to autoincrement the number though :-( ---(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] 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] Package naming conventions
-Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 09 August 2003 20:41 To: [EMAIL PROTECTED]; Dave Page; Andreas Pflug Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] Package naming conventions Jean-Michel POURE wrote: It will take me some time because I have to rebuild wxWindows as well. I missed the information to upgrade to 20030722... I missed it too... Did you find any mail concerning this ? Wasn't it a wx snap that was about to become the supported one but gave some problem at the last minute ? To me, the last good known and supported one was 20030707... Dave, Andreas ? Sorry guys, maybe I forgot to email the list. We upgraded due to issues in wxHtml/wxHtmlHelp on Windows. There were also a couple of other fixes for Unicode support iirc. Please kiss the ocean for me. Yes, and me. The last bit I was at was on the island of Cumbrae and was covered in jellyfish, about 4 miles from a nuclear powerstation :-( Best I've got now is a 10 foot pool in the garden!! /D ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] unsubscribe
Re: [pgadmin-hackers] pga3 Beta 1 Release
On Wednesday 06 August 2003 11:57, Dave Page wrote: I have rolled a beta 1 release and uploaded src, win32 and slackware builds to snake.pgadmin.org:/usr/local/apache/htdocs/ftp/beta (accessible at http://snake.pgadmin.org/ftp/). I'd appreciate a couple of confirmations that these look OK. Dear Dave, Andreas, Hiroshi and all other friends... The site to dispay the list of PostgreSQL mirrors. I am rolling out binaries and will be back shortly... 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
Re: [pgadmin-hackers] pga3 Beta 1
On Thursday 07 August 2003 14:04, Andreas Pflug wrote: - expose TODO.txt and BUGS.txt to the users, so they can be checked and referenced for bug reporting. - FAQ should be in CVS, with automatic update to the FAQ site. - Announcement on postgresql.org Dear Andreas and friends, Agreed. I added a TODO.txt file with various items: http://snake.pgadmin.org/pgadmin3/TODO.txt I am busy at the moment and will try to close these items tonight. It should not stop you from going beta. We can update the site later on. Cheers, Jean-Michel ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] pga3 Beta 1 Release
-Original Message- From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] Sent: 07 August 2003 15:35 To: Dave Page Cc: [EMAIL PROTECTED] Subject: 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? Would love to. I'm not worried about them for beta1, though it would be good to get them out there as soon as we can :-) Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] BUGS.txt and TODO.txt files
It's rumoured that Jean-Michel POURE once said: Dear friends, Do not hesitate to modify BUGS.txt and TODO.txt, which are now displayed automatically on the web site in the Development page (with a one hour delay). Now that we have gone to beta, perhaps we should have a CHANGELOG.txt as well? CVS logs are way too verbose for that, and I usually include the changelog for pgAdmin II in release announcements... Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] FW: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 17:38 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] FW: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh /usr/local/src/pgadmin3/pkg/slackware/build-package Dave Page wrote: Something is still broken... Own up, who did it? make[1]: Entering directory `/usr/local/src/pgadmin3/src' make[1]: *** No rule to make target `include/version.h', Gosh, it was me... forgot to put version.h into cvs... Tut-tut. And I'll bet you still haven't got a longer name yet! blush I really hoped you wouldn't ask... Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-hackers] pgAdmin III Beta 1
Hi Guys, I intend to tag CVS for beta 1 tomorrow. Please shout now if there is any (very) good reason why this should be delayed, or if there are any last minute patches to get in. Regards, Dave. ---(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] [Fwd: Re: [pgadmin-support] [Fwd: problem downloading/installing pgadmin3 on Debian testing]]
-Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 09 August 2003 10:41 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] [Fwd: Re: [pgadmin-support] [Fwd: problem downloading/installing pgadmin3 on Debian testing]] Dear friends, What is your position concerning support on other Linux architecture (sparc, hp,...) ? I think the more we have, the best it is, but wouldn't introduce massive work on porting to other architectures. I can try to produce packages for Debian HPPA64 but may be only for frozen releases (beta and final ones). The more the merrier as long as individual packagers don't get overloaded and give up altogether. That wouldn't be cool... Regards, Dave. ---(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] ConnSettings
OK I will try pgadmin III beta I think it is stable enough for me. Nevertheless if I execute SET CLIENT_ENCODING = LATIN1; in an SQL Window the character display is fine even in pgadmin II since the translation is (I guess) done by the server process and vb just diplays character it can display. So I thought the ConnSetting does the same but it seems not to be used. Thank you, Claus - Original Message - From: Dave Page [EMAIL PROTECTED] snip The problem is not the DSNless connection, but rather the fact the VB (in which pga2 is written) will not handle Unicode. Beleive me, if it did, the connection string would be set as required :-) snip ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-hackers] dlgTable_patch
Hi Andreas. It can't be operated by the table which has one column. Operation is drop. This becomes the table of the sky. You should prevent Drop operation from doing it if it is presumed injustice operation though the intention of this operation is strange. I think that it should do this patch from the flow. Which is better? Regards, Hiroshi Saito dlgTable_patch Description: Binary data ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] Contributed packages and trust problem ?
It's rumoured that Raphaël Enrici once said: Dave Page wrote: -Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 09 August 2003 19:14 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] Contributed packages and trust problem ? Never considered it in the past as I always did the builds. I think it is a valid problem though. Is there any way we can sign the source code such that when it's compiled we can verify that it was unmodified source? Never heard about something like this No, me neither. Perhaps it'll make a topic for my dissertation... What did you have in mind, a pgp sig for each file? I don't see that as a problem for each packager to create. As RPM and DEB packages integrates gpg signatures, I just wanted to know if their were a pgp/gpg key global to the pgAdmin team, something that was used to sign the files of the project like binaries, sources, etc. I'm ok to sign deb package by myself. And wanted to know if you used by the past to sign the files ? For example the source tarball and win32 packages. No, there is no 'global' key. That would probably be pretty insecure. I would think that a pgp/gpg sig from the packager would suffice - it would at least prove that the file hadn't been tampered. Mind you, it doesn't prevent someone packaging their own version and pretending they are the official packager. Perhaps I should sign everything? Regards, Dave. ---(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] Wahoo!!
Hi Guys, As you probably noticed, I just announced the first Beta version of pgAdmin III. This is a milestone for the project, and wouldn't have been possible without the hard work and effort put in by numerous of you. I'm not going to name anyone explicitly because I'll only miss a name out and accidently upset someone, but I would like to express thanks to all the coders, translators, porters and testers that have helped the project get this far. Let's keep up the good work, and put out a killer 1.0.0 product!! Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] Package naming conventions
Dave Page wrote: -Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 09 August 2003 20:41 To: [EMAIL PROTECTED]; Dave Page; Andreas Pflug Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] Package naming conventions Jean-Michel POURE wrote: It will take me some time because I have to rebuild wxWindows as well. I missed the information to upgrade to 20030722... I missed it too... Did you find any mail concerning this ? Wasn't it a wx snap that was about to become the supported one but gave some problem at the last minute ? To me, the last good known and supported one was 20030707... Dave, Andreas ? Sorry guys, maybe I forgot to email the list. We upgraded due to issues in wxHtml/wxHtmlHelp on Windows. There were also a couple of other fixes for Unicode support iirc. I thought we did announce this. Please kiss the ocean for me. Yes, and me. The last bit I was at was on the island of Cumbrae and was covered in jellyfish, about 4 miles from a nuclear powerstation :-( Hu, that sounds really attractive... Best I've got now is a 10 foot pool in the garden!! Better than what I've got, so I'll have a trip to the Ostsee tomorrow, to escape this heat, and won't be back before monday. Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] Package naming conventions
On Friday 08 August 2003 16:09, Dave Page wrote: What do other projects do? Some projects like Wine use date time for release numbers. Very few projects use dates. It would solve many problems in my opinion, because anyone understands a date. Release number + date gives you a precise information at the first glance. Cheers, Jean-Michel ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] dlgDomain_patch
Hiroshi Saito wrote: A comment is lost. Please apply it. Thanks Hiroshi, patch applied. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] FW: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh
Dave Page wrote: Something is still broken... Own up, who did it? make[1]: Entering directory `/usr/local/src/pgadmin3/src' make[1]: *** No rule to make target `include/version.h', Gosh, it was me... forgot to put version.h into cvs... 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])
Re: [pgadmin-hackers] Package naming conventions
Dave Page wrote: -Original Message- From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 14:51 To: Raphaël Enrici; Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] Package naming conventions Dear all, I agree with Raphaël. We cannot have two naming conventions for technical reasons. It is not possible to change the version of an RPM at file system level. Furthermore, users should be able to install from snapshots, then upgrade with beta, then install snapshots, etc... The problem is that the date is only applicable to snapshots. Release versions may be created anytime after CVS is tagged. What do other projects do? If you look to what I did in debian packages, the actual beta is 0.9.0-0.1 if we build a snapshot release of a new 0.9.0 (what we shouldn't as it would be incompatible with what we said before), it will be named 0.9.0-0.1+cvsMMDD.1 which is greater than 0.9.0-0.1 so it's ok. if we build a snapshot release of a new devel branch i.e 0.9.1 (what should be the right way of handling this), it will be named 0.9.0-0.0[AND NOT 1]+cvsMMDD.1 which is also greater than 0.9.0-0.1, so upgrade is also ok. IMHO it's one of the good way of handling this. Do you agree ? Thanks, Raphaël ---(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] pga3 website
Thanks Adam - patch applied along with a few extra ;'s :-) -Original Message- From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 14:28 To: Darko Prenosil Cc: Dave Page; Andreas Pflug; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] pga3 website Attached is a patch for acinclude.m4 containing the msw fixes. It also contains my fixes from the 7/21/03 acinclude patch that I submitted that doesn't look like it ever got applied. As for the Mac portnot only does wxWindows not build on Mac OS X, but it doesn't contain Unicode support. I'm going to see if I can get a working binary built against 2.4, then try to see if I can get a 2.5 version of wxWindows to build. Film at 11. ahp ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Package naming conventions
Dave Page wrote: -Original Message- From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] Sent: 09 August 2003 21:56 To: Raphaël Enrici; Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] Package naming conventions Dear friends, Raphaël wrote me that the required wxWindows version was 20030707, this is OK for me. To sum up the RPM thing which differs slightlly from Debian: Dear Jean Michel, You were right and I was wrong, it's now 20030722, I'll launch my builds tomorrow. 1) CVS snapshots are numbered: pgadmin3-{version}-cvs{date}.rpm pgadmin3-0.9.0-cvs20030809.rpm 2) FTP uploads are numbered: pgadmin3-{version}-{build}.rpm pgadmin3-0.9.0-1.rpm Build should be 1, 2, 3, etc... When you release a new {version}, the {build} goes back to 1. Agreed? On your reply, I will rebuild the packages. Cheers, Jean-Michel Sounds good to me. Not sure the cvs in the snapshot names is needed, but I don't think it hurts. It's ok for me and really near from what is done on Debian, I like it :). Dave, the cvs information can have its importance when the package is found in an official distro, to distinguish the build from a fully stable one. I found quite a lot of package versioned like that in debian and think it's easy to read and as you said it doesn't hurt. Cheers, Raphaël ---(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] Contributed packages and trust problem ?
-Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 09 August 2003 19:14 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] Contributed packages and trust problem ? Dear all, here is a question on which I'd like to get your opinion. Giuseppe Sacco contributed today a build of the debian packages for PowerPC architecture based on our Debian Source packages. As he is a member of the debian project, I think we can consider him as a trusty person. But what about other persons that may contribute builds for other architectures ? Did you faced this problem in the past ? Never considered it in the past as I always did the builds. I think it is a valid problem though. Is there any way we can sign the source code such that when it's compiled we can verify that it was unmodified source? Is everybody ok to upload his files on snake (I vote yes) ? Another thing I wanted to talk about since days concerns signing of our packages. Is there something done for the moment ? Shall someone sign the files ? Shall every packager sign its own package ? I'm currently looking to what's done in Debian and will give you some feedback on it. What did you have in mind, a pgp sig for each file? I don't see that as a problem for each packager to create. Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-hackers] Cache for translation statistics
Hi Dave, To display cache, PHP needs write access to pgadmin3 folder. Warning: fopen(/usr/local/www/pgadmin.postgresql.org/pgadmin3/translation.php_cache_translated.new): failed to open stream: Permission denied in /usr/local/www/pgadmin.postgresql.org/pgadmin3/class/pgadmin_po.php on line 22 Cannot open file (/usr/local/www/pgadmin.postgresql.org/pgadmin3/translation.php_cache_translated) Snake is well-configured. Cheers, Jean-Michel ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-hackers] Cache feature for translation.php page
Dear all, Statistics on the translation.php page are now cached. This will allow us to resist a large number of hits. They are calculated every 5 minutes and stored in: pgadmin3/translation.php_cache_pending pgadmin3/translation.php_cache_translated Could you check that Apache can write to pgadmin3 folder. I connected to Snake to make the necessary changes but not to www.pgadmin.org Cheers, Jean-Michel ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] FW: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh /usr/local/src/pgadmin3/pkg/slackware/build-package
Something is still broken... Own up, who did it? :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 01:01 To: [EMAIL PROTECTED] Subject: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh /usr/local/src/pgadmin3/pkg/slackware/build-package ? pgadmin.log ? pgadmin3-0.9.0 ? pgadmin3-0.9.0.tar.gz ? pgadmin3-0.9.1 ? pgadmin3-0.9.1.tar.gz ? stamp-h1 ? config/config.guess ? config/config.sub ? config/depcomp ? config/install-sh ? config/missing ? config/mkinstalldirs cvs server: Updating . cvs server: Updating config cvs server: Updating docs cvs server: Updating docs/en_US cvs server: Updating docs/en_US/images cvs server: Updating docs/en_US/pg cvs server: Updating notes cvs server: Updating pkg cvs server: Updating pkg/debian U pkg/debian/README.Debian U pkg/debian/changelog U pkg/debian/control U pkg/debian/copyright U pkg/debian/dirs U pkg/debian/docs U pkg/debian/make-deb U pkg/debian/rules cvs server: Updating pkg/redhat U pkg/redhat/pgadmin3.spec U pkg/redhat/poedit.spec U pkg/redhat/wxGTK2ud.spec cvs server: Updating pkg/slackware U pkg/slackware/build-package U pkg/slackware/slack-desc cvs server: Updating pkg/src U pkg/src/build-tarball cvs server: Updating pkg/win32 U pkg/win32/banner.bmp U pkg/win32/banner.mic U pkg/win32/licence.rtf U pkg/win32/pgadmin3.wsi U pkg/win32/screen.bmp U pkg/win32/screen.mic cvs server: Updating src U src/.cvsignore U src/Makefile.am U src/pgAdmin3.cpp U src/pgAdmin3.dsp U src/pgAdmin3.dsw cvs server: Updating src/db U src/db/pgConn.cpp U src/db/pgSet.cpp cvs server: Updating src/db/pg cvs server: Updating src/images cvs server: Updating src/include U src/include/copyright.h U src/include/ctlSQLBox.h U src/include/ctlSQLResult.h U src/include/dlgAddTableView.h U src/include/dlgAggregate.h U src/include/dlgCast.h U src/include/dlgCheck.h U src/include/dlgColumn.h U src/include/dlgConversion.h U src/include/dlgDatabase.h U src/include/dlgDomain.h U src/include/dlgForeignKey.h U src/include/dlgFunction.h U src/include/dlgGroup.h U src/include/dlgIndex.h U src/include/dlgIndexConstraint.h U src/include/dlgLanguage.h U src/include/dlgOperator.h U src/include/dlgProperty.h U src/include/dlgRule.h U src/include/dlgSchema.h U src/include/dlgSequence.h U src/include/dlgTable.h U src/include/dlgTrigger.h U src/include/dlgType.h U src/include/dlgUser.h U src/include/dlgView.h U src/include/frmAbout.h U src/include/frmChildTableViewFrame.h U src/include/frmConnect.h U src/include/frmEditGrid.h U src/include/frmExport.h U src/include/frmHelp.h U src/include/frmMain.h U src/include/frmOptions.h U src/include/frmPassword.h U src/include/frmQBJoin.h U src/include/frmQuery.h U src/include/frmQueryBuilder.h U src/include/frmSplash.h U src/include/frmStatus.h U src/include/frmVacuum.h U src/include/menu.h U src/include/misc.h U src/include/pgAdmin3.h U src/include/pgAggregate.h U src/include/pgCast.h U src/include/pgCheck.h U src/include/pgCollection.h U src/include/pgColumn.h U src/include/pgConn.h U src/include/pgConstraints.h U src/include/pgConversion.h U src/include/pgDatabase.h U src/include/pgDatatype.h U src/include/pgDefs.h U src/include/pgDomain.h U src/include/pgForeignKey.h U src/include/pgFunction.h U src/include/pgGroup.h U src/include/pgIndex.h U src/include/pgIndexConstraint.h U src/include/pgLanguage.h U src/include/pgObject.h U src/include/pgOperator.h U src/include/pgOperatorClass.h U src/include/pgRule.h U src/include/pgSchema.h U src/include/pgSequence.h U src/include/pgServer.h U src/include/pgSet.h U src/include/pgTable.h U src/include/pgTrigger.h U src/include/pgType.h U src/include/pgUser.h U src/include/pgView.h U src/include/sysLogger.h U src/include/sysSettings.h U src/include/wxgridsel.h cvs server: Updating src/include/images U src/include/images/.cvsignore U src/include/images/aggregate.xpm U src/include/images/back.xpm U src/include/images/baddatabase.xpm U src/include/images/cast.xpm U src/include/images/check.xpm U src/include/images/clip_copy.xpm U src/include/images/clip_cut.xpm U src/include/images/clip_paste.xpm U src/include/images/closeddatabase.xpm U src/include/images/closedown.xpm U src/include/images/closeup.xpm U src/include/images/column.xpm U src/include/images/connect.xpm U src/include/images/constraints.xpm U src/include/images/conversion.xpm U src/include/images/create.xpm U src/include/images/database.xpm U src/include/images/delete.xpm U src/include/images/dnd_copy.xpm U src/include/images/dnd_move.xpm U src/include/images/dnd_none.xpm U src/include/images/domain.xpm U src/include/images/drop.xpm U src/include/images/edit_clear.xpm U src/include/images/edit_find.xpm U src/include/images/edit_redo.xpm U src/include/images/edit_undo.xpm U src/include/images/encoding.xpm U src/include/images/event.xpm U
[pgadmin-hackers] Some remarks to pgadmin III
Hello again List, I just tried pgadmin III for the first time, a great piece of work. I just have some very minor remarks that could be useful while beta testing is still in progress. I post them on this list since I could not find a bug tracker. Most of my remarks may be due to the fact that I do not know your cross-plattform development constraints and implementation choices. Personaly I used it on M$ XP for the moment. Please forgive me if the remarks sound stupid. Also I used pgadmin III only for a very short time. (in no particular order) o Quick drill down in treeview is painfull:. When drilling down the + indicating that there are other elements below does not appear at once. The node must be selected first (like pgadmin II 1.6) If double-click the node the properties show up (not like pgadmin II 1.6) I suggest either to display a + per default even if it is not certain that other elements exist. The plus may disappear when trying to open with no nodes below. Or allow double-click to drill down quickly and use right click for properties. o Context-Menu key (the one between the right windows key and the control key) does not work. o Empty icon when changing task using Alt-Tab o Help menu - Bugreport - no http link works (do you use the proxy settings?) o Right click works only on tree view not in the properties frame(feature ?) o Dropped servers reappear when changing display system objects due to the disconnect/tree refresh o Crtl-A (select all) does not work in most of the text boxes e.g. analyse/vacuum message window Databse properties comment ... o Query tool shows up with objects creation SQL. Ok this is a feature but could it be an optional one :-) Regards, Claus ---(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] pga3 Beta 1 Release
Jean-Michel POURE wrote: I did not read wxWindows threads for a long time, but I understand that Mac December developper tools are based on gcc3.3. In July, wxWindows did not compile under gcc3.3 (=SuSE8.2). So you have to use older gcc3.2 developer tools. Just for information, I use gcc3.3 [ 3.3.1 20030626 (Debian prerelease) ] to build wxWindows 2.5 on Debian and it builds well (I didn't find errors in the build log). I remember we had a thread on this but don't remember the conclusions... Isn't it a specific Suse problem ? Raphal. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] pga3 Beta 1 Release
Dave Page wrote: -Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 07 August 2003 09:52 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] pga3 Beta 1 Release Dave Page wrote: This entire directory tree is being rsync'd to ftp.postgresql.org/pub/pgadmin3 (and therefore the PostgreSQL mirror system as well) on a 6 hourly basis. Hi Dave, should this URL be the primary place for users who wants to try the software ? Or should this still be something on www.pgadmin.org/xxx ? http://www.pgadmin.org/pgadmin3/download.php Instructions on this page concerning debian install are not valid anymore since they point to the snapshots' build : http://www.pgadmin.org/snapshots/linux/debian The following lines * For Debian WOODY: deb http://www.pgadmin.org/snapshots/linux/debian woody pgadmin * For Debian TESTING: deb http://www.pgadmin.org/snapshots/linux/debian testing pgadmin * For Debian UNSTABLE: deb http://www.pgadmin.org/snapshots/linux/debian unstable pgadmin Should be replaced by something like this: * For Debian WOODY: deb [MIRROR'S URL]/beta/debian woody pgadmin * For Debian TESTING: deb [MIRROR'S URL]/beta/debian testing pgadmin * For Debian UNSTABLE: deb [MIRROR'S URL]/beta/debian unstable pgadmin With may be an example: Example for france, you can try: * For Debian WOODY: deb ftp://ftp2.fr.postgresql.org/postgresql/pgadmin3/beta/debian woody pgadmin * For Debian TESTING: deb ftp://ftp2.fr.postgresql.org/postgresql/pgadmin3/beta/debian testing pgadmin * For Debian UNSTABLE: deb ftp://ftp2.fr.postgresql.org/postgresql/pgadmin3/beta/debian unstable pgadmin Cheers, Raphaël ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] dlgTable_patch
Dave Page wrote: I just added the new 7.4's feature, being able to have zero columns (whatever that's good for...). Multiple inherited tables, but no columns of it's own. dlgTable will show inherited columns, so that table isn't considered empty. PostgreSQL 7.4 now allows CREATE TABLE empty() Could be used as an anchor for rules, just as CREATE VIEW does. Regards, Andreas ---(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] Wahoo!!
-Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 11:22 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] Wahoo!! Yep, but we should leave something for 2.0.0 :-) Yes, new features. It's a bug free 1.0.0 that I want :-) I'm enjoying this project, working and discussing with you! Likewise. Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] pga3 website
It's rumoured that Andreas Pflug once said: Jean-Michel POURE wrote: On Monday 04 August 2003 23:56, Andreas Pflug wrote: I saw it, and from CVS I think it's done with Wise. I'd love to upload my builds as MSI, but don't have Wise... There are open source installers. Did you check this: http://www.nullsoft.com/free/nsis/ I had a look at NSIS. While this is not the most comfortable one I've ever seen, it should be good enough for us. So I'd vote to use NSIS for all post-beta-1 distributions; I can contribute an initial script. Not unless it does MSI now. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] pgA3 desktop integration
Dear all, did someone on the list made some icons that could be used to integrate pgAdmin3 into our favorites desktops (Gnome, kde and so on) ? I'm currently making some files to add to Debian packages so that pgAdmin becomes available automatically in Gnome's menus after package installation. Regards, Raphaël ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Wahoo!!
From: Dave Page [EMAIL PROTECTED] -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Yep, but we should leave something for 2.0.0 :-) Yes, new features. It's a bug free 1.0.0 that I want :-) I'm enjoying this project, working and discussing with you! Likewise. Regards, Dave. I'm enjoying this project too. I'll buy you a beer, if we're ever on the same continent! Cheers! OT. The next week is the summer vacation of one week. Regards, Hiroshi Saito ---(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] ConnSettings
Hello list, I am trying to convince pgadmin 1.6.0 to display my Unicode encode databases as WIN1250 per default (not launching a SET CLIENT ENCODING command on each connection). The problem is that pgadmin does not use a DNS but uses ODBC dynamically setting up the connection string by explicitely. First I looked after an environment variable but in vain there are only env variables for the DB itself. Then I found the registry entry HKLM\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL\ConnSettings even though there is no way to change it using a UI with regedit I set it to SET+CLIENT%5fENCODING+%3d+%27WIN1250%27%3b the same value as set when using the UI on a particular DNS. I saw that the registry value is read (using regmon) but it does not seem to be used when opening the connection (connection strings in logfiles and db properties in pgadmin) As anyone an idea to fix this encoding problem or should I file a bug report ? Thank you and regards, Claus ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] Some remarks to pgadmin III
Dave Page wrote: I post them on this list since I could not find a bug tracker. You found the right list, post all that stuff here! (in no particular order) o Quick drill down in treeview is painfull:. When drilling down the + indicating that there are other elements below does not appear at once. The node must be selected first I consider this as annoying too, but as Dave stated there's still no good solution for this. wxWindows doesn't have [ ] nodes. I've put this on the TODO list, so this doesn't get lost. o Context-Menu key (the one between the right windows key and the control key) does not work. I don't have this key; this windows crop keys are a PITA. Added support Shift-F10 for context menu on TODO o Empty icon when changing task using Alt-Tab This will probably stay quite a while on the BUGS list. I have absolutely no idea what to do about that. The app icon is defined 32x32 and 48x48 in a standard way. I'm clueless. o Help menu - Bugreport - no http link works (do you use the proxy settings?) This is merely a TODO, not a BUG. wxWindows doesn't support automatic proxy. This reminds me that we still need to embed the pgsql7.4 doc, which in turn might trigger some work on the help contents. o Dropped servers reappear when changing display system objects due to the disconnect/tree refresh Added to Bugs I really believe this isn't worth the effort. Even pgAdmin3 may have a spot of weird behaviour o Crtl-A (select all) does not work in most of the text boxes e.g. analyse/vacuum message window Databse properties comment ... Not a bug; Ctrl-A is not a standard key for text boxes. Use Home and Shift-End instead. Only STC boxes know this key sequence. If we start implementing every key that STC knows we will go mad. o Query tool shows up with objects creation SQL. Ok this is a feature but could it be an optional one :-) It is - check the Options form :-) Yeah... even documented!!! Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Web site updates
On Wednesday 13 August 2003 16:46, Dave Page wrote: BTW, did I tell you that the translation status' doesn't work anymore on www? I checked permissions, and that files exist and all looks OK. I can't figure out what's wrong. The cache files appear to have stored the incorrect values in them. I will have a look at it tomorrow and will fix the script. Cheers, Jean-Michel ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Some remarks to pgadmin III
- Original Message - From: Andreas Pflug [EMAIL PROTECTED] To: claus [EMAIL PROTECTED] Cc: Dave Page [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 11:22 PM Subject: Re: [pgadmin-hackers] Some remarks to pgadmin III This is merely a TODO, not a BUG. wxWindows doesn't support automatic proxy. This reminds me that we still need to embed the pgsql7.4 doc, which in turn might trigger some work on the help contents. I already wolountered to do it, but I'm not going to start without Your blessing, because I do not want to overlap the work with some other contributor. Regards ! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] FW: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh /usr/local/src/pgadmin3/pkg/slackware/build-package
Oh dear, the autmated build failed last night -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 01:01 To: [EMAIL PROTECTED] Subject: cron: sh /usr/local/src/pgadmin3/pkg/src/build-tarball;sh /usr/local/src/pgadmin3/pkg/slackware/build-package Making all in src make[2]: Entering directory `/usr/local/src/pgadmin3/src' if g++ -DHAVE_CONFIG_H -I. -I. -I.. -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 -Wall -g -O0 -MT pgAdmin3.o -MD -MP -MF .deps/pgAdmin3.Tpo \ -c -o pgAdmin3.o `test -f 'pgAdmin3.cpp' || echo './'`pgAdmin3.cpp; \ then mv .deps/pgAdmin3.Tpo .deps/pgAdmin3.Po; \ else rm -f .deps/pgAdmin3.Tpo; exit 1; \ fi pgAdmin3.cpp:32:21: version.h: No such file or directory pgAdmin3.cpp: In member function `virtual bool pgAdmin3::OnInit()': pgAdmin3.cpp:118: `VERSION_STR' undeclared (first use this function) pgAdmin3.cpp:118: (Each undeclared identifier is reported only once for each function it appears in.) make[2]: *** [pgAdmin3.o] Error 1 make[2]: Leaving directory `/usr/local/src/pgadmin3/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/pgadmin3' make: *** [all] Error 2 /usr/bin/strip: src/pgadmin3: No such file or directory ---(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] New upload of 0.9.0 packages
-Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 11:36 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] New upload of 0.9.0 packages I think we shouldn't have a look to 10.20 and older, it's not supported anymore by HP or won't be supported anymore and all softwares I tried to build on such platforms where horrible to build (it lacks about everything and is really far from opensource standards). Agreed, it is pretty useless. May be your host could become a build host for daily snapshots if we find that pgAdmin3 can be built on HPUX 11. Is it easy to put it back online and open an account on it or is it a lot of work ? If it's too much work, wait until I (or someone else) try a build on another host... It's not something I can do quickly, so if you can that would be good. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] New upload of 0.9.0 packages
Dave Page wrote: -Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 11:18 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] New upload of 0.9.0 packages Dave Page wrote: I'll first build a debian package and then will have a try on HPUX. If the build works on HP, I'll produce some packages in .depot Is your machine installed ? which OS version ? Last time I looked it had HP-UX 11.0. I also have 10.10, 10.20 and 9.04 knocking about someplace. I think we shouldn't have a look to 10.20 and older, it's not supported anymore by HP or won't be supported anymore and all softwares I tried to build on such platforms where horrible to build (it lacks about everything and is really far from opensource standards). May be your host could become a build host for daily snapshots if we find that pgAdmin3 can be built on HPUX 11. Is it easy to put it back online and open an account on it or is it a lot of work ? If it's too much work, wait until I (or someone else) try a build on another host... I doubt if CDE or anything is installed though (it is on the CD) - it was a database server running Unidata and Advanced Pick before that. Ok, we will see. Regards, Raphaël ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] Debian HPPA: ok!
Dear all, just another information, the packages built without any modification under debian linux hppa (stable and testing, unstable is for tomorrow). I love ./configure and well developped code! :) I also opened an account on testdrive (http://www.testdrive.hp.com) to quickly try a build on HPUX 11i. I'll tell you the build status asap. Good night. Raphaël ---(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] New upload of 0.9.0 packages
-Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 01:10 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] New upload of 0.9.0 packages Hi all, just for information. I've just uploaded up to date debian packages for i386 built on wxWindows 2.5 20030722 snapshots (which I re-packaged too). I also added the powerpc build from Giuseppe Sacco although it is based on 20030707 (I'll ask him if he can build up to date packages from the new debian sources I uploaded on snake in the ftp/beta section when they will be mirrored). I'll also try to do a build on HPPA architecture tomorrow. OK, thanks. What OS on the HPPA? I have an old HP9000 E35 knocking about, and should have a D350 within a few months. They're old and slow but... Oh, I didn't say, although my task is really minor compared to your work, I REALLY like working with all of you, this is a really exciting experience. So, thank you! No, thank you! Your efforts in creating a Debian port help bring pgAdmin to another group of Linux users, and your work is clearly getting others interested in chipping in and working on ports. My thanks go to all of you guys. Regards, Dave. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] BUGS.txt and TODO.txt files
-Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 11:45 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] BUGS.txt and TODO.txt files Dave, I just noticed added missing helpfile images to Win32 installer from you in CHANGELOG.txt. Actually, only pgadmin3.chm and tips.txt are needed in the docs/en_US directory for win32. Yes, I remember you saying now you mention it. I'll make sure that happens. Regards, Dave. ---(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] Contributed packages and trust problem ?
On Monday 11 August 2003 10:57, Dave Page wrote: OK, I've signed the source tarball for now. Jean-Michel, can you add my PGP key to the website somewhere please: The key is available here: http://snake.pgadmin.org/pgadmin3/pgp/davepage.pgp It is visible in the Installing from source section on the download page. I will finish this section tonight after the beta packages are updated. Cheers, Jean-Michel ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] Package naming conventions
On Saturday 09 August 2003 21:21, Jean-Michel POURE wrote: ANYWAY: I am rebuilding betas with pgadmin3-0.9.0-1.rpm and will upload them during the night. It will take me some time because I have to rebuild wxWindows as well. I missed the information to upgrade to 20030722... Dear friends, Raphal wrote me that the required wxWindows version was 20030707, this is OK for me. To sum up the RPM thing which differs slightlly from Debian: 1) CVS snapshots are numbered: pgadmin3-{version}-cvs{date}.rpm pgadmin3-0.9.0-cvs20030809.rpm 2) FTP uploads are numbered: pgadmin3-{version}-{build}.rpm pgadmin3-0.9.0-1.rpm Build should be 1, 2, 3, etc... When you release a new {version}, the {build} goes back to 1. Agreed? On your reply, I will rebuild the packages. Cheers, Jean-Michel ---(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] Bug in 0.9.1
Added to bugs list. -Original Message- From: Adam H.Pendleton [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 00:36 To: [EMAIL PROTECTED] Subject: [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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] Contributed packages and trust problem ?
Dave Page wrote: It's rumoured that Raphaël Enrici once said: What did you have in mind, a pgp sig for each file? I don't see that as a problem for each packager to create. As RPM and DEB packages integrates gpg signatures, I just wanted to know if their were a pgp/gpg key global to the pgAdmin team, something that was used to sign the files of the project like binaries, sources, etc. I'm ok to sign deb package by myself. And wanted to know if you used by the past to sign the files ? For example the source tarball and win32 packages. No, there is no 'global' key. That would probably be pretty insecure. I would think that a pgp/gpg sig from the packager would suffice - it would at least prove that the file hadn't been tampered. Mind you, it doesn't prevent someone packaging their own version and pretending they are the official packager. Perhaps I should sign everything Dear Dave, IMHO, you should at least sign the tarball you publish as the beta release and all packagers should verify it against your public key before packaging anything and they also should sign their packages with their own keys. May be we also should publish a link to our personnal public keys or the way to get them. Cheers, Raphaël ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] Contributed packages and trust problem ?
-Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 10 August 2003 23:00 To: Dave Page Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] Contributed packages and trust problem ? IMHO, you should at least sign the tarball you publish as the beta release and all packagers should verify it against your public key before packaging anything and they also should sign their packages with their own keys. May be we also should publish a link to our personnal public keys or the way to get them. OK, I've signed the source tarball for now. Jean-Michel, can you add my PGP key to the website somewhere please: -BEGIN PGP PUBLIC KEY BLOCK- Version: PGP 8.0.2 - not licensed for commercial use: www.pgp.com mQGiBD7oXUQRBADSc28+GsqyfZ/AQtEJSzRuwyus/g3XRY1cr93nvPFGNHpemxlg h4R82gbXFZ9Urabptmo631BK58aDjAVtzZKeaUFNvV3DhmjlI7oREXSylTwPF+bq FIqiRBut4JE0p4rGu4gGOkuu8eTVj0gpP+x7EdiqG1SJ0xuqD0ITK8ISowCg/1o+ X/gHAW1mGQ3NBx0pc05xVgEEAL6YurrSsSr4bwwIC0kRCLKauPASFjlM9+L/mo9T SsD0cdjOg1bdjmo/z83Dk7V05TEGZBGgLyxT06VWlk11KNV/hL/XcHDJdpN6Dwe0 ieOLg66Cbr1UChyMt4CD4bR1LdXeargN4XD2fMBmOVyvoLaifwWS+7pLcXZpxmQ1 QP6GA/9dwNQtmALgB+/s1/3qRd4F08yyklw5wXY8bFuY4YR1PPof/C4Tmh1+nJ7M 4/e8O6CkEfylRS4Oh9lEfG4S2U3Ti4OqP1DHg5HqkMR7TtrflTypGzIJE1qxlshh O5yoD+/eM/Sun4Swk68lj6w1hqpQf1Hy6iiTdkdOV3uoVa9/ibQdRGF2ZSBQYWdl IDxkcGFnZUBwZ2FkbWluLm9yZz6JAFcEEBECABcFAj7oXUQHCwkIBwMCCgIZAQUb AwAKCRCWAg4EGhlkOywTAKCHUYxi3UJWMVLpRVk+HSThfgGCFgCg9JEIgink lneCOAnWA8mYCi3nKc+5Ag0EPuhdRBAIAPZCV7cIfwgXcqK61qlC8wXo+VMROU+2 8W65Szgg2gGnVqMU6Y9AVfPQB8bLQ6mUrfdMZIZJ+AyDvWXpF9Sh01D49Vlf3HZS Tz09jdvOmeFXklnN/biudE/F/Ha8g8VHMGHOfMlm/xX5u/2RXscBqtNbno2gpXI6 1Brwv0YAWCvl9Ij9WE5J280gtJ3kkQc2azNsOA1FHQ98iLMcfFstjvbzySPAQ/Cl WxiNjrtVjLhdONM0/XwXV0OjHRhs3jMhLLUq/zzhsSlAGBGNfISnCnLWhsQDGcgH KXrKlQzZlp+r0ApQmwJG0wg9ZqRdQZ+cfL2JSyIZJrqrol7DVekyCzsAAgIH/3mp wFg+fCsmUCoWynH4tUpdpsVaufNX8mTa2MNzMU2REl2iSNvAYv0KgH2hHADmMQ6A 5PWjl4LTV63chbKMLn98XfCWYeF4MR4uxP9a9yxSukFCMHP1bTibg4KSmRNjjSOI 5y2xIFBvCjRNj6nIjtMbzo40Tmm3asgiB8ACCrowO06ZMsQQcXw5mxzImLZ4pS6f hObOgbjloUBbwQ6BnfDu9d4FFDSJDlV0C61lRfF7H9NcRV3Oz+v/taQHKMrfOGXP fN2ClssKz0xLrNN0lGp+mB/cw3tdiTjj8/6zL+gFh8kS1QUHJzRSUkWbrnAvFhIr 60dX+1CQR8nFhwN1CJqJAEwEGBECAAwFAj7oXUQFGwwACgkQlgIOBBoZZDvd eACgkA4MoeIJcCZopSQXLvk4zhgJZ28AoLWcPNcpRHL/Qsco+F5exfjKzYYe =YPnc -END PGP PUBLIC KEY BLOCK- Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] Contributed packages and trust problem ?
Dear all, here is a question on which I'd like to get your opinion. Giuseppe Sacco contributed today a build of the debian packages for PowerPC architecture based on our Debian Source packages. As he is a member of the debian project, I think we can consider him as a trusty person. But what about other persons that may contribute builds for other architectures ? Did you faced this problem in the past ? Is everybody ok to upload his files on snake (I vote yes) ? Another thing I wanted to talk about since days concerns signing of our packages. Is there something done for the moment ? Shall someone sign the files ? Shall every packager sign its own package ? I'm currently looking to what's done in Debian and will give you some feedback on it. Regards, Raphaël ---(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] Debian package patch
Thanks, applied. Regards, Dave. -Original Message- From: Raphaël Enrici [mailto:[EMAIL PROTECTED] Sent: 07 August 2003 02:35 To: Dave Page; Andreas Pflug; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Debian package patch It is better with the file attached :) Cheers, Raphaël Dear all, Debian packages for beta 1 are currently building, I will surely upload them this morning. Can one of you apply this patch until the next release ? This patch fixes files in pkg/debian : - fixes debian versioning scheme - fixes debian package section : databases (does not exist in debian) - misc (section where other postgresql things can be found) - new features in make-deb to make my job easier for next releases :) Thanks, Raphaël ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] pgAdmin3 help system
- Original Message - From: Andreas Pflug [EMAIL PROTECTED] To: Darko Prenosil [EMAIL PROTECTED] Cc: pgadmin-hackers [EMAIL PROTECTED] Sent: Friday, August 08, 2003 5:49 PM Subject: Re: [pgadmin-hackers] pgAdmin3 help system Darko Prenosil wrote: pgsql content was done acording content html page (Not even one item more or less). Darko, it was only the first-level content. There is a second level and often also a third level. They all fit smoothly in the contents tree, each addressing a single html file (no tags). So far, I added the sql-xxx pages, so there are about 450 entries left. Regards, Andreas OK, I see what you meant. I can do the job if You find it useful. However, a real cool thing would be generate it from sgml ... Regards ! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] pga3 Beta 1 Release
Hi Guys, I have rolled a beta 1 release and uploaded src, win32 and slackware builds to snake.pgadmin.org:/usr/local/apache/htdocs/ftp/beta (accessible at http://snake.pgadmin.org/ftp/). I'd appreciate a couple of confirmations that these look OK. 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). This entire directory tree is being rsync'd to ftp.postgresql.org/pub/pgadmin3 (and therefore the PostgreSQL mirror system as well) on a 6 hourly basis. Once more builds are there, and they've had a chance to replicate to the mirrors, we'll do a public announcement. Suggestions for it's content would be appreciated :-) Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-hackers] pgAdmin3 help system
Hi Dave, I revised the help file and entry point generation, I believe it's consistent now. The windows version can now use pgadmin3.chm, if it's present. I believe we should remove the coloured background, reverting to plain white. The content still needs more work to be done for pgsql, but this could be postponed until we have the 7.4 doc. Regards, Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-hackers] pgAdmin3 help system
-Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 10:07 To: Dave Page Cc: pgadmin-hackers Subject: Re: [pgadmin-hackers] pgAdmin3 help system Dave Page wrote: Don't you like the blue? Any other opinions? The CHM doesn't look as programmer's help usually looks like. And wxHtmlHelpController can't cope with it either. 'k The content still needs more work to be done for pgsql, but this could be postponed until we have the 7.4 doc. In what way? All pages should have their own contents entry so they can be located by CHM if sync is pressed. I would have said pgsql was OK, but we need more pgAdmin content if anything. Some more lyrics... :-) An index would be fine too. But this is an awful lot of work. Hmm, yes. It's searchable, and can all be browsed though. I think it's already far more usable than plain HTML. Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Cache for translation statistics
On Thursday 07 August 2003 13:11, Dave Page wrote: It still seems to be writing the files to the pgadmin3 directory, not the new cache directory. Sorry, I did not commit to CVS and deleted my changes. Done now. BTW, is there anything we can do about the font? The default Times New Roman looks crap... I would prefer no default font at all in CSS to let the operatings system or the user choose his/her preffered font. Otherwise, there can be display errors, even in Japanese (which was the case with the current stylesheet). Where did we default Times New Roman? Cheers, Jean-Michel ---(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] pga3 Beta 1 Release
Dave Page wrote: This entire directory tree is being rsync'd to ftp.postgresql.org/pub/pgadmin3 (and therefore the PostgreSQL mirror system as well) on a 6 hourly basis. Hi Dave, should this URL be the primary place for users who wants to try the software ? Or should this still be something on www.pgadmin.org/xxx ? Thanks, Raphaël ---(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] Debian package patch
It is better with the file attached :) Cheers, Raphaël Dear all, Debian packages for beta 1 are currently building, I will surely upload them this morning. Can one of you apply this patch until the next release ? This patch fixes files in pkg/debian : - fixes debian versioning scheme - fixes debian package section : databases (does not exist in debian) - misc (section where other postgresql things can be found) - new features in make-deb to make my job easier for next releases :) Thanks, Raphaël diff -ru pgadmin3-0.9.0.orig/pkg/debian/changelog pgadmin3-0.9.0/pkg/debian/changelog --- pgadmin3-0.9.0.orig/pkg/debian/changelogSat Jul 12 21:02:59 2003 +++ pgadmin3-0.9.0/pkg/debian/changelog Thu Aug 7 01:48:35 2003 @@ -1,3 +1,10 @@ +pgadmin3 (0.9.0-0.0) unstable; urgency=low + + * First beta release of pgAdmin3 + * Fixed Debian package version scheme + + -- Raphael Enrici [EMAIL PROTECTED] Mon, 30 Jun 2003 23:25:38 +0200 + pgadmin3 (0.1.1-20030701.0) unstable; urgency=low * Corrected maintainer name / email so it points to [EMAIL PROTECTED] diff -ru pgadmin3-0.9.0.orig/pkg/debian/control pgadmin3-0.9.0/pkg/debian/control --- pgadmin3-0.9.0.orig/pkg/debian/control Sat Jul 12 21:02:59 2003 +++ pgadmin3-0.9.0/pkg/debian/control Thu Aug 7 02:28:55 2003 @@ -1,5 +1,5 @@ Source: pgadmin3 -Section: databases +Section: misc Priority: optional Maintainer: pgAdmin project [EMAIL PROTECTED] Build-Depends: debhelper ( 3.0.0), postgresql-dev, pgadmin3-libwxgtk2ud2.5-dev (= 2.5.0-20030707.1), pgadmin3-libwxgtk2ud2.5-contrib (= 2.5.0-20030707.1) diff -ru pgadmin3-0.9.0.orig/pkg/debian/make-deb pgadmin3-0.9.0/pkg/debian/make-deb --- pgadmin3-0.9.0.orig/pkg/debian/make-deb Sun Jul 20 18:54:56 2003 +++ pgadmin3-0.9.0/pkg/debian/make-deb Thu Aug 7 02:28:45 2003 @@ -12,7 +12,18 @@ # # Raphael Enrici - [EMAIL PROTECTED] - 20030720 # +#( Personal Changelog: +# 20030807: +#- Added better handling of package version to create +#- Fixed debian package version scheme +#) +# These to environment variables can be set before +# calling make-deb +DCH_RELEASE=${DCH_RELEASE:-0.0.1+makedeb} +DCH_COMMENT=${DCH_COMMENT:-make-deb release} + +# HERE=`pwd` TAR=tar usage() { @@ -46,7 +57,10 @@ done (cd pkg; $TAR cf - debian ) | tar xpf - +rm debian/make-deb chmod 755 debian/rules +pgadmin3vers=`basename $HERE | awk -F- '{print $2}'` set -x touch TODO.txt -dpkg-buildpackage ${IGNOREDEP} -b -rfakeroot \ No newline at end of file +dch --newversion $pgadmin3vers-$DCH_RELEASE $DCH_COMMENT || exit 1 +dpkg-buildpackage ${IGNOREDEP} -b -rfakeroot ---(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] Japanese display problems on Snake
Dear all, There are problems displaying japanese characters on snake.pgadmin.org and www.pgadmin.org (everything works fine on my workstation): 1) First of all, the fonts for pgAdmin web sites cannot be defined in CSS. It is better to let the OS choose the best font for display. 2) Php needs at least the following ./configure options: ./configure --without-mysql --with-pgsql=/usr/local/pgsql --with-gettext --with-apxs=/usr/local/apache/bin/apxs --with-iconv --enable-mbstring=all --enable-trans-sid --enable-wddx --enable-magic-quotes Cheers, Jean-Michel ---(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] pgAdmin III Beta 1 Released
I'm pleased to announce the release of pgAdmin III v0.9.0. This is the first beta version prior to our upcoming 1.0.0 release. pgAdmin III is an Open Source PostgreSQL database management and administration tool and is based on experiences gained in the development of pgAdmin, and the extremely popular pgAdmin II. pgAdmin III is written in C++ using the wxWindows (http://www.wxwindows.org) cross platform framework, and is currently supported on Windows 2000/XP/2003, Linux and FreeBSD. Patches for ports to other systems would be appreciated. It is released under the Artistic Licence. pgAdmin III allows the user to browse database objects, create, crop and modify them as allowed by PostgreSQL, view and edit data, and run arbitrary SQL queries using an extremely fast multi-threaded query tool. Connection to multiple servers at once is supported, using PostgreSQL's native libpq library. No ODBC layer is used, and connections may be SSL encrypted if required (this is automatic, based on pg_hba.conf settings). pgAdmin III has full Unicode support when built against wxWindows 2.5 (as our binary distributions are), and has been translated into a number of languages including Arabic ,Danish, German, Farsi, French, Croatian, Hungarian, Indonesian, Italian, Japanese, Norwegian, Polish, Portuguese-Brazilian, Romanian, Russian, Turkish, Chinese simplified and Chinese traditional thanks to the efforts of our volunteer translators. Both the software and website are in development still so feedback is encouraged to the [EMAIL PROTECTED] mailing list. We welcome new developers, documenters, porters and translators - if you wish to join the fun, please visit the Development or Translation pages on the website. The website can be found at: http://www.pgadmin.org/pgadmin3/ Downloads can be found at: http://www.pgadmin.org/pgadmin3/download.php Regards, Dave. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] [Fwd: problem downloading/installing pgadmin3 on Debian
Il sab, 2003-08-09 alle 11:37, Raphaël Enrici ha scritto: [...] More simply, try this : You can find the source packages or our wxWindows 2.5 by adding this line to your sources.list deb-src http://www.pgadmin.org/snapshots/linux/debian experimental/testing wxwindows-pgadmin3 And try to rebuild the wxWindows 2.5 packages : # apt-get source wxwindows-pgadmin3 # cd wxwindows-pgadmin3-2.5.0 # dpkg-buildpackage -b -us -uc We stay in touch (I'll be unreachable this afternoon but I'll have a look to my mail tonight). Hi Raphaël, I got the source for wxwindows and for pgadmin3. I recompiled everything fot powerpc and you may get the debian packages for testing/unstable here: http://eppesuigoccas.homedns.org/~giuseppe/debian/pgadmin3/ I had to change debian/control in order to build for any architecture insted of just i386. I did try pgadmin3 and it seems to be working. I like it very much. Thank you all, Giuseppe signature.asc Description: Questa parte del messaggio =?ISO-8859-1?Q?=E8?= firmata