Re: [pgadmin-hackers] wx status

2004-07-05 Thread Jean-Michel POURE
 Yes, I'd like to get that one sorted. Anyone wanna post me an iBook to
 play with? :-)

Dear Dave,

No need to buy an iBook. You can use the http://pearpc.sourceforge.net PowerPC 
emulator under GNU/Linux. Or wait for QEMU PowerPC support end of this month.

By the way, for other testings under x86, you can visit 
http://www.freeoszoo.org and download a QEMU installer.

Enjoy!

Kind regards,
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] [pgadmin-support] pgAdmin3 doesn't work after

2004-06-10 Thread Jean-Michel POURE
Le jeudi 10 Juin 2004 19:12, Adam H. Pendleton a écrit :
 Did you use a binary package of wxWidgets or did you re-build that
 package on FC2 before you build pgAdmin3?

Dear Adam,

Did you try building wx RPMs using the wx custom script? Last time I used the 
script (nearly one year ago, a decade in computing!), the script was of good 
quality. This is quite a pitty that they do not release RPMs more often. 

Cheers,
Jean-Michel

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[pgadmin-hackers] RPM packages news and questions

2004-06-09 Thread Jean-Michel POURE
 Other people reported that packages for mandrake 8.2 were running well
 on Suse 9.0.
 Please, try them before trying a (long) rebuild.
 BTW you can find SRPMS for wxwindows^H^H^HWidgets here:
 http://pgadmin.postgresql.org/snapshots/wxwindows/SRPMS/

Dear friends,

Some news about building RPMs for pgAdmin III:

I am now using Qemu, the free-sofware equivalent of VMware (in fact Qemu is 
much more as it will soon emulate a PPC suitable for MacOsX).

Qemu is becoming usable very quickly and offers 25% speed of a native system, 
which is fairly enough to build RPMs.

From my point of view, the following platforms (possibly with the help of 
other packagers, any help welcome) should be targeted:

- Fefora Core 2
- Fefora Core 1
- RedHat 9

- Mandrake 10 final edition
- Mandrake 9.2
- Mandrake 9.1

- SuSE 9.1
- SuSE 9.0
- SuSE 8.2

Do you need other platforms?

Will we need to release a set of wxWhatever RPMs?

Are we still building staticly (I would prefer to avoid conflicts with 
possible wxAnything packages provided with recent distros, if any)?

( Looking back, it may have been a better choice to choose a plain Gtk2 + 
gtkmm framework. At least, pgAdmin III would now run under Win32, GNU/Linux 
and MacOsX without problem. Just my 0.02 euros).

Cheers,
Jean-Michel

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] Smoother PostgreSQL icons

2004-04-26 Thread Jean-Michel POURE
Le dimanche 25 Avril 2004 19:30, Andreas Pflug a écrit :
 These images look better on a white background, unfortunately on a
 colored background (e.g. win32 desktop) the smoothing algorithm causes
 an ugly white edge. This problem was the reason why I made them
 full-color. With smoothing, a gradual transparency would be needed, I
 believe icons can't do that. Any idea?

Dear Andreas,

Nice and good looking icons. Maybe you can apply a gray smoothing in the 
background.

To achieve this, you can duplicate the layer, apply gaussian blur, make it 20% 
transparent and move the resulting layer to the background. As I do not run 
MS Windows, I cannot garantee results under Win32, just a thought...

Cheers,
Jean-Michel

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] Translation Tables for Current and Website

2004-04-12 Thread Jean-Michel POURE
Le dimanche 11 Avril 2004 22:39, Serguei Mokhov a écrit :
 It would be cool to have two more translation status tables at [1].
 One for the current dev. version of pgAgmin, and the other one for
 the website.

Agreed.

 I just wanted to move on with the website translation, but [1] only
 has a link to the pgadmin3_website.pot ... thus, to continue existing
 translation I need to pull the CVS, which I can't do all the time
 depending where I am.

The existing po files for the website can be downloaded from:
http://developer.pgadmin.org/pgadmin3/locale

From there, you can download the pot and po files, updated from CVS.

 The idea is similar to what Peter E. did in [2]. As a quick fix, one
 could simply provide nearly direct links to the web interface to CVS.

Peter website is very nice and well designed.

Cheers,
Jean-Michel Pouré

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[pgadmin-hackers] On-line demonstration

2004-04-09 Thread Jean-Michel POURE
Dear all,

What about adding this very small banner on the web site:

!-- Online demo FFII --
a href=http://demo.ffii.org/;
img src=http://demo.ffii.org/banner.php?i=1; border=0 alt=NO to software 
patents - come to brussels on 14 april height=60 width=468 /
/a

Cheers,
Jean-Michel

---(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] Protest against software patents

2004-04-07 Thread Jean-Michel POURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

 Yes, I do mind. What proff do you have of these 'covert' actions?

Dear Dave,

No, I am not a secret agent of the FFII
:)

The protest is organized by the FFII:
http://wiki.ael.be/index.php/Demo14and15april

I intended to protest in Brussels myself, but as my wife is pregnant I have to 
stay home with her. The baby is nearly coming.

My personal opinion is that if we do not fight for our liberties, even if our 
action is insignificant, we will one day stop to be free. Liberty is not here 
forever. Just my ¤ 0.02.

So, about this homepage question, do we set up a potest homepage or not?
If you do not like the idea because pgAdmin is hosted by your company, I can 
understand that. Not problem.

By the way, the Queen is visiting France this week. She speaks French nearly 
fluently. The media seem to like her very much.

Cheers,
Jean-Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAc8dOextoHHj2YFMRAg22AKCWZoqFu5UoDjoSB61d8eLp6KMfeACgzImE
SZ23s3CKomfBE91T8fZbKeU=
=9QYz
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] Protest against software patents

2004-04-07 Thread Jean-Michel POURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Le mercredi 7 Avril 2004 15:35, Dave Page a écrit :
 OK, but let's not use the wording on the example site you gave - try
 something a little less inflammatory than accusations of 'covert'
 actions etc. Please post your proposal for us to review before it goes
 live...

OK, I understand now. Don't have time right now, will post the text tonight.
Cheers, Jean-Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAdARgextoHHj2YFMRAo33AJ49GyxYPbs4BcwKW1OfTJeEYCjA1QCfZjW9
3mO7J9xu3AVMBAApdG4SVts=
=pggN
-END PGP SIGNATURE-

---(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] developer.pgadmin.org down

2004-04-06 Thread Jean-Michel POURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Le mardi 6 Avril 2004 09:23, Dave Page a écrit :
 Looks OK from here:
 [EMAIL PROTECTED]:~# uptime
  07:21:56  up 4 days, 17:48,  1 user,  load average: 0.00, 0.00, 0.00

OK, I connected with SSH: ps -A | grep httpd
Apache is not running. Cheers, Jean-Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAcmPAextoHHj2YFMRAh2UAJ9++9Bf+MhmUFrNOT7ZTyeVjiHWhQCfe3v1
8XtDxoLgM4RIzdk7LoepzFw=
=4tkf
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 8: explain analyze is your friend


[pgadmin-hackers] Protest against software patents

2004-04-06 Thread Jean-Michel POURE
Dear friends,

Do you mind if we add this homepage on pgAdmin website:
http://gambas.sourceforge.net (I mean a similar page).

By the way, Gambas is an incredible Basic environment for GNU/Linux.

Cheers,
Jean-Michel

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[pgadmin-hackers] Feedback about registration of pgAdmin of Freeware/Shareware sites

2004-03-26 Thread Jean-Michel POURE
Dear friends,

Some feedback about the registration of pgAdmin III
on freeware/shareware sites:

1) Visibility

pgAdmin was registered manualy on 60 sites.

Thanks to the PAD file (http://www.pgadmin.org/pgadmin3/cnt/pgadmin3.xml), 
pgAdmin is slowly being published on shareware sites automatically.

Examples:
http://www.fileheaven.com/pgAdmin-III-for-PostgreSQL/download/12418.htm
http://downloads.verzamelgids.nl/
etc...

As a result, if you connect to Google and enter 'pgadmin',
you can notice 49 pages of answers. 

2) Impact

The impact of shareware sites is not clear. Very few of them publish 
downloading statistics. Only the most interesting sites publish information.

Example:
http://telecharger.01net.com/windows/Programmation/base_de_donne/fiches/28430.html
50 downloads / week

3) Strategy

These figures are relatively low compared to the impact of the inclusion of 
pgAdmin III in Debian or in the main GNU/Linux distributions. We should be 
looking very hard in these directions... (they have millions of users).

Still, if you visit a freeware / shareware site with good downloading 
statistics, do not hesitate to register pgAdmin III.

Cheers,
Jean-Michel




---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[pgadmin-hackers] Compilation farm status

2004-03-25 Thread Jean-Michel POURE
Dear all,

Some news about pgAdmin RPM packages...

Thanks to Qemu (http://fabrice.bellard.free.fr/qemu), I am now able to run 
virtual PCs installed with various GNU/Linux systems (starting with SuSE 8.2, 
Mandrake 9.1 and RedHat 9.0).

Qemu is able to compile pgAdmin III in two hours. The first SuSE 8.2 packages 
are being uploaded to pgAdmin web site. Other packages will follow.

If you are interested in Qemu, I published a gallery of images there: 
http://www.morphix.org/modules/xoopsgallery/view_album.php?set_albumName=album31page=1

Also, I try to test and install various OSs, with a summary on this wiki:
http://am.xs4all.nl/phpwiki/index.php/Qemu

Cheers,
Jean-Michel

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] wxWidgets?

2004-02-23 Thread Jean-Michel POURE
 There was harsh discussion about the openness of that project, and I
 wasn't the quitest about that. I suggested to rename to wxJulian, but he
 decided to use wxWidgets(Yes this doesn't read as 'the community elected
 that name')

wxWidget is part of the secret code which allows the Queen to buy a hot 
pizza and get it delivered by 007 in person.  The first w means small, the 
second W means hot pizza.

wxJulian is already the code which triggers the lauch of nuclear missiles. 
By not choosing it, Julian saved the world and we should be greateful to him.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] Feedback from users

2004-02-11 Thread Jean-Michel POURE
Le Mercredi 11 Février 2004 16:53, Ângelo Marcos Rigo a écrit :
 I am just passing some features request from some
 users here in Brasil.

Dear Ângelo,

pgDesigner is a very promissing application to design PostgreSQL tables: 
http://www.hardgeus.com/projects/pgdesigner/

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[pgadmin-hackers] PAD file

2004-02-10 Thread Jean-Michel POURE
Dear all,

Just a reminder for pgAdmin III next release :

according to http://www.padspec.org/padfaq.php, the PAD file should be 
included in the software zip file.

Also, I am currenty submitting pgAdmin PAD file to 
http://www.asp-shareware.org/pad/addpad.asp

Currently, MSSQL Server returns an error code: one of the field is too long 
and may be truncated. I have to check the lengh of each description. After 
submission, the PAD will be updated automatically every two weeks or so.

Will drop an email when done. 

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings



Re: [pgadmin-hackers] pgAdmin III description in PAD file

2004-02-10 Thread Jean-Michel POURE
Le Mardi 10 Février 2004 16:55, Dave Page a écrit :
 'centre' please. I speak the Queen's English, not American :-)

I did not realiZe it, but let's go for pounds and inches.
:)


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [pgadmin-hackers] pgAdmin III description in PAD file

2004-02-10 Thread Jean-Michel POURE
Le Mardi 10 Février 2004 16:55, Dave Page a écrit :
 - Not sure about: PostgreSQL free administration interface. What about
 PostgreSQL administration and development centre?

Dear Dave, Andreas and all,

I commited the proposed changes to CVS.
Can we validate the following text:

Char_Desc_45
  Administration Centre for PostgreSQL
/Char_Desc_45

Char_Desc_80
Administration Centre for the PostgreSQL database, free for any use
/Char_Desc_80

Char_Desc_250
Administration Centre for the PostgreSQL database, free for any use. 
Includes a graphical administration interface, an SQL query tool, a 
procedural code editor and much more. Designed to answer the needs of all 
users.
/Char_Desc_250

Char_Desc_450
Administration Centre for the PostgreSQL database, free for any use. Includes 
a graphical administration interface, an SQL query tool, a procedural code 
editor and much more. br/pgAdmin III is designed to answer the needs of all 
users, from writing simple SQL queries to developing complex databases. 
Available in more than 30 languages and for several operating systems.
/Char_Desc_450

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] website translation..

2004-02-06 Thread Jean-Michel POURE
Le Vendredi 6 Février 2004 09:46, andrej misovic a écrit :
 I want to translate web into my lang,
 but I can't find .po file with the original strings..,
 should me send a link?
 have a nice day!

Thanks for your help. The link is:
http://www.pgadmin.org/pgadmin3/locale/pgadmin3_website.pot

Cheers, JM


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] Automatic registration on Downloading sites

2004-02-06 Thread Jean-Michel POURE
Le Vendredi 6 Février 2004 11:52, Andreas Pflug a écrit :
 Probably no problem, I can't recall any W2K+ specific calls.

And what about Unicode?
Cheers, Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[pgadmin-hackers] Automatic registration on Downloading sites using a PAD file

2004-02-05 Thread Jean-Michel POURE
Dear friends,

Just a quick note to say that a common XML standard, called PAD format, 
enables automatic registration/updates on downloading sites.

The specifications of PAD can be found here:
http://www.asp-shareware.org/pad

If you enter pgadmin on http://www.asp-shareware.org/pad/padlib.asp and 
click Search, you will find EMS PostgreSQL Manager. Smart, hum? Now, 
enter mysql and postgresql...

Thanks to PAD, it should be easy to spead pgAdmin III on downloading sites.

A preview of pgAdmin III PAD file can be found here: 
http://pgadmin.postgresql.org/pgadmin3/cnt/pgadmin3.xml

There are a very few obligations: one of them is that it is required to point 
directly to installer files (.zip), which means in our case choose the most 
five largest mirrors in the PostgreSQL list.

By the way, the PAD file includes language information. So, if all of you 
could update the web site translation from the translation page, this would 
be a big plus. The links:

http://developer.pgadmin.org/pgadmin3/locale/af_ZA/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/de_DE/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/es_ES/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/fa_IR/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/id_ID/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/ja_JP/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/ru_RU/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/tr_TR/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/zh_CN/LC_MESSAGES/pgadmin3_website.po
http://developer.pgadmin.org/pgadmin3/locale/zh_TW/LC_MESSAGES/pgadmin3_website.po

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] Automatic registration on Downloading sites using a PAD file

2004-02-05 Thread Jean-Michel POURE
Le Jeudi 5 Février 2004 22:50, Andreas Pflug a écrit :
 Two things I noticed:
 - It's powerfuL, not ..fuLL (is there more Dave?)
 - missing keyword: pgadmin pgadmin3, maybe also pg-admin

Thanks. I also updated the .pot file.
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] Licence disclaimer

2004-02-05 Thread Jean-Michel POURE
Dear all,

I added a disclaimer in the licence:
http://developer.pgadmin.org/pgadmin3/cnt/licence.txt

Can we agree on these modifications?

Cheers,
Jean-Michel
**
An updated licence agreement can be downloaded from 
http://pgadmin.postgresql.org/pgadmin3/cnt/licence.txt

Last update: Friday 6 February 2004

BY INSTALLING OR DISTRIBUTING PGADMIN SOFTWARE, YOU AGREE WITH THE FOLLOWING 
DISCLAIMER:

BECAUSE PGADMIN IS FREE SOFTWARE MOSTLY DEVELOPED AS A HOBBY DURING SPARE 
TIME, IT WAS NOT FULLY TESTED AND THUS MAY CONTAIN BUGS OR OTHER DAMAGING 
PROGRAMS. USE AT YOUR OWN RISK. TO THE EXTENT OF APPLICABLE LAW, PGADMIN TEAM 
MEMBERS, PROGRAMMERS AND WEB SITES DISTRIBUTING PGADMIN CANNOT BE HELD LIABLE 
UNDER ANY CIRCUMSTANCES FOR DAMAGE TO HARDWARE OR SOFTWARE, LOST DATA, OR 
OTHER DIRECT OR INDIRECT DAMAGE RESULTING FROM THE USE OF THIS SOFTWARE - IN 
COUNTRIES WHERE THIS CLAUSE CANNOT APPLY, PGADMIN MEMBERS, PROGRAMMERS AND 
WEB SITES DISTRIBUTING PGADMIN CANNOT BE HELD LIABLE FOR MORE THAN ONE EURO 
FOR THE TOTAL DOMAGE.

IF YOU DO NOT AGREE TO THESE CONDITIONS, YOU ARE NOT PERMITTED TO USE OR 
FURTHER DISTRIBUTE THIS SOFTWARE.

Then the Artistic text...
**


---(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 installer name under Windows

2004-02-04 Thread Jean-Michel POURE
Dear Dave,

Given the large number of sites where pgAdmin will be registered, it would be 
better to provide the latest pgadmin installer for Windows under the same 
name (=no versioning). Some sites recommend this.

Example:
pgadmin3.zip (or whatever).

This shall not stop us from also providing the normal installer 
pgadmin3-1_0_2.zip

What do you think? 

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] pgAdmin installer name under Windows

2004-02-04 Thread Jean-Michel POURE
Le Mercredi 4 Février 2004 11:03, Dave Page a écrit :
 No problem, just add a symlink to the current version.

Interesting. After replication, do FTP servers support simlinks?
We should try to see what happens.

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 web site issues

2004-02-03 Thread Jean-Michel POURE
Dear friends,

Just a quick note about the latest modifications on the web site:

1) On the download page, packages are now presented by distribution (Debian, 
Slackware, etc...) with direct access from the menu. Some sites require this 
feature to simplify dowloads.

2) Short description of pgAdmin on the homepage. This description is also 
available in the Advocacy page.

Any comments are welcome. Do not update the translation yet. The impact of 
changes is very minimal (30 strings). We need to validate the changes 
first...

Next week, I would like to propose an updated design:
- unique navigation bar on the left (like Raphaël proposed),
- more simple layout without indent (this will ease reading and RTL).

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [pgadmin-hackers] pgAdmin3 in BSD ports...

2004-02-03 Thread Jean-Michel POURE
Le Mardi 3 Février 2004 12:37, Dave Page a écrit :
 Did anyone know pgAdmin 3 was in the BSD ports collection?
 http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/pgadmin3/

What wxGTK2 version are they using? Andreas patched version?
Cheers, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[pgadmin-hackers] Web site in Afrikaans and Spanish

2004-01-29 Thread Jean-Michel POURE
Dear Friends,

Just a quick note to thank the new pgAdmin web translators:
Petri Jooste (Afrikaans) and Miguel González Castaños (Spanish).

The Afrikaans translation will be available after sync.

Best regards,
Jean-Michel Pouré



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[pgadmin-hackers] Avaibility dates of Windows and MacOsX versions

2004-01-28 Thread Jean-Michel POURE
Dear friends,

For information, do some of you have any idea of a planned avaibility of the 
PostgreSQL server Windows port (a simple guess would suffice, I know there 
are no central planning except Bruce tracking page and the hacker list).

Also, do you know if the next stable release of wxGTK-2.5.1 will be able to 
compile in Unicode mode under MacOsX 10.3? is there a chance to see pgAdmin 
III running under MacOsX 10.3 soon?

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[pgadmin-hackers] Downloading mirrors

2004-01-27 Thread Jean-Michel POURE
Dear Dave and all,

Are downloading mirrors down?
http://www.pgadmin.org/pgadmin3/download.php

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[pgadmin-hackers] PostgreSQL installation CD based on Morphix

2004-01-22 Thread Jean-Michel POURE
Dear friends,

In the past, there were several discussions in order to find suitable answers 
for MS Windows users willing to install and run PostgreSQL.

Some of you suggested that users should install GNU/Linux over Windows. Not 
so easy for the basic MySQL or Ms Windows user, who need technical 
assistance ... and fear to destroy their machine.

Therefore, I would like to draw some attention on the Morphix CD project from  
http://sourceforge.net/projects/morphix.

Morphix is an auto-bootable Debian GNU/Linux distribution based on Knoppix.

What makes Morphix different is that the project has several graphical 
installers and wizards in preparation (written in plain C, using GTK-2 
libraries and Glade-2) ... which could possibly be used to install GNU/Linux 
and PostgreSQL tools over MS Windows.

You can download a preview CD of Morphix from this address:
http://prdownloads.sourceforge.net/morphix/MorphixCombined-Gnome-0.4-1.iso?download

Except for the installer itself, the wizards are not yet available in the main 
Morphix CD. To have a look at them, you will need to checkout from CVS 
(http://cvs.sourceforge.net/viewcvs.py/morphix) and open the files in 
Glade-2.

I also made some screenshots here:

- morphixinstaller: once Morphix has booted in demo mode, you can use this 
wizard to install Morphix on the disk. Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step1.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step2.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step3.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step4.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step5.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step6.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step7.png

- isomorphgui: graphical distribution maker (select the requested packages for 
your distribution and burn the ISO). Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_1.png
http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_2.png

- partitionmorpher: resize partitions on the fly (GTK-2 interface to 
libparted). Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_1.png
http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_2.png

IMHO opinion, there is a need to study the Morphix project in more details.

Morphix could be a possible solution to the MS Windows migration problems. It 
probably involves 50 times less work than migrating PostgreSQL to MS Windows 
(and is a complete different project except for the fact that it could well 
bring as much new users to PostgreSQL than a native Win port and is less 
risky).

The possible steps for such a project could be (just a guess):

1) Validate Morphixinstaller, isomorphgui and partitionmorpher wizards. These 
wizards are still in early stages of development. They are developed by one 
person, who would probably like to receive some help.

2) Create a wizard for PostgreSQL post-installation steps using GTK-2 and 
Glade-2: configuration of hosts and authentication, tuning and optimization 
of various parameters (Mainly a graphical interface to pg_hba.conf and 
postgresql.conf).

3) Gather all known PostgreSQL related Debian packages, including pgAdmin III, 
PhpPgAdmin, as well as PHP, Apache and report tools (and much more) and burn 
Morphix-PostgreSQL CDs.

There could be a light PostgreSQL CD as well as a complete PostgreSQL CD.

4) Create a single website in 30 languages (http://installer.postgresql.org?) 
dedicated to releasing the installation CD.

Based on the pgAdmin experience, there could well be more than 50.000 
downloads every month, out of which 70% would be migrating from MS Windows to 
GNU/Linux.

Comments and ideas are welcome. I would like to help anyone interested in 
becoming the lead of such a project.

Best regards,
Jean-Michel Pouré




---(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] Connecting to cvs.pgadmin.org

2004-01-20 Thread Jean-Michel POURE
Le Mardi 20 Janvier 2004 09:20, Dave Page a écrit :
 Dodgy CVSROOT in one directory - fixed now. Is it supposed to be in a
 different font btw?

Thanks, I am checking the font...
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] pgAdmin web site reaching one million hits in December

2004-01-20 Thread Jean-Michel POURE
Dear friends,

Just a quick note to indicate that pgAdmin III website reached one million 
hits in December 2003.

More statistics can be viewed on:
http://www.pgadmin.org/stats/webalizer

To my surprise, 25 percents of hits came from the Russian Federation.

Are there specific PostgreSQL events in the Russian Federation explaining this 
figure? Do you have any idea Sergei? This may help us understand how to 
promote PostgreSQL and pgAdmin.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[pgadmin-hackers] Connecting to cvs.pgadmin.org

2004-01-19 Thread Jean-Michel POURE
Dear Dave and all,

pgAdmin.org has a DNS problem...

The secondary DNS record of pgadmin.org is pointing to ZoneEdit.com. But it 
does not work as exprected. I re-connected to ZoneEdit to ask that 
pgadmin.org account be a secondary DNS.

Now that pgAdmin master DNS is down tonight, the secondary DNS is pointing to 
a casino. I hope everything will be back to normal tomorrow.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] pgAdmin3 tl_PH translation (Partial)

2003-12-09 Thread Jean-Michel POURE
Le Mardi 09 Décembre 2003 08:14, Howard Bagcat a écrit :
 Attached are the .mo and .po tl_PH translation files. The said translation
 is on its partial stage.

Dear Howard,

Thank you very much for your partial delivery. It was published to CVS. For 
information, does Tagalog happen to be close to English? I noticed some 
translations like Save as... remained in English.

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] Lithuanian translation files

2003-12-09 Thread Jean-Michel POURE
Le Mardi 09 Décembre 2003 08:32, linas jankauskas a écrit :
 Please find attached two files for a lithuanian translation.
 I hope to finish  this until the end of week, but you must notice, that
 not all SQL terms can be translated to lithuanian without losing  of its
 meaning. F.E. all of my colleagues knows, what View means, but nobody
 recognizes this term, if it's translated. This is  the same problem,
 which I have observed in Latvian  translation progress.

Thank you very much for this partial delivery. It was published to CVS today.

Translating SQL software is always a very special case. Because users need to 
be able to write the SQL queries themselves, it is recommanded to preserve 
words like View, Triggers, etc... unless the word in your language is 
quite close or widely accepted.

For example, in French, I kept Vue for View. On the converse, I kept the 
English word for Trigger.

About shortcuts: the recommanded way is to keep the same shortcut letters, 
otherwise drop them (unless you test them in the application, but you will 
never be sure not to break something somewhere).

Regards... Jean-Michel


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[pgadmin-hackers] pgAdmin3 connection problem

2003-12-07 Thread Jean-Michel POURE
Le Samedi 06 Décembre 2003 17:53, Ossama Khayat a écrit :
 pg_hba.conf

Dear Ossama,

Sorry for the delay. 

1) Make sure that the two files pg_hba.conf and postgresql.conf were saved 
under postgres user names, not root. Also, after modifying each setting, 
run /etc/init.d/postgresql restart.

2) For debugging connection, the original setting in pg_hba.conf is better:

local   all all trust
hostall all 127.0.0.1 255.255.255.255   trust

Then, try to connect under postgresql user using a trusted connection. It 
should work, otherwise we have a big problem.

3) Ultimately, turn PostgreSQL server logging on to see what happens.

In postgresql.conf, under user postgres, turn:
syslog = 2
silent_mode = false
log_connections = true

This will write connection information to /var/log/messages
On my system:

Dec  7 10:27:15 station postgres[3746]: [2-1] LOG:  connection received: 
host=127.0.0.1 port=32830
Dec  7 10:27:15 station postgres[3746]: [3-1] LOG:  connection authorized: 
user=postgres database=template1
Dec  7 10:27:16 station postgres[3748]: [2-1] LOG:  connection received: 
host=127.0.0.1 port=32831
Dec  7 10:27:16 station postgres[3748]: [3-1] LOG:  connection authorized: 
user=postgres database=

This will give us the required information.
Cheers, Jean-Michel


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] help with translation..

2003-12-06 Thread Jean-Michel POURE
 so if you can, you should write me short explanation
 of trigger, and cast..

Dear Andrej,

Translating words which belong to the SQL syntax is always hard.

The words Trigger and Cast are part of the SQL syntax CREATE CAST and 
CREATE TRIGGER.  Unless there is a clear and usual translation for these 
words in your language (it is not the case in French), it is recommanded to 
keep the English words Trigger and Cast, so that users can remember the 
SQL syntax.

cast = type conversion from one type to another
See http://developer.postgresql.org/docs/postgres/sql-createcast.html

trigger = action running upon modification/deletion/creation of a row
See http://developer.postgresql.org/docs/postgres/sql-createtrigger.html

Do not hesitate to send me the detailed list of your questions and I will try 
to answer them.

Dear Linas: are you still working on the Lithuanian translation, shall we keep 
your name on the registered list?

Cheers,
Jean-Michel


---(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] Website RTL support

2003-12-03 Thread Jean-Michel POURE
Le Mardi 02 Décembre 2003 18:40, Ossama Khayat a écrit :
 I tried that before, and now again. It gives:
 Connection refused.
 Still, if i use: psql test
 it logs me in.

Dear Ossama,

Can you send me your /var/lib/pgsql/data/pg_hba.conf and /var/lib/pgsql/data/
postgresql.conf. Then, we can discuss using instant messaging...

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] Website RTL support

2003-12-02 Thread Jean-Michel POURE
Le Lundi 01 Décembre 2003 23:53, Ossama Khayat a écrit :
 You should remove all occurences of 'unicode-bidi:
 bidi-override', because it makes _all_ text appear
 from RTL which is wrong. As you see, even English text
 (LTR) is displayed as RTL and it's totally wrong.
 Using the 'direction: rtl' is enough.

Dear Ossama and Abbas,

I brooded this over during the night and came to the same conclusion... The 
lang tag should be defined to 'en' for English text and 'fa' for Persian. 
Direction:rtl makes it for RTL languages, not English.

Andreas and Dave: Ossama nearly completed the Arabic translation. That's a 
very good news for pgAdmin!!!

Now, Ossama needs support as he cannot connect to the server locally with 
pgAdmin3, only with pgsql which works well. We modified the postgresql.conf 
and pg_hba.conf entries, nothing happens.

sknaht ! Bye, Jean-Michel


---(end of broadcast)---
TIP 8: explain analyze is your friend


[pgadmin-hackers] pgAdmin3 orphaned translations

2003-12-02 Thread Jean-Michel POURE
Dear pgAdmin translators,

We would be very happy to receive news the following on-going translations:
ca_ES Catalan
de_CH German (Switzerland)
gu_IN Gujarati
hi_IN Hindi
is_IS Icelandic
lt_LT Lithuanian
sd_IN Sindhi
te_IN Telugu
tl_PH Filipino/Tagalog
uk_UA Ukrainian
ur_PK Urdu
vi_VN Vietnamese

In the next days, we will update the list of translations in progress.
http://www.pgadmin.org/pgadmin3/translation.php

If you wish to keep your name registered on this page, please send an email to 
[EMAIL PROTECTED] with a planned delivery date and a partial 
delivery.

Otherwise, we will remove your name within the next two days to allow other 
translators to register.

Do not hesitate to contact us for any question regarding terminology, pgAdmin 
strings or poEdit. We will do our best to support you during the translation 
process.

Best regards,
Jean-Michel


---(end of broadcast)---
TIP 8: explain analyze is your friend


[pgadmin-hackers] Website RTL support

2003-12-01 Thread Jean-Michel POURE
Dear Abbas,

After our last discussion, I implemented RTL support on the Web site. This 
will allow you to read the Persian translation in the right direction! It may 
also be used for Arabic display too...

There is now a seperate CSS style sheet for RTL languages, which was modified 
in consequence. I did not find any easier way to arrive to a result. 

There are still problems when mixing English and Persian text together. For 
example, the Translation page is broken (in Persian only). But there may be 
here and there other problems.

When you have time, could you have a quick look at the site on
http://www.pgadmin.org and report problems? 

Also, do you know any experienced developer with good knowledge in RTL 
support. This would help, I am a little bit lost with dual-text display 
(translated and non-translated).

A copy of this email is being sent to Ossama Khayat [EMAIL PROTECTED] in 
case he can give some advice.

Thanks for your help,
Best regards, 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] pgAdmin web site translated into 11 languages

2003-12-01 Thread Jean-Michel POURE
Dear all,

Sorry, I was busy with work and web site RTL and could not answer before.

 - A good short description is missing, just two sentences before Latest
 news starts.

Feel free to submit anything. The interest of a short description is that it 
can be registered on search engines.

 - Change Log references CVS HEAD, while we should show the trunk's
 CHANGELOG.txt

Does it mean we need two changelogs: one for stable, one for snapshots?

 - We should fix up pgAdmin3 naming. pgAdmin3 is just for internal use;
 for all public purposes we should stick to pgAdmin III rigorously.
 Unfortunately, this fix will break all translations.

OK, but what happens when pgAdmin 3.1 comes along?

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] pgAdmin translation

2003-12-01 Thread Jean-Michel POURE
Le Lundi 1 Décembre 2003 03:46, Ossama Khayat a écrit :
 The initial translation of the .po file downloaded
 from
 http://www.pgadmin.org/cvsroot/pgadmin3/src/ui/ar_SA/pgadmin3.po
 is ready. I'll mail it privately and review the file
 for completeness today Insha'Allah.

Dear Ossama.

Thank you very much for pgAdmin III translation update into Arabic. Your name 
was added to the translator list for Arabic.

This email is CCed to the previous translator Motaz Abuthiab 
(mailto:[EMAIL PROTECTED]). Dear Motaz, do you agree to hand over the 
translation to Ossama? Maybe you can work together on further updates.

I am writing you a seperate e-mail about technical questions asked.

Best regards,
Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] pgadmin3 1.0.1 RPMS for FC1

2003-11-27 Thread Jean-Michel POURE
Le Jeudi 27 Novembre 2003 18:25, Devrim GUNDUZ a écrit :
 Hi,
 I realized that we don't have RPMS built for FC1 on ftp repository.
 I've built them and uploaded to snake under /snapshots/linux/FC1/
 Could someone please move them to FTP repository?
 Regards,

Done. Cheers, Jean-Michel


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[pgadmin-hackers] pgAdmin web site translated into 11 languages

2003-11-27 Thread Jean-Michel POURE
Dear friends,

Just a short message to thank Andrej [EMAIL PROTECTED] for translating pgAdmin 
web site into Russian. His work can be previewed here:

http://snake.pgadmin.org/pgadmin3/index.php?locale=ru_RU

For translating pgAdmin website into your national language,
you only need to download and translate the following file:

http://www.pgadmin.org/pgadmin3/locale/pgadmin3_website.pot

If you have time, we would appreciate that you register pgAdmin web site in 
your country on search engines. Please use the address pointing at your 
language:

English : http://www.pgadmin.org

German: http://www.pgadmin.org/pgadmin3/index.php?locale=de_DE
Farsi: http://www.pgadmin.org/pgadmin3/index.php?locale=fa_IR
French: http://www.pgadmin.org/pgadmin3/index.php?locale=fr_FR
Indonesian: http://www.pgadmin.org/pgadmin3/index.php?locale=id_ID
German: http://www.pgadmin.org/pgadmin3/index.php?locale=de_DE
Japanese : http://www.pgadmin.org/pgadmin3/index.php?locale=ja_JP
Russian : http://www.pgadmin.org/pgadmin3/index.php?locale=ru_RU
Turkish : http://www.pgadmin.org/pgadmin3/index.php?locale=tr_TR
Simplified Chinese : http://www.pgadmin.org/pgadmin3/index.php?locale=zh_CN
Traditional Chinese : http://www.pgadmin.org/pgadmin3/index.php?locale=zh_TW

Having more users can help us attract more talented developers and will make 
sure that pgAdmin and PostgreSQL can live long a develop freely.

Do not hesitate to help us!

Best regards,
Jean-Michel Pouré




---(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] [GENERAL] Open source data modeling tools for PostgreSQL

2003-11-27 Thread Jean-Michel POURE
Le Jeudi 27 Novembre 2003 14:53, Horák Daniel a écrit :
 I am developing DataDesigner, which tries to be an open source, DB
 independent, modelling tool. You can look at
 http://www.danny.cz/datadesigner.en.html, SourceForge project is at
 http://sf.net/projects/dbdesign
 I think it could be useful to share at least ideas or code of pgdesigner
 (the schema screenshot looks very good) and my DataDesigner ;-)

Dear Daniel,

All this seems very interesting. Doors are wide open at pgAdmin for John and 
you to implement a powerfull data designer and distribute it in bundle with 
pgAdmin.

Andreas and Dave have plans to release a pgAdmin suite including several 
applications (administration, designer, etc...). Each application would stay 
independant if needed.

This way, we could reach a large number of potential users under GNU/Linux, 
Win32, FreeBSD and soon MacOSX, SunOS.

If you are interested, please visit http://www.pgadmin.org. I cross-post 
pgAdmin mailing list in order to keep the address of your project in mind.

Best regards,
Jean-Michel Pouré



---(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] Segfault on latest snapshot

2003-11-24 Thread Jean-Michel POURE
Le Lundi 24 Novembre 2003 16:07, Devrim GUNDUZ a écrit :
 After rebuilding latest snapshot on FC1, I installed and run pgadmin3. I
 get a segfault while trying to add a user by right-clicking Users/New
 Object/New User.

I have the same problem under Debian.
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] pgAdmin3 packages for RedHat Fedora RC1

2003-11-24 Thread Jean-Michel POURE
Dear friends,

Just a quick note to say that Devrim is now building daily snapshots for 
Fedora RC1, the collaborative project from RedHat.

After sync, the packages will be available in the Snashot section:
http://www.pgadmin.org/pgadmin3/download.php#snapshots

Thanks Devrim!

Best regards,
Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] Build errors on Fedora, latest snapshot

2003-11-23 Thread Jean-Michel POURE
Le Dimanche 23 Novembre 2003 21:10, Adam H.Pendleton a écrit :
 Did you make any modifications to the source files before rebuilding?  
 This happens when the configure script detects a change in the
 automake/autoconf files (or the source files I suppose) files, and
 tries to re-build them.  Since configure is not distributed with the
 SRPM, this is the error you get.

What should we do then, run bootstrap before configure?
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] Problems compiling from CVS

2003-11-21 Thread Jean-Michel POURE
Le Jeudi 20 Novembre 2003 20:28, John McCawley a écrit :
 At the time I was (and still am) working on a datamodeler for postgres
 (http://www.hardgeus.com/projects/pgdesigner/).  At the time it was in
 FLTK but I became frustrated with the library, so I switched to wx.

Dear John,

Congratulations. wxDesigner seems to be marvelous. Do not hesitate to contact 
me for the translation of your application. If you wish, we could probably 
use the pgAdmin translation network: http://www.pgadmin.org/translation.php.

Cheers,
Jean-Michel Pouré


---(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] ICQ Message from pgAdmin translator Devrim in Istambul

2003-11-20 Thread Jean-Michel POURE
Dear Friends,

Devrim contacted me several minutes ago on ICQ.
Here is a copy of the chat message:

*
10:58
(10:41:06) Devrim Gündüz: Five Explosions Rock Downtown Istanbul 
1 minute ago. A new September 11...  
 
(10:59:51) Devrim Gündüz: It's impossible to tell what's going on here... 
Many dead bodies, 'body parts' around here  
*

Devrim is OK. He was not hit.

Jean-Michel Pouré


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies

2003-11-18 Thread Jean-Michel POURE
Le Lundi 17 Novembre 2003 21:55, Raphaël Enrici a écrit :
 I think Adam is right regarding dependencies, it's not usefull (and can
 get you to mistake if packages change) to specify all these
 dependencies. FYI Debian's dependencies I use are these (I cut debian
 specific things)

 Build-Depends: libgtk2.0-dev, gcc, g++, libjpeg62-dev, libpng-dev (
 1.2.0) | libpng12-dev ( 1.2.0) | libpng2-dev , libtiff3g-dev

Dear Adam, Raphaël, Andreas

With your explanations, it seems that:
- Build Time dependencies are quite limited,
- We are going to stick to wxGTK2ud.

So, I agree with you all. This is the power of the Internet, we can discuss 
and arrive to a solution pretty quickly. Thank!

Adam: I am not very familiar with conditional statements in RPM specs. Could 
you give me an example of a conditional statement in an RPM spec? I will work 
out the dependencies for other systems.

About Andreas patches: I hope that they will be integrated quite fast. I don't 
understand the logic behind all this. It seems unreal to keep a broken 
wxWindows for a long time.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies

2003-11-18 Thread Jean-Michel POURE
Le Mardi 18 Novembre 2003 14:29, Adam H. Pendleton a écrit :
 This sounds quite ominous considering that we do exactly that:
 distribute a private port of wxWindows.  Also, depending on the license
 they choose to distribute wxWindows under, could it cause problems with
 our product (i.e. GPL vs LGPL)?

Dear Adam,

I don't know. Probably not very important because the assignements are illegal 
in most European countries. 

The most important point to me is that assignments are being put on hold, not 
canceled. Which means that the members of the board are well-aware that the 
assignments are not valid in European law, but still refuse to cancel them.

Why can't they simply cancel the assignments and propose new/modified ones in 
one week or more? Everyone would probably sign back.

I am tired of all this.

Cheers, Jean-Michel



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies

2003-11-17 Thread Jean-Michel POURE
Le Lundi 17 Novembre 2003 19:44, vous avez écrit :
 I realize it's a pain, but is it not possible to work the different sets
 of BuildRequires into the spec file, using distribution-dependent
 conditional statements?

Yes, it is perfectly possible. But, there are so many-many build-time 
depencies in wxWindows. Listing them all is quite difficult.

On the other hand, the upcoming stable version of wxWindows 2.5.1 will provide 
a new set of RPMs. These new RPMs are very well designed. They include both 
buildtime and binary dependencies.

Personaly, I think it is a waste of time to invest in the wxGTK2ud direction 
when a new set of RPMs is coming along. If you think the converse, do not 
hesitate to submit a patch and I will apply it immediately. This is free 
software... You are free to do what you want...

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies

2003-11-17 Thread Jean-Michel POURE
Dear Adam,

 Really?  Am I missing something, or would this line suffice (granted,
 this is the RH line, but...):
 BuildRequires: gtk2-devel, libjpeg-devel, libpng-devel, libtiff-devel

A lot more. A least, expat-devel, pango-devel, zlib-devel, X11-foo-devel, 
iconv-devel, etc... See the list below. Under SuSE and Mandrake, many of 
these libraries have different naming schemes.

Since RPMs have automatic binary dependencies, looking at the SRPM rebuild log 
is enough for me ... All libraries should display yes or sys.

So are we going to be using the official wxWindows RPMs from now on?  
Are we going to run into any problems since we currently use a build of 
wxWindows that differs from the official build?

wxGTK-2.5.1 stable official release is not out yet. No idea when it will be 
released. The next official wx release has very designed RPM build scripts. I 
modified the scripts very slightly here: 

http://snake.pgadmin.org/jean-michel/makerpm.new

Cheers,
Jean-Michel

***

saving argument cache configarg.cache
checking for toolkit... gtk
checking for i686-pc-linux-gnu-gcc... no
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking how to run the C preprocessor... gcc -E
checking for egrep... grep -E
checking whether gcc needs -traditional... no
checking for i686-pc-linux-gnu-g++... no
checking for i686-pc-linux-gnu-c++... no
checking for i686-pc-linux-gnu-gpp... no
checking for i686-pc-linux-gnu-aCC... no
checking for i686-pc-linux-gnu-CC... no
checking for i686-pc-linux-gnu-cxx... no
checking for i686-pc-linux-gnu-cc++... no
checking for i686-pc-linux-gnu-cl... no
checking for i686-pc-linux-gnu-FCC... no
checking for i686-pc-linux-gnu-KCC... no
checking for i686-pc-linux-gnu-RCC... no
checking for i686-pc-linux-gnu-xlC_r... no
checking for i686-pc-linux-gnu-xlC... no
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking for i686-pc-linux-gnu-ranlib... no
checking for ranlib... ranlib
checking for ar... ar
checking for a BSD-compatible install... /usr/bin/install -c
checking for strip... strip
checking if make is GNU make... yes
checking whether ln -s works... yes
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for strings.h... (cached) yes
checking for stdlib.h... (cached) yes
checking malloc.h usability... yes
checking malloc.h presence... yes
checking for malloc.h... yes
checking for unistd.h... (cached) yes
checking wchar.h usability... yes
checking wchar.h presence... yes
checking for wchar.h... yes
checking fnmatch.h usability... yes
checking fnmatch.h presence... yes
checking for fnmatch.h... yes
checking for fnmatch... yes
checking langinfo.h usability... yes
checking langinfo.h presence... yes
checking for langinfo.h... yes
checking X11/Xlib.h usability... yes
checking X11/Xlib.h presence... yes
checking for X11/Xlib.h... yes
checking for X11/XKBlib.h... yes
checking for an ANSI C-conforming const... yes
checking for inline... inline
checking for char... yes
checking size of char... 1
checking for short... yes
checking size of short... 2
checking for void *... yes
checking size of void *... 4
checking for int... yes
checking size of int... 4
checking for long... yes
checking size of long... 4
checking for long long... yes
checking size of long long... 8
checking size of wchar_t... 4
checking for _FILE_OFFSET_BITS value needed for large files... 64
checking if large file support is available... yes
checking whether byte ordering is bigendian... no
checking how to run the C++ preprocessor... g++ -E
checking iostream usability... yes
checking iostream presence... yes
checking for iostream... yes
checking if C++ compiler supports bool... yes
checking if C++ compiler supports the explicit keyword... yes
checking whether the compiler supports const_cast... yes
checking for glibc 2.1 or later... yes
checking regex.h usability... yes
checking regex.h presence... yes
checking for regex.h... yes
checking for regcomp... yes
checking for zlib.h = 1.1.4... yes
checking for zlib.h... (cached) yes
checking for deflate in -lz... yes
checking for png.h  0.90... yes
checking for png.h... (cached) yes
checking for png_check_sig in -lpng... yes
checking for jpeglib.h... yes
checking for jpeg_read_header in -ljpeg... yes
checking tiffio.h usability... yes
checking tiffio.h presence... yes
checking for tiffio.h... yes

Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies

2003-11-17 Thread Jean-Michel POURE
Hi Adam,

Thanks for your explainations. The gtk-devel seems convincing. But there are 
other libraries. Feel free to submit a patch and I will integrate it 
immediately.

 What do you mean by automatic binary dependencies?  I thought that RPM
 dependencies were enforced by the Requires: line in the spec file.

If you do not write any Requires: line, RPM does it for you automatically.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[pgadmin-hackers] wxGTK2ud BuildRequires dependencies

2003-11-16 Thread Jean-Michel POURE
Dear Devrim,

Finally, I commented out the BuildRequires dependencies for wxGTK2ud in CVS.

It appears that library names needed at build time are not the same under 
RedHat, Mandrake and SuSE. So, my 'stupid' recommended way is:

rpmbuild --rebuild wxGTK2ud-2.5-.src.rpm 21 | tee  
wxGTK2ud-2.5-.log

and read the log to make sure all needed libraries display 'sys'.

Do not hesitate to send me by email the wxGTK2ud (with 'sys' libraries) and 
pgAdmin3 (S)RPMs and I will publish them in a new Fedora section. Do not 
hesitate to sign your email with OpenPGP.

By the way, would you be interested in releasing daily snapshots for Fedora?
We always need help...

Cheers,
Jean-Michel

-- 
Tel : +33(0)1 39 64 87 61
Mobile : +33 (0)6 76 88 60 29
Fax : +33(0)1 39 64 96 72
H323 phone : callto://translationforge.com
ICQ 314352474
Mailto:[EMAIL PROTECTED]
38 bld de la République
95160 MONTMORENCY
France
GNUPG Key fingerprint = AD25 3E5A 0AED B4BE 730F  6BE7 7B1B 681C 78F6 6053
GNUPG Key = http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x78F66053


public_key.asc
Description: application/pgp-keys

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] wxGTK2ud BuildRequires dependencies

2003-11-16 Thread Jean-Michel POURE
Le Dimanche 16 Novembre 2003 12:52, Devrim GUNDUZ a écrit :
 So: I'll begin building tomorrow and send the URLs to you.
 I'm glad that I found another chance to contribute the project, after
 translation.

Thanks. For sure, it is easier than sending an email. Cheers, J-Michel


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] pgAdmin 1.1.0

2003-11-14 Thread Jean-Michel POURE
Le Vendredi 14 Novembre 2003 16:28, Lafriks a écrit :
 When it will be released? :) I just want to know how much time I have
 left to do Latvian translation :)

Dear Lafriks,

I have no idea when pgAdmin3 1.1 will be released.

Nearly everyday, we try to publish binary snapshots from CVS. Whenever you 
deliver, your translations are publised in Snapshots immediately.

The snapshots are available from:
http://www.pgadmin.org/pgadmin3/download.php#snapshots

Do not hesitate to deliver a first 'raw' Latvian translation. It will give you 
some time to correct the text and make an update later on.

Best regards,
Jean-Michel Pouré


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] I need your help - Vietnamese Translation

2003-11-13 Thread Jean-Michel POURE
Le Jeudi 13 Novembre 2003 08:15, Ngoc Vu a écrit :
 I have the translated file produced by poEdit on Windows XP Professional,
 how can I test the translated file on Windows XP using PgAdmin III? I also
 have a Red Hat Linux machine.

Dear Victor,

Thanks! You can find information on the Translation page on pgAdmin web site. 
To view your translations, you can proceed as follows:

1) Download and install a pgAdmin3 snapshot which should be able to show 
Vietnamese in the language menu if the files are present.

2) Change directory to /usr/share/pgadmin3/ui (GNU/Linux) or C:\Progam Files
\pgadmin3\ui (Windows). Create an empty vi_VN inside this directory.

3) Copy the pgadmin3.mo binary file to pgadmin3/ui/vi_VN. Keep your main 
translation project somewhere else.

4) Run pgAdmin3 and select Vietnamese from the language list.

Otherwise, send me both pgadmin3.po and pgadmin3.mo files. Upon reception of 
the files, I will publish them in Snapshots and you can install the whole 
thing tomorrow.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] building pgadmin3 on rh7.3

2003-11-06 Thread Jean-Michel POURE
Le Jeudi 6 Novembre 2003 09:41, Dave Page a écrit :
 Any ideas?

Dear Andrew and Dave,

The RPMs from pgAdmin web site were build under RedHat9 and include the latest 
binary depencies. You need a recent environment to install pgAdmin3 binaries.

When building pgAdmin3 from SRPM source code, you also need a very recent 
environment. This issue must be cleared in the interest of everyone here, 
because you ar not the first person to ask for RedHat 9 packages

:)

In the following days, probably this week-end, I will try to add the needed 
build-time depencies in the SRPM. But then, it may well prove impossible to 
build under RedHat  9.

Why?

Because pgAdmin3 is based on the latest patched-version of wxWindows, which 
you can only get from CVS and that we package from time to time. Otherwise, 
pgAdmin3 would not be available at all. 

Hence, you will also need to install our latest wxWindows RPMs with pgAdmin 
patches. Therefore, you may well end up upgrading:
- tens of dynamic libraries loaded at run-time by wxWindows.
- build-time libraries for pgAdmin.

I would be glad to see pgAdmin3 running under RedHat8. If you are interested 
(which I would call you are prepared to help us because this will be a lot 
of time for you), we can work together on this issue. This will probably 
result in RH8 packages being published on our site. Your choice.

Best regards,
Jean-Michel


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[pgadmin-hackers] Jean-Michel legal information on the Wiki

2003-11-04 Thread Jean-Michel POURE
Dear all,

I thought today about the possible legal consequences of me announcing by 
error that wxWindows was started in France when I meant wxWindows received 
contributions in France. Sorry for that.

Therefore, I wrote more information on the wiki:
http://wiki.wxwindows.org/wiki.pl?The_WxWindows_Foundation

Most legal information is now there, always with my name 'Jean-Michel' in 
front of each question. Keep in mind that the information comes from me, not 
any lawyer. Therefore I always tried to answer with PROS and CONS.

I now cross-post to pgAdmin web site in case of technical problem as I 
unregistered the main wx-dev discussion list and may not reach the wx team.

Also, I would like to make public that I will never wage any legal dispute 
against any individual in the wx team. It seems pretty clear to me, I am 
doing my best to help and inform you.

My only recommendations are:
- create a foundation,
- keep away from any assignment sent to the US.

My role is now ending.

Kindest regards,
Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] Current CVS: Cursor disappears

2003-10-28 Thread Jean-Michel POURE
Le Lundi 27 Octobre 2003 22:16, Troels Arvin a crit :
 Initially, a cursor is seen, but if focus is taken away from the window
 (e.g. by using the mouse or ALT-TAB) and then returned, the cursor is
 gone. I can still write charaters in the query window, but I have to
 guess where the characters will be put.

 If focus is once again taken away from and then returned to the query
 window, then the cursor re-appears.

Dear Troels,

I can confirm this STC problem as I have exactly the same problem under Debian 
and RedHat.

Sometimes also, in the editor, after selecting text, the cursor becomes the 
following sign|_ (vertical and horizontal bar) and the display freezes. I 
have to open a seperate display and manually kill pgAdmin3. Nothing is 
written in the log.

Did anyone notice this bug too?

Best regards,
Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[pgadmin-hackers] Cannot Add user

2003-10-28 Thread Jean-Michel POURE
Dear friends,

I am using the latest pgAdmin3 snapshot with PostgreSQL 7.4 beta 5 under 
Debian. Maybe this is not a recommanded configuration as pgAdmin3 was 
compiled against an old libpq and on my station libpq3 is installed.

I cannot create a new user. The application crashes (reproducable). There is 
no special log. Can anyone reproduce the problem?

Best regards,
Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] Bug#217067: Impossible to display non-European languages

2003-10-25 Thread Jean-Michel POURE
Dear Ron,

 If pgadmin does not work with an unpatched 2.6 then you are going to
 be in a world of pain wrt to distributing it in Debian (and probably
 the other distros too, though I can't speak for them).

Of course. Please note that we never intended to get our patched version into 
Debian.

 My best recommendation would be that you get an idea (from wx-dev)
 of when people would like to see 2.6 frozen (the borland thing will
 surely be pushing this in ways the code alone might not mandate)
 and then work very hard to see that all your important patches are
 incorporated in one way or another before then.

Borland is a company. PostgreSQL is a community. I hope you prefer PostgreSQL 
to Borland. Therefore, 2.6 cannot be frozen before it incorporates Andreas 
Pflug patches, which will probably be the case sooner or later.

 The bottom line basically is that either you guys will need to fork
 wx entirely and support your own version, or work to merge your
 branch with the mainstream before the stable release is made.

We do not intend to fork wx and never will.

 Sorry, but as much as I'd love to help you guys get your app into
 the next Debian stable release, I just can't make the .debs a
 leverage point for patches that haven't been accepted into cvs yet.
 If you want them in the 2.6 debs, you're going to have to get them
 past the gauntlet of wx-dev first.

Let's wait for wxWindows to manage Unicode and aother issues. All patches are 
available for inclusion into wx main branch:

http://snake.pgadmin.org/snapshots/wxwindows/patches/

The goal of Debian is to be a world distribution. We all have the same goals: 
proper Unicode management, working Cut/Paste, etc... For example, work is 
being done by the wx team on RTL better support. Everyone is working in the 
same direction, there is no idea of a fork and we never intended so.

But, only one thing : please, publish wx26, poEdit and pgAdmin3 in Debian at 
the same time. Everyone will benefit from it.

Best regards,
Jean-Michel


---(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] Crash of the Option dialog

2003-10-24 Thread Jean-Michel POURE
Dear friends,

When opening the Option dialog, a warning message is displayed once every two 
openings (reproducable):

 /usr/include/wx/checkbox.h(70): assert !Is3State() failed: Calling 
IsChecked() doesn't make sense for a three state checkbox, Use 
Get3StateValue() instead

Please find the log attached.

Also, I don't understand why 2003-10-24 15:50:49 DEBUG  : Mailcap file /etc/
mailcap, line 199: unknown field 'xmms '%s'' for the MIME type 'audio/mpeg' 
ignored. is in the log.

Is this crash linked to a syslogd problem?

Best regards,
Jean-Michel
2003-10-24 15:50:43 INFO   : ##
2003-10-24 15:50:43 INFO   : # pgAdmin III Version 1.1.0 Devel Startup
2003-10-24 15:50:43 INFO   : ##
2003-10-24 15:50:43 INFO   : Compiled with OpenSSL 0.9.7c 30 Sep 2003
2003-10-24 15:50:43 INFO   : Creating a splash screen
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgIndexConstraint.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgAggregate.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgCast.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgCheck.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgColumn.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgConversion.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgDatabase.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgDomain.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgForeignKey.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgFunction.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgGroup.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgIndex.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmAddTableView.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgLanguage.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgOperator.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgRule.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgSchema.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgSequence.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgTable.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgTrigger.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgType.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgUser.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgView.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmMaintenance.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmConnect.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmExport.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgEditGridOptions.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmOptions.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmPassword.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmQBJoin.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgJob.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmStatus.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgSchedule.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/dlgStep.xrc
2003-10-24 15:50:43 INFO   : Loading /usr/share/pgadmin3//ui/common/frmIndexcheck.xrc
2003-10-24 15:50:43 INFO   : Using fontmetrics 9/18, 14 Point
2003-10-24 15:50:43 INFO   : Native Description 'Bitstream Vera Sans 14'
2003-10-24 15:50:43 INFO   : Draw size of 'M': w=13, h=18, descent 0, external lead 0.
2003-10-24 15:50:43 INFO   : Draw size of 'g': w=9, h=18, descent 0, external lead 0.
2003-10-24 15:50:43 INFO   : Draw size of 'Mg': w=22, h=18, descent 0, external lead 0.
2003-10-24 15:50:43 INFO   : Creating a ctlSQLBox
2003-10-24 15:50:44 INFO   : Creating a pgCollection object
2003-10-24 15:50:44 INFO   : Reloading servers...
2003-10-24 15:50:44 INFO   : Creating a pgServer object
2003-10-24 15:50:44 INFO   : Creating a pgServer object
2003-10-24 15:50:44 INFO   : Destroying a splash screen
2003-10-24 15:50:47 INFO   : Creating an options dialogue
2003-10-24 15:50:49 DEBUG  : Mailcap file /etc/mailcap, line 199: unknown field 'xmms '%s'' for the MIME type 'audio/mpeg' ignored.
2003-10-24 15:50:49 DEBUG  : Mailcap file /etc/mailcap, line 200: unknown field 'xmms '%s'' for the MIME type 'audio/mpegurl' ignored.
2003-10-24 15:50:49 DEBUG  : Mailcap file /etc/mailcap, line 201: unknown field 'xmms '%s'' for the 

[pgadmin-hackers] Font display bug under wxGTK-2.5.1

2003-10-24 Thread Jean-Michel POURE
Dear friends,

Just to notice the wxGTK-2.5.1 font bug present in pgAdmin3 is also present in 
poEdit. You can see screenshots of today's latest installations:

http://snake.pgadmin.org/jean-michel/screenshots/poedit-crop.png
http://snake.pgadmin.org/jean-michel/screenshots/pgadmin-crop.png

Do recent versions of wxWindows correct this problem?

Best regards,
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] Migration from other database systems to PostgreSQL

2003-10-24 Thread Jean-Michel POURE
Dear friends,

Because PostgreSQL is a mature database, most new PostgreSQL users are 
certainly migrating from other systems (mainly Oracle, DB2, MySQL, MS SQL, 
etc...). So, if we offer solutions for migration, we can probably boost 
pgAdmin3. This is no news...

At first, this could be only a migration of database schemas (tables, 
constraints, views, etc...). Not server-side languages like PL.

In this context, I asked a question recently on hackers about the possibility 
to create custom data types in PostgreSQL mapping Oracle data types. For 
example, I asked if it was possible to mapp Oracle nvarchar2(lenght) to 
PostgreSQL varchar(lenght).

The aswer is that it is not possible, because types like varchar(lenght) are 
hard coded into PostgreSQL parser.

So, to date, the only solution to read an Oracle ASCII dump into PostgreSQL is 
to convert the data types manually. Search nvarchar2(lenght), Replace by 
varchar(lenght).

No news ... now we come to the point.

What if I added a Migration section on pgAdmin3 web site. At first, this 
section would only list type mappings for MySQL/Oracle/DB2/MS SQL with 
PostgreSQL types, as well as any information related to the migration of 
constraints, views and default values.

In a (close?) future, this would allow pgAdmin3 to include a series of Regexp 
that would replace foreing data types with native PostgreSQL data types.

What do you think?
Best regards, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL

2003-10-24 Thread Jean-Michel POURE
Le Vendredi 24 Octobre 2003 17:04, Dave Page a écrit :
 I would like to allow some sort of source and target plugins with a
 mapping/scriptable transformation service in between, perhaps using
 embedded Python or Perl.

I would call it Advanced advance :)

How do you plan to connect to any database? Using which drivers? Is this why 
you mention ODBC? But ODBC has its own virtual  types. Is it reliable? And 
not all Oracle database have ODBC (you must pay for it). Just for 
information, can you describe in more details?

A good start might be to be able to read the dumps from Oracle, MySQL, DB2 and 
MsSQL. This would be a small revolution for PostgreSQL and would suit 90% 
needs of users. When this is achieved, and only then, you would go for more 
complex things.

I feel (but I am only an average programmer as you know) that a series of 
regexp would suffice.

Cheers, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[pgadmin-hackers] poEdit linked against latest wxGTK2.5 snapshots available for Debian

2003-10-23 Thread Jean-Michel POURE
Dear friends,

Raphaël successfully compiled poEdit against the latest wxGTK2.5 snapshot with 
Andreas PFLUG patches.

Here are some (working) screenshots:
- http://snake.pgadmin.org/jean-michel/screenshots/chinese.png
- http://snake.pgadmin.org/jean-michel/screenshots/japanese.png
- http://snake.pgadmin.org/jean-michel/screenshots/persian.png
- http://snake.pgadmin.org/jean-michel/screenshots/russian.png

To get it from pgAdmin repository (after sync tommorow):
deb http://www.pgadmin.org/snapshots/linux/debian unstable pgadmin

Enter:
apt-get update; apt-get install pgadmin3-poedit

I will try to update RedHat, Mandrake and SuSE packages too... hoping we can 
submit the packages back to Vaclav Slavik [EMAIL PROTECTED].

IMHO, poEdit has the best translation interface of all i18n softwares. It only 
lacks good Unicode support.

Best regards, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[pgadmin-hackers] pgAdmin translation in progress (14 languages)

2003-10-22 Thread Jean-Michel POURE
Dear friends and translators,

pgAdmin3 is currently being translated into 14 new languages. If possible, we 
would like to receive news from your translation. As a reminder:

- pgAdmin3 translation page:
http://www.pgadmin.org/pgadmin3/translation.php

- pgAdmin3 snapshots where your translations are publised immediately
http://www.pgadmin.org/pgadmin3/download.php#snapshots

We are highly motivated to help you on the project. Do not hesitate to get 
back to us for help. We need your contribution. So keep on the good work and 
continue translating... 

Best regards,
Jean-Michel Pouré


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] Cannot build latest CVS

2003-10-22 Thread Jean-Michel POURE
Le Mercredi 22 Octobre 2003 14:27, Troels Arvin a crit :
 I'm using wxGTK2ud-2.5-20031010.3 from
 http://snake.pgadmin.org/snapshots/wxwindows/

I am currently compiling wxGTK2ud-2.5-20031010.4. Wait a few hours before 
everything is publised. Are you working days and nights on pgAdmin3?

As you know RH packaging well, I would like to know how to disable stripping, 
which is RH default behavior. This will enable me to produce full debug RPMs. 
Any idea?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] Cannot build latest CVS

2003-10-22 Thread Jean-Michel POURE
Le Mercredi 22 Octobre 2003 15:35, Troels Arvin a crit :
 %define __strip /bin/true
Thanks, added to spec.


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] Debuging RPMs

2003-10-21 Thread Jean-Michel POURE
Le Mardi 21 Octobre 2003 15:34, Adam H. Pendleton a écrit :
 When trying to
 debug the pgadmin3 exectuable that gets installed with the RPM (this is
 on RedHat), gdb reports that there are now debug symbols in the executable.

Dear Adam,

RH9 stips off debugging symbols by default.

For consistency, I stripped Mandrake and Suse builds too using:
strip --strip-debug %{buildroot}/%{_bindir}/%{name}

Maybe I can unset the default stripping in RH and then remove this line. But 
will you be able to debug enough knowing that wxWindows is stripped too?

This is a real problem. Tell me what I should do...
Best regards, Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[pgadmin-hackers] wxWindows source tarball with patches

2003-10-20 Thread Jean-Michel POURE
Hi Dave,

If you plan to pack a patched tarball of wxWindows20031010, I would prefer the 
wxWindows-pgAdmin3-20031010.2.tar.bz2 numbering (20031010.2 like second 
release for 2001010) to unpack in wxWindows-pgAdmin3-20031010.2 folder.

I integrated the previous patches in wxGTK2ud-2.5-20031010.1 RPMs. A new 
tarball would allow me to produce wxGTK2ud-2.5-20031010.2 RPMs.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 8: explain analyze is your friend


[pgadmin-hackers] RPM build problem

2003-10-18 Thread Jean-Michel POURE
Dear friends,

I got a RPM build problem in snapshots:

checking for wxWindows... yes
configure: error: you need to install the stc package from wxWindows/contrib/
src/stc
error: Bad exit status from /var/tmp/rpm-tmp.76395 (%build)
RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.76395 (%build)

Will send you the full configure log later. I am in a hurry. Of course, wx stc 
is installed. I am using wxWindows in monolithic mode.

Cheers, Jean-Michel


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [pgadmin-hackers] SSL detection bug is back under debian...

2003-10-16 Thread Jean-Michel POURE
Le Jeudi 16 Octobre 2003 12:33, Raphal Enrici a crit :
 I can also provide one for you (I built it this morning).

This was fast! I don't need SSL, it was just a bug report. Will update 
pgAdmin3 snapshot using apt-get later.

Cheers, Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] XRC Editting

2003-10-15 Thread Jean-Michel POURE
Le Mercredi 15 Octobre 2003 16:04, Dave Page a crit :
 We definately need something as there are at least 2 systems on which it
 doesn't work well.

Three systems. See my screenshot under Debian here:
http://snake.pgadmin.org/jean-michel/shot.png

I contacted Raphal who does not have the same problem.

Cheers, Jean-Michel


---(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] Maintenance release

2003-10-14 Thread Jean-Michel POURE
Le Mardi 14 Octobre 2003 16:30, Dave Page a crit :
 OK, tarballs for Slackware, Windows and Source are on Snake.

Kool. Could you create http://snake.pgadmin.org/ftp/release/SRPMS please to 
avoid duplicates. Thanks, Jean-Michel


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] Maintenance release

2003-10-14 Thread Jean-Michel POURE
Le Mardi 14 Octobre 2003 17:02, Dave Page a crit :
  Kool. Could you create
  http://snake.pgadmin.org/ftp/release/SRPMS please to avoid
  duplicates. Thanks, Jean-Michel
 Done.

I don't have enough rights to upload the SRPM package there.
Cheers, Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[pgadmin-hackers] wxWindows 20031010 (S)RPMs available

2003-10-13 Thread Jean-Michel POURE
Dear Zvone,

The RPM packages for wxWindows 20031010 are available. You will be able to 
find the binaries on FTP as soon as it replicates, probably tuesday morning.

Adam, maybe you would like to rebuild them under RedHat  9?
Zvone, thanks for your offer to rebuild wxGTK under Suse 8.1.

You can download the source package from 
http://snake.pgadmin.org/ftp/wxwindows/SRPMS/wxGTK2ud-2.5-20031010.src.rpm.

To rebuild under Suse 8.1 download the file and enter:

rpm --rebuild wxGTK2ud-2.5-20031010.src.rpm 21 | tee  
wxGTK2ud-2.5-20031010.log

Read the log file and make sure the needed libraries are included in your 
system (if they are not, install them using the stock RPMs for your distro).

For example, under RedHat 9, the log includes:

**
Configured wxWindows 2.5.1 for `i686-pc-linux-gnu'

  Which GUI toolkit should wxWindows use? GTK
  Should wxWindows be compiled into single library?   yes
  Should wxWindows be compiled in debug mode? yes
  Should wxWindows be linked as a shared library? no
  Should wxWindows be compiled in Unicode mode?   yes
  What level of wxWindows compatibility should be enabled?
   wxWindows 2.2  no
   wxWindows 2.4  yes
  Which libraries should wxWindows use?
   jpeg   sys
   pngsys
   regex  sys
   tiff   sys
   zlib   sys
   odbc   no
   expat  sys
   libmspack  no

**

The absence of ODBC and limmspack is normal as ODBC is not supported in a 
Unicode build by default and limspack is brand new. Other libraries (jpeg, 
png, etc...) should have the 'sys' flag on.

After rebuilding, the RPMs will be saved in /usr/src/packages/RPMS/i386

Then, drop me a mail and we will find a way to upload the RPMs to Snake in a 
SuSE81 directory.

Best regards and many thanks for your help,
Jean-Michel


---(end of broadcast)---
TIP 8: explain analyze is your friend


[pgadmin-hackers] wxWindows directories merge on Snake

2003-10-13 Thread Jean-Michel POURE
Dear friends,

To avoid confusion, I did the following changes on Snake:

1) I moved my stuff into a http://snake.pgadmin.org/jean-michel directory.
Do not use the RPMs in this directory, they are mostly ***not compatible*** 
with pgAdmin3. Actually, these RPMs do not even compile!

2) http://snake.pgadmin.org/wxwindows now lists all wxWindows-pgAdmin3-* 
tarballs and patches with comments.

3) As a result, I removed the empty 
http://snake.pgadmin.org/snapshots/wxWindows

If there is a better solution, do not hesitate to apply it.

Best regards,
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] pgAdmin3 snapshot

2003-10-13 Thread Jean-Michel POURE
Dear all,

Did anyone succeed in compiling pgAdmin3 today from CVS head, using 
http://snake.pgadmin.org/wxwindows/wxWindows-pgAdmin3-20031010.tar.bz2 (with 
minolitic option)?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] wxWindows directories merge on Snake

2003-10-13 Thread Jean-Michel POURE
Hi Dave,

 /snapshots/wxwindows should contain the version and previous versions of
 wxWindows that the development team are working with (and building the
 snapshots against).

Fixed.

 /ftp/wxwindows should contain *only* the version of wxWindows that we
 release versions of pgAdmin against. The ftp directory is mirrored and
 definitely *should not* have arbitrary versions of wx under it. Please
 remove all except 20030831.

I deleted the new RPMs.

  1) I moved my stuff into a
  http://snake.pgadmin.org/jean-michel directory.
  Do not use the RPMs in this directory, they are mostly ***not
  compatible*** with pgAdmin3. Actually, these RPMs do not even compile!
 So why are they on Snake? If they're not for use with pgAdmin or don't
 compile, please delete them. There's 160Mb of space wasted there. If you
 are using that area as a working directory, please use your home directory.

Because I need some place to upload the packages. If the name jean-michel is 
confusing, I will set up a web server somewhere else. But this would be sad. 
I upload the build logs to show the wx guys their RPMs don't work. Otherwize, 
they wron't admit it.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] wxWindows directories merge on Snake

2003-10-13 Thread Jean-Michel POURE
Le Lundi 13 Octobre 2003 16:30, Dave Page a crit :
 I don't mind you using it for that, but 160Mb of logs seems excessive to
 convince people that there's a problem. What else is in there? Are you only
 uploading logs when things actually go wrong?

I deleted previous builds and will upload only daily builds from now in 
http://snake.pgadmin.org/jean-michel. Warning: do not use the RPMs from this 
directory.

wxWindows packaging scheme is extremely complicated. There are several ports 
(base, gtk, gtk2, x11, etc...) and two sets of RPMs for each port (unicode, 
non-unicode):

wx-base, wx-base-unicode
wx-gtk
wx-gtk2, wx-gtk2-unicode
wx-x11, wx-x11-unicode

Each set has 3 to 6 RPMs. There are 3 distros (RH, MKK, SUSE). This makes a 
lot of RPMs... 

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] New wx patches

2003-10-12 Thread Jean-Michel POURE
Le Dimanche 12 Octobre 2003 11:09, Dave Page a crit :
 The snapshot package has now been updated.
 Jean-Michel, can you update the RPMs to match this distro please.

I am working on it. Cheers,
Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] New wx patches

2003-10-12 Thread Jean-Michel POURE
Le Dimanche 12 Octobre 2003 19:53, Raphal Enrici a crit :
 IMHO we should not have two separate directories to keep trace of
 wxwindows-pgadmin3 sources snaphots.
 (I mean http://snake/wxwindows and http://snake/snapshots/wxWindows)
 Any good reason that we do not merge the two directories ? I think it is
 a source of confusion.

Sorry for the confusion.

http://snake.pgadmin.org/wxwindows is an experimental place for building  
wxWindows RPMs using official scripts. Unfortunately, I was not able to 
make a complete build. wxWindows always fails to compile somewhere. Tomorrow, 
I will rename the directory wx_experimental.

Maybe we should move Dave binaries and Andreas patches in 
http://snake.pgadmin.org/snapshots/wxwindows.

Cheers,
Jean-Michel



---(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] Impossible to compile pgAdmin3 snapshots

2003-10-12 Thread Jean-Michel POURE
Dear all,

I installed wxWindows 20031010 patched version. pgAdmin3 snapshots does not 
compile with an include error:

if g++ -DHAVE_CONFIG_H -I. -I. -I..  -DDATA_DIR=\/usr/share/pgadmin3/\ -Wall 
-g -I../src/include -I../src/agent/include -I -DSSL -I/usr/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/share/pgadmin3/\ -Wall -g -I../src/include 
-I../src/agent/include -I -Wall -g -O0 -MT utffile.o -MD -MP -MF 
.deps/utffile.Tpo \
  -c -o utffile.o `test -f 'utils/utffile.cpp' || echo './'`utils/utffile.cpp; 
\
then mv -f .deps/utffile.Tpo .deps/utffile.Po; \
else rm -f .deps/utffile.Tpo; exit 1; \
fi
Dans le fichier inclus à partir de utils/utffile.cpp:11:
../src/include/utffile.h:21: spécificateur de type omis pour le paramètre «
   wxFontEncoding »

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] CVS compile error

2003-10-08 Thread Jean-Michel POURE
Le Mercredi 8 Octobre 2003 09:06, Dave Page a crit :
 Could that be something to do with the lack of Unicode support on Mac?

MacOsX has built-in support for Unicode. wxMac does not. It remains to be 
added to wxMac according to Stefan. 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] wxGTK rpms

2003-10-06 Thread Jean-Michel POURE
Dear Friends,

I modified wxWindows makerpm script and uploaded a slightly revisited version 
to http://snake.pgadmin.org/wxwindows. The rest and other platforms will 
follow tonight. 

wxWindows stock RPMs are built without debug and provide **both** static and 
dynamic libraries by default.

Do you think pgAdmin3 can be build staticly without debug? This is quite easy 
to patch wxWindows SPEC files to add debug as an option. Shall I do it?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] [pgadmin-support] Bug in pgadmin III displa ying/exporting dat

2003-10-03 Thread Jean-Michel POURE
Le Vendredi 3 Octobre 2003 18:55, Godshall Michael a crit :
 So if SSL is not defined, the ssl libs may not be linked to it either.

I can remember using an old snapshot with the SSL combo. The libraries should 
be installed on the build host. What is the name of the libraries needed?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] wxWindows Upgrade

2003-10-02 Thread Jean-Michel POURE
Le Jeudi 2 Octobre 2003 12:02, Dave Page a crit :
 Both code branches of pgAdmin III have now been updated to compile
 against the 20031001 wxWindows CVS snapshot. Currently we are using an
 unpatched snapshot which you can get from the wxWindows site.

wx library names have changed:

# ls /usr/lib
libwx_baseud-2.5.a  libwx_baseud_xml-2.5.a  libwx_gtk2ud_core-2.5.a  
libwx_gtk2ud_stc-2.5.a  wx
libwx_baseud_net-2.5.a  libwx_gtk2ud_adv-2.5.a  libwx_gtk2ud_html-2.5.a  
libwx_gtk2ud_xrc-2.5.a

Could you tell me more about this new naming scheme? Is pgAdmin3 able to take 
them into account at compilation time? 

Cheers, Jean-Michel


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [pgadmin-hackers] Mac Port

2003-10-01 Thread Jean-Michel POURE
Le Mercredi 1 Octobre 2003 00:43, Adam H.Pendleton a crit :
 http://www.fmonkey.net/pgastartup.jpg

 I don't remember now how I fixed this before, so I'll have to do some
 research.  Stefan, maybe you have a quick answer (if there is such a
 thing)?  :-)

Dear Adam H. Pendleton,

Nice Macintosh. Is this a new platform? How wide is your screen? Sorry for the 
late reply because of the jet lag :)

The language list is displayed in UTF-8 because our translations are stored in 
Unicode. wxMac does not support Unicode and hence fails to display some 
languages.

If you compile pgAdmin3 without Unicode, you should be able to view pgAdmin3 
English interface. Most European languages should display (with accent 
problems). Because Unicode is based on ASCII characters, it should not break 
pgAdmin logic. Could Andreas confirm?

Dear Stefan, is there a way to use the iconv library as a wrapper to recode 
strings on the fly from Unicode to Apple format. Do you think iconv is a 
working solution to display Unicode strings in MacOs10.2 until MacOsX 10.3 is 
out?

By the way, Adam, I did not apply the patches. Could you contact me on my ICQ 
to explain more deeply what needs to be done. I would like to set up a MacOsX 
section on the development page and display the recommanded configuration 
settings.

Below is a list of known encodings supported by inconv.

Cheers,
Jean-Michel


# iconv --list
La liste suivante contient tous les jeux des codes de caractres connus. Ceci
ne signifie pas ncessairement que toutes les combinaisons de ces noms peuvent
tre utilises dans les paramtres  FROM  et  TO  des commandes. Un jeu de 
codes de
caractres peut tre affich avec diffrents noms (aliases).

 437, 500, 500V1, 850, 851, 852, 855, 856, 857, 860, 861, 862, 863, 864, 865,
  866, 866NAV, 869, 874, 904, 1026, 1046, 1047, 8859_1, 8859_2, 8859_3, 
8859_4,
  8859_5, 8859_6, 8859_7, 8859_8, 8859_9, 10646-1:1993, 10646-1:1993/UCS4,
  ANSI_X3.4-1968, ANSI_X3.4-1986, ANSI_X3.4, ANSI_X3.110-1983, ANSI_X3.110,
  ARABIC, ARABIC7, ARMSCII-8, ASCII, ASMO-708, ASMO_449, BALTIC, BIG-5,
  BIG-FIVE, BIG5-HKSCS, BIG5, BIG5HKSCS, BIGFIVE, BS_4730, CA, CN-BIG5, CN-GB,
  CN, CP-AR, CP-GR, CP-HU, CP037, CP038, CP273, CP274, CP275, CP278, CP280,
  CP281, CP282, CP284, CP285, CP290, CP297, CP367, CP420, CP423, CP424, CP437,
  CP500, CP737, CP775, CP813, CP819, CP850, CP851, CP852, CP855, CP856, CP857,
  CP860, CP861, CP862, CP863, CP864, CP865, CP866, CP866NAV, CP868, CP869,
  CP870, CP871, CP874, CP875, CP880, CP891, CP903, CP904, CP905, CP912, CP915,
  CP916, CP918, CP920, CP922, CP930, CP932, CP933, CP935, CP936, CP937, CP939,
  CP949, CP950, CP1004, CP1026, CP1046, CP1047, CP1070, CP1079, CP1081, 
CP1084,
  CP1089, CP1124, CP1125, CP1129, CP1132, CP1133, CP1160, CP1161, CP1162,
  CP1163, CP1164, CP1250, CP1251, CP1252, CP1253, CP1254, CP1255, CP1256,
  CP1257, CP1258, CP1361, CP10007, CPIBM861, CSA7-1, CSA7-2, CSASCII,
  CSA_T500-1983, CSA_T500, CSA_Z243.4-1985-1, CSA_Z243.4-1985-2,
  CSA_Z243.419851, CSA_Z243.419852, CSDECMCS, CSEBCDICATDE, CSEBCDICATDEA,
  CSEBCDICCAFR, CSEBCDICDKNO, CSEBCDICDKNOA, CSEBCDICES, CSEBCDICESA,
  CSEBCDICESS, CSEBCDICFISE, CSEBCDICFISEA, CSEBCDICFR, CSEBCDICIT, 
CSEBCDICPT,
  CSEBCDICUK, CSEBCDICUS, CSEUCKR, CSEUCPKDFMTJAPANESE, CSGB2312, CSHPROMAN8,
  CSIBM037, CSIBM038, CSIBM273, CSIBM274, CSIBM275, CSIBM277, CSIBM278,
  CSIBM280, CSIBM281, CSIBM284, CSIBM285, CSIBM290, CSIBM297, CSIBM420,
  CSIBM423, CSIBM424, CSIBM500, CSIBM851, CSIBM855, CSIBM856, CSIBM857,
  CSIBM860, CSIBM863, CSIBM864, CSIBM865, CSIBM866, CSIBM868, CSIBM869,
  CSIBM870, CSIBM871, CSIBM880, CSIBM891, CSIBM903, CSIBM904, CSIBM905,
  CSIBM918, CSIBM922, CSIBM930, CSIBM932, CSIBM933, CSIBM935, CSIBM937,
  CSIBM939, CSIBM943, CSIBM1026, CSIBM1124, CSIBM1129, CSIBM1132, CSIBM1133,
  CSIBM1160, CSIBM1161, CSIBM1163, CSIBM1164, CSIBM11621162,
  CSISO4UNITEDKINGDOM, CSISO10SWEDISH, CSISO11SWEDISHFORNAMES,
  CSISO14JISC6220RO, CSISO15ITALIAN, CSISO16PORTUGESE, CSISO17SPANISH,
  CSISO18GREEK7OLD, CSISO19LATINGREEK, CSISO21GERMAN, CSISO25FRENCH,
  CSISO27LATINGREEK1, CSISO49INIS, CSISO50INIS8, CSISO51INISCYRILLIC,
  CSISO58GB1988, CSISO60DANISHNORWEGIAN, CSISO60NORWEGIAN1, CSISO61NORWEGIAN2,
  CSISO69FRENCH, CSISO84PORTUGUESE2, CSISO85SPANISH2, CSISO86HUNGARIAN,
  CSISO88GREEK7, CSISO89ASMO449, CSISO90, CSISO92JISC62991984B, CSISO99NAPLPS,
  CSISO103T618BIT, CSISO111ECMACYRILLIC, CSISO121CANADIAN1, CSISO122CANADIAN2,
  CSISO139CSN369103, CSISO141JUSIB1002, CSISO143IECP271, CSISO150,
  CSISO150GREEKCCITT, CSISO151CUBA, CSISO153GOST1976874, CSISO646DANISH,
  CSISO2022CN, CSISO2022JP, CSISO2022JP2, CSISO2022KR, CSISO2033,
  CSISO5427CYRILLIC, CSISO5427CYRILLIC1981, CSISO5428GREEK, CSISO10367BOX,
  CSISOLATIN1, CSISOLATIN2, CSISOLATIN3, CSISOLATIN4, CSISOLATIN5, 
CSISOLATIN6,
  CSISOLATINARABIC, CSISOLATINCYRILLIC, CSISOLATINGREEK, CSISOLATINHEBREW,
  CSKOI8R, CSKSC5636, 

[pgadmin-hackers] make install icons and desktop files

2003-10-01 Thread Jean-Michel POURE
Dear Adam H.,

In the RPM spec, after make install, we install the icon and desktop file 
manually using:

cp ./src/include/images/elephant48.xpm 
%{buildroot}/%{_datadir}/%{name}/%{name}.xpm
cp ./pkg/%{name}.desktop
%{buildroot}/%{_datadir}/%{name}/%{name}.desktop

Could it be part of make install itself?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] Czech translation of pgAdmin III

2003-10-01 Thread Jean-Michel POURE
Le Lundi 29 Septembre 2003 15:04, Jean-Michel POURE a crit :
  I am sending you Czech translation (cs_CZ) of pgAdmin III. All strings
  are translated, but need some work on terminology and hot keys.

While waiting for Jan answer, the maintenance of the Czech translation was 
handed to Daniel.

Cheers, Jean-Michel


---(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] Build error under SuSE 8.2

2003-10-01 Thread Jean-Michel POURE
if g++ -DHAVE_CONFIG_H -I. -I. -I..  -DDATA_DIR=\/usr/share/pgadmin3/\ -Wall 
-g -I../src/include -I../src/agent/include -I -DSSL -I/usr/include/pgsql 
-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/share/pgadmin3/\ -Wall -g -I../src/include 
-I../src/agent/include -I -Wall -g -O0 -MT pgaStep.o -MD -MP -MF 
.deps/pgaStep.Tpo \
  -c -o pgaStep.o `test -f 'agent/pgaStep.cpp' || echo './'`agent/pgaStep.cpp; 
\
then mv .deps/pgaStep.Tpo .deps/pgaStep.Po; \
else rm -f .deps/pgaStep.Tpo; exit 1; \
fi
agent/pgaStep.cpp: In static member function `static pgObject*
   pgaStep::ReadObjects(pgaJob*, wxTreeCtrl*, const wxString)':
agent/pgaStep.cpp:100: error: ISO C++ says that `wxChar
   wxString::operator[](int) const' and `wxChar wxString::operator[](unsigned
   int)' are ambiguous even though the worst conversion for the former is
   better than the worst conversion for the latter
agent/pgaStep.cpp:110: error: ISO C++ says that `wxChar
   wxString::operator[](int) const' and `wxChar wxString::operator[](unsigned
   int)' are ambiguous even though the worst conversion for the former is
   better than the worst conversion for the latter
make[2]: *** [pgaStep.o] Error 1
make[2]: Leaving directory `/usr/src/packages/BUILD/pgadmin3-1.0.1/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/packages/BUILD/pgadmin3-1.0.1'
make: *** [all] Error 2

Cheers, Jean-Michel


---(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] Translation updates

2003-10-01 Thread Jean-Michel POURE
Dear all,

Where should we commit translation updates? REL-1_0_0_PATCHES or the main 
branch? To simplify, I would prefer the main branch only. Same as for 
translation status.

What do you prefer?
Cheers, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[pgadmin-hackers] MacOSX compilation steps

2003-10-01 Thread Jean-Michel POURE
Dear Friends,

I added information about wxWindows compilation under MacOsX on 
http://www.pgadmin.org/pgadmin3/download.php#source. It will take some time 
to replicate from snake development server.

Dear Adam H.: could you describe the needed steps for pgAdmin3 compilation? Is 
it the same as under GNU/Linux?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers]

2003-10-01 Thread Jean-Michel POURE
Le Mercredi 1 Octobre 2003 20:21, Andreas Pflug a crit :
 It's no problem storing non-UTF characters in an UNICODE database
 either, you will never notice until you try to convert.
 Misusing the database is not a good idea on the long run.

Agreed, trash my last e-mail. Cheers, Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[pgadmin-hackers] Website update against CVS

2003-09-30 Thread Jean-Michel POURE
Hi Dave,

I noticed that the website was no longer getting updated against the CVS.

Loging in Snake and trying to update the pgadmin3 directory running cvs 
update -C -P -d, here is the answer:

[EMAIL PROTECTED]:/usr/local/apache/htdocs/pgadmin3$ cvs update -C -P -d
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
(Locally modified cache_pending.txt moved to .#cache_pending.txt.1.43)
(Locally modified cache_translated.txt moved to .#cache_translated.txt.1.57)
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
cvs server: Updating .
cvs update: cannot rewrite CVS/Entries.Backup: Permission denied
cvs server: Updating cache
U cache/cache_pending.txt
cvs update: cannot open CVS/Entries.Log: Permission denied
U cache/cache_translated.txt
cvs update: cannot open CVS/Entries.Log: Permission denied
cvs server: Updating class
cvs server: Updating cnt
P cnt/cnt_download.php

Then,
[EMAIL PROTECTED]:/usr/local/apache/htdocs/pgadmin3/cnt$ ls -l
total 80
drwxr-xr-x2 dpageusers4096 Sep 28 17:26 CVS/
-rw-r--r--1 dpageusers7297 Sep 11 22:25 cnt_development.php
-rw-r--r--1 root root10874 Sep 26 17:04 cnt_download.php
-rw-r--r--1 root root 6902 Sep 26 17:04 cnt_index.php
-rw-r--r--1 root root 2779 Sep 28 17:26 cnt_mirrors.php
-rw-r--r--1 dpageusers   10429 Aug  5 18:05 cnt_screenshots.php
-rw-r--r--1 dpageusers1473 Aug 13 13:29 cnt_support.php
-rw-r--r--1 dpageusers   12084 Sep 12 12:00 cnt_translation.php
-rw-r--r--1 dpageusers7357 Sep 23 20:35 
cnt_translation_status.php
-rw-r--r--1 dpageusers5025 Aug 19 11:02 licence.txt

Seems like something wrote directly under root account without using CVS. Is 
this a cron job running under root account?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


  1   2   3   4   >