[pgadmin-hackers] PostgreSQL service manager

2003-06-23 Thread Darko Prenosil
I wrote PostgreSQL service manager (for spoiled windows users) using
wxWindows that can query service status, start, stop and restart postmaster
service under windows(currently under cygwin, but this should work even with
native port when finished as long as service name is postmaster). I would
also like to implement it for linux, but this one I did not finished yet.
It was a litle play with wxWindows and MinGW since I saw yours choice of
tools for PgAdmin3.
Concerning the fact that PgAdmin is No.1 free Postgres GUI, I would be
glad to contribute the code If You are interseted.

Regards !


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


Re: [pgadmin-hackers] PostgreSQL service manager

2003-06-23 Thread Dave Page


 -Original Message-
 From: Darko Prenosil [mailto:[EMAIL PROTECTED] 
 Sent: 21 June 2003 22:05
 To: [EMAIL PROTECTED]
 Subject: [pgadmin-hackers] PostgreSQL service manager 
 
 
 I wrote PostgreSQL service manager (for spoiled windows 
 users) using wxWindows that can query service status, start, 
 stop and restart postmaster service under windows(currently 
 under cygwin, but this should work even with native port when 
 finished as long as service name is postmaster). I would 
 also like to implement it for linux, but this one I did not 
 finished yet.
 It was a litle play with wxWindows and MinGW since I saw 
 yours choice of tools for PgAdmin3.
 Concerning the fact that PgAdmin is No.1 free Postgres 
 GUI, I would be glad to contribute the code If You are interseted.

Hi Darko,

Thanks for the offer! Certainly I think we would like to see your code
and integrate it if possible, though it will not be included in our
first release I doubt as we are just entering feature freeze. 

On the *nix side of things incidently, I think most of the PostgreSQL
scripts have now been rewritten in C. This probably includes pg_ctl
which may provide a starting point for your code.

Regards, Dave.

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


Re: [pgadmin-hackers] Debian Packaging

2003-06-23 Thread Dave Page


 -Original Message-
 From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] 
 Sent: 23 June 2003 02:13
 To: [EMAIL PROTECTED]
 Cc: Dave Page; [EMAIL PROTECTED]; 
 [EMAIL PROTECTED]
 Subject: Re: [pgadmin-hackers] Debian Packaging
 
 
 You might check out vserver instead of UML, it has plenty of advantes 
 (including my endorsement!):
 
 http://www.solucorp.qc.ca/miscprj/s_context.hc

Hi Adam,

It looks good, but from a quick glance through the docs it looks like
all the VMs run the same distro as the host machine kinda like FreeBSD
jails. With UML, we can run instances of any distro at once and they're
all isolated.

Regards, Dave.

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


Re: [pgadmin-hackers] Debian Packaging

2003-06-23 Thread Jean-Michel POURE
On Sunday 22 June 2003 22:56, Raphal Enrici wrote:
 Jean Michel: Really interesting. Yes, mail me. I'm in the south (near
 Maresilles), but may be I'll do a jump in Paris... Or some VPC.

Marseille... you are lucky. Try:
- http://www.miti-itx.com
- http://www.highway.fr (80 HT)

I recommand buying a fanless system, like the VIA 5000 (80  HT), because it 
can run 24 hours a day. I have VIA Epia 800, but they are not fanless. After 
6 months, I may need to change the small processor fan.

All you need to add is a 128 Mb memory stick (10) and a 40Mb hard drive 
(40). This makes a complete system for 130.

These systems are incredibly fast and small. A VIA Epia 800 compiles wxGTK2 
three times faster than my old K6 533 Mhz. It is an excellent system to host 
a development environment or a small server.

Cheers,
Jean-Michel


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


[pgadmin-hackers] Segmentation fault on Red Hat 9

2003-06-23 Thread Devrim GUNDUZ

Hi,

I'm getting Segmentation fault in pgAdmin3, while clicking on Query 
Builder on Tools menu.

Os : Red Hat 9.0
System is not up2date.
Kernel :2.4.20-8

Here is the last parts of strace output:



open(/root/.icons/default/cursors/sb_h_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/root/.icons/default/index.theme, O_RDONLY) = -1 ENOENT (No such 
file or directory)
open(/usr/share/icons/default/cursors/sb_h_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/usr/share/icons/default/index.theme, O_RDONLY) = 9
fstat64(9, {st_mode=S_IFREG|0755, st_size=32, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) 
= 0x40b8f000
read(9, [Icon Theme]\nInherits=Bluecurve\n, 4096) = 32
close(9)= 0
munmap(0x40b8f000, 4096)= 0
open(/usr/share/pixmaps/default/cursors/sb_h_double_arrow, O_RDONLY) = 
-1 ENOENT (No such file or directory)
open(/root/.icons/Bluecurve/cursors/sb_h_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/root/.icons/Bluecurve/index.theme, O_RDONLY) = -1 ENOENT (No such 
file or directory)
open(/usr/share/icons/Bluecurve/cursors/sb_h_double_arrow, O_RDONLY) = 9
fstat64(9, {st_mode=S_IFREG|0644, st_size=9968, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) 
= 0x40b8f000
read(9, Xcur\20\0\0\0\0\0\1\0\3\0\0\0\2\0\375\377\30\0\0\0004\0..., 
4096) = 4096
_llseek(9, 0, [0], SEEK_SET)= 0
read(9, Xcur\20\0\0\0\0\0\1\0\3\0\0\0\2\0\375\377\30\0\0\0004\0..., 
4096) = 4096
close(9)= 0
munmap(0x40b8f000, 4096)= 0
writev(3, [{\232\10\t\0\3\t \2-\t \2.\t \2+\t \2\0\0\0\0\0\0\0\0\0..., 
1812}, {\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0..., 
1800}], 2) = 3612
open(/root/.icons/default/cursors/sb_v_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/root/.icons/default/index.theme, O_RDONLY) = -1 ENOENT (No such 
file or directory)
open(/usr/share/icons/default/cursors/sb_v_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/usr/share/icons/default/index.theme, O_RDONLY) = 9
fstat64(9, {st_mode=S_IFREG|0755, st_size=32, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) 
= 0x40b8f000
read(9, [Icon Theme]\nInherits=Bluecurve\n, 4096) = 32
close(9)= 0
munmap(0x40b8f000, 4096)= 0
open(/usr/share/pixmaps/default/cursors/sb_v_double_arrow, O_RDONLY) = 
-1 ENOENT (No such file or directory)
open(/root/.icons/Bluecurve/cursors/sb_v_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/root/.icons/Bluecurve/index.theme, O_RDONLY) = -1 ENOENT (No such 
file or directory)
open(/usr/share/icons/Bluecurve/cursors/sb_v_double_arrow, O_RDONLY) = 9
fstat64(9, {st_mode=S_IFREG|0644, st_size=9968, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) 
= 0x40b8f000
read(9, Xcur\20\0\0\0\0\0\1\0\3\0\0\0\2\0\375\377\30\0\0\0004\0..., 
4096) = 4096
_llseek(9, 0, [0], SEEK_SET)= 0
read(9, Xcur\20\0\0\0\0\0\1\0\3\0\0\0\2\0\375\377\30\0\0\0004\0..., 
4096) = 4096
close(9)= 0
munmap(0x40b8f000, 4096)= 0
brk(0)  = 0x89d9000
brk(0x89da000)  = 0x89da000
brk(0)  = 0x89da000
brk(0x89db000)  = 0x89db000
brk(0)  = 0x89db000
brk(0x89dc000)  = 0x89dc000
brk(0)  = 0x89dc000
brk(0x89dd000)  = 0x89dd000
brk(0)  = 0x89dd000
brk(0x89de000)  = 0x89de000
brk(0)  = 0x89de000
brk(0x89df000)  = 0x89df000
brk(0)  = 0x89df000
brk(0x89e)  = 0x89e
brk(0)  = 0x89e
brk(0x89e1000)  = 0x89e1000
brk(0)  = 0x89e1000
brk(0x89e2000)  = 0x89e2000
brk(0)  = 0x89e2000
brk(0x89e3000)  = 0x89e3000
brk(0)  = 0x89e3000
brk(0x89e4000)  = 0x89e4000
open(/root/.icons/default/cursors/sb_v_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/root/.icons/default/index.theme, O_RDONLY) = -1 ENOENT (No such 
file or directory)
open(/usr/share/icons/default/cursors/sb_v_double_arrow, O_RDONLY) = -1 
ENOENT (No such file or directory)
open(/usr/share/icons/default/index.theme, O_RDONLY) = 9
fstat64(9, {st_mode=S_IFREG|0755, st_size=32, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) 
= 0x40b8f000
read(9, [Icon Theme]\nInherits=Bluecurve\n, 4096) 

QuRE: [pgadmin-hackers] Segmentation fault on Red Hat 9

2003-06-23 Thread Dave Page


 -Original Message-
 From: Devrim GUNDUZ [mailto:[EMAIL PROTECTED] 
 Sent: 23 June 2003 11:02
 To: [EMAIL PROTECTED]
 Subject: [pgadmin-hackers] Segmentation fault on Red Hat 9
 
 
 
 Hi,
 
 I'm getting Segmentation fault in pgAdmin3, while clicking on Query 
 Builder on Tools menu.
 
 Os : Red Hat 9.0
 System is not up2date.
 Kernel :2.4.20-8
 
 Here is the last parts of strace output:
 

Hi Devrim,

The query builder is known to have some bugs and has been temporarily
disabled in more recent builds. There was a rumour that we are hitting a
wxWindows issue rather than something in our code.

Regards, Dave.

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


Re: [pgadmin-hackers] PostgreSQL service manager

2003-06-23 Thread Andreas Pflug
Darko Prenosil wrote:

   I wrote PostgreSQL service manager (for spoiled windows users) using
wxWindows that can query service status, start, stop and restart postmaster
service under windows(currently under cygwin, but this should work even with
native port when finished as long as service name is postmaster). I would
also like to implement it for linux, but this one I did not finished yet.
   It was a litle play with wxWindows and MinGW since I saw yours choice of
tools for PgAdmin3.
   Concerning the fact that PgAdmin is No.1 free Postgres GUI, I would be
glad to contribute the code If You are interseted.
 

Hi Darko,

thanks for your interes in pgAdmin3. If you contribute a 
dlgServerCtrl.cpp/.h/.xrc that works as property dialog for a PG_SERVER 
node, I'd certainly find the time to add this to pgAdmin3. Please try to 
check if the user has sufficient rights to start/stop/restart.

I noticed your Hungarian mail address, and I wonder if you'd like to 
contribute the Hungarian translation for pgAdmin3? It's quite easy using 
poEdit.

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


Re: [pgadmin-hackers] PostgreSQL service manager

2003-06-23 Thread Andreas Pflug
Darko Prenosil wrote:

On Monday 23 June 2003 12:50, Andreas Pflug wrote:
 

Darko Prenosil wrote:
   

  I wrote PostgreSQL service manager (for spoiled windows users) using
wxWindows that can query service status, start, stop and restart
postmaster service under windows(currently under cygwin, but this should
work even with native port when finished as long as service name is
postmaster). I would also like to implement it for linux, but this one
I did not finished yet. It was a litle play with wxWindows and MinGW
since I saw yours choice of tools for PgAdmin3.
  Concerning the fact that PgAdmin is No.1 free Postgres GUI, I would be
glad to contribute the code If You are interseted.
 

Hi Darko,

thanks for your interes in pgAdmin3. If you contribute a
dlgServerCtrl.cpp/.h/.xrc that works as property dialog for a PG_SERVER
node, I'd certainly find the time to add this to pgAdmin3. Please try to
check if the user has sufficient rights to start/stop/restart.
   

Windows service manager does that - nothing to do on form - just report SCM 
error !
 

Yes, but I meant to disable the start/stop options if privileges are not 
sufficient.

 

I noticed your Hungarian mail address, and I wonder if you'd like to
contribute the Hungarian translation for pgAdmin3? It's quite easy using
poEdit.
   

We would contribute Croatian rather than Hungarian translation if You don't 
mind :-)
HR is not Hungary(.hu), but CROATIA ! Native name for Croatia is Hrvatska and 
there where HR comes from.  

Blame on me... I should have known better, I've been to your wonderful 
country last year sailing from Split to Zadar, enjoying people, land, 
cities and food.
Please accept my deepest apologies!

Nevertheless, your language contribution certainly is welcome. We want 
to make pgAdmin3 a key to easy PostgreSQL access, and every native 
language supported enlarges the base of potential users.

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


Re: [pgadmin-hackers] PostgreSQL service manager

2003-06-23 Thread Darko Prenosil
On Monday 23 June 2003 12:50, Andreas Pflug wrote:
 Darko Prenosil wrote:
 I wrote PostgreSQL service manager (for spoiled windows users) using
 wxWindows that can query service status, start, stop and restart
  postmaster service under windows(currently under cygwin, but this should
  work even with native port when finished as long as service name is
  postmaster). I would also like to implement it for linux, but this one
  I did not finished yet. It was a litle play with wxWindows and MinGW
  since I saw yours choice of tools for PgAdmin3.
 Concerning the fact that PgAdmin is No.1 free Postgres GUI, I would be
 glad to contribute the code If You are interseted.

 Hi Darko,

 thanks for your interes in pgAdmin3. If you contribute a
 dlgServerCtrl.cpp/.h/.xrc that works as property dialog for a PG_SERVER
 node, I'd certainly find the time to add this to pgAdmin3. Please try to
 check if the user has sufficient rights to start/stop/restart.

Windows service manager does that - nothing to do on form - just report SCM 
error !


 I noticed your Hungarian mail address, and I wonder if you'd like to
 contribute the Hungarian translation for pgAdmin3? It's quite easy using
 poEdit.

We would contribute Croatian rather than Hungarian translation if You don't 
mind :-)
HR is not Hungary(.hu), but CROATIA ! Native name for Croatia is Hrvatska and 
there where HR comes from.  

Regards !


 Regards,
 Andreas


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

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


Re: [pgadmin-hackers] Debian Packaging

2003-06-23 Thread Adam H . Pendleton
Actually, you should be able to run any RPM-based distro under vserver. 
 I've gotten all the RedHats plus Mandrake to run on the same machine, 
so I know's it's *possible*.  Whether I can remember how I did it is a 
whole different story.  :-)

ahp

On Monday, Jun 23, 2003, at 03:35 US/Eastern, Dave Page wrote:



-Original Message-
From: Adam H. Pendleton [mailto:[EMAIL PROTECTED]
Sent: 23 June 2003 02:13
To: [EMAIL PROTECTED]
Cc: Dave Page; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [pgadmin-hackers] Debian Packaging
You might check out vserver instead of UML, it has plenty of advantes
(including my endorsement!):
http://www.solucorp.qc.ca/miscprj/s_context.hc
Hi Adam,

It looks good, but from a quick glance through the docs it looks like
all the VMs run the same distro as the host machine kinda like FreeBSD
jails. With UML, we can run instances of any distro at once and they're
all isolated.
Regards, Dave.



PGP.sig
Description: PGP signature


Re: [pgadmin-hackers] Debian Packaging

2003-06-23 Thread Dave Page


 -Original Message-
 From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] 
 Sent: 23 June 2003 12:53
 To: Dave Page
 Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; 
 [EMAIL PROTECTED]
 Subject: Re: [pgadmin-hackers] Debian Packaging
 
 
 Actually, you should be able to run any RPM-based distro 
 under vserver. 
   I've gotten all the RedHats plus Mandrake to run on the 
 same machine, 
 so I know's it's *possible*.  Whether I can remember how I 
 did it is a 
 whole different story.  :-)

Ahh, right. I want to get Redhat, Mandrake, Suse, Debian and Slackware
all on the same box...

Still, it looks good and will probably use fewer resources than UML.

Regards, Dave.

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

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


Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Andreas Pflug
Dave Page wrote:

Dunno, you wanted the web support for the help! If you want to remove
it, go ahead.
I invented the web help for *pgsql* help, which depends on the system in 
use, and may change while pgAdmin is still used (I'm using the 7.4 doc, 
and will always use the newest). BTW, we should drop a note in the doc 
that some pgAdmin3 options depend on the backend, and may not be 
available for older versions.

I'll recode pgAdmin help calling as soon as we have agreed where files 
should go for release installs. I'd vote to put them under the existing 
ui/lang_Country directories, parallel to *.mo, but I feel you wouldn't 
like that... Just give me your vote for a better place.
I haven't worked with HTMLWorkshop before, it's hopefully easy to import 
html files into a htmlws project at a later time. Can you do that? I 
just tried the pgadmin2 help directory under win32 and gtk2 
(wxHtmlHelpController) and it displayed nicely.

Insert of empty cols don't insert NULL any more, thus serial as any 
other column with a default value are handled now corretly.
   

Cool, thanks.

I tend to fix things so fast, that I forget they ever existed :-) 
Therefore, I didn't mention it.

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


[pgadmin-hackers] Mandrake 9.1 pgAdmin3 snapshots available under RPM/SRPM format

2003-06-23 Thread Jean-Michel POURE
Dear all,

pgAdmin3 binary snapshots built under the Mandrake 9.1 distribution are now 
available for download at http://www.pgadmin.org/snapshots/linux/mandrake91/.

Please note this is only beta quality and not intended for any purpose, except 
testing and debugging. Do not use them in a production environment.

Best regards,
Jean-Michel


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


[pgadmin-hackers] Needed steps for translation (pt_BR)

2003-06-23 Thread Jean-Michel POURE
Dear Angelo,

Thanks for your proposal to translate into Brazilian. To start a new 
translation in Portuguese-Brazilian, you can follow these steps:

- Register on [EMAIL PROTECTED] mailing list and declare/confirm 
yourself as a translator. This can be done visiting 
http://www.pgadmin.org/pgadmin2.php?ContentID=4.

- Install poEdit translation software from http://poedit.sourceforge.net. 
poEdit works both under Win32 and GNU/Linux.

- Checkout pgAdmin3 from CVS. Information can be read at 
http://www.pgadmin.org/pgadmin2.php?ContentID=7

- Create an empty folder in src/ui/ with the locale name of your language 
(pt_BR). Copy pgadmin3.pot file to src/ui/pt_BR/pgadmin.po.

- Translate the po file and send it to us. Translations are integrated in CVS 
and published as seperate packages when possible.

Do not hesitate to get back to us for any question.

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Andreas Pflug
Dave Page wrote:

Yeah, that's been on my mind as well. The problem is, how do you specify
a higher location that will still allow web versions to work? Or do you propose 
junking web versions of the app docs and searching for them
using a similar algorithm to that used to find xrcs?
 

What do we need web versions for? Help files are tied to the app just as 
dlg resources are.

BTW, did you get a chance to look at the row insert bug I mentioned in
the edit grid?
Insert of empty cols don't insert NULL any more, thus serial as any 
other column with a default value are handled now corretly.

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


Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Jean-Michel POURE
On Monday 23 June 2003 18:26, Andreas Pflug wrote:
 I'd vote to put them under the existing
 ui/lang_Country directories, parallel to *.mo, but I feel you wouldn't
 like that... Just give me your vote for a better place.

Maybe docs/lang_Country is easier to maintain because you will be able to ls 
-l docs and see how many docs are translated... 

We will deliver .mo files and documentation in the same packages, like :
- http://www.pgadmin.org/snapshots/linux/redhat9/RPMS
- http://www.pgadmin.org/snapshots/linux/mandrake91/RPMS

Are you able to switch back to English when a French page does not exist?

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Dave Page


 -Original Message-
 From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
 Sent: 23 June 2003 16:35
 To: Dave Page
 Cc: [EMAIL PROTECTED]
 Subject: Re: pgAdmin3 doc location
 
 
 Dave Page wrote:
 
 Yeah, that's been on my mind as well. The problem is, how do you 
 specify a higher location that will still allow web versions 
 to work? 
 Or do you propose junking web versions of the app docs and searching 
 for them using a similar algorithm to that used to find xrcs?
   
 
 What do we need web versions for? Help files are tied to the 
 app just as 
 dlg resources are.

Dunno, you wanted the web support for the help! If you want to remove
it, go ahead.

 BTW, did you get a chance to look at the row insert bug I 
 mentioned in 
 the edit grid?
 
 Insert of empty cols don't insert NULL any more, thus serial as any 
 other column with a default value are handled now corretly.

Cool, thanks.

Regards, Dave.

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


Re: [pgadmin-hackers] pga2: fix and add

2003-06-23 Thread frank_lupo

Hi Dave,
 Can I have the fixes only please - we're in beta so no new code rightnow.
Ok, but I have new code to add. 

 I was also going to email you to suggest a Beta 2 release. 
Yes, good idea.

 I also want to avoid pga2  pga3 releasing together. Any objections?
No .
I must suspend the development the pgadmin2?


Bye !!
Frank Lupo (Wolf) !!

   /\_ _/\
   \ o o /
--ooo-ooo---

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


Email.it, the professional e-mail, gratis per te: clicca qui 

Sponsor:
Non hai ancora aperto Conto Arancio? Allora clicca qui.
Clicca qui 

[pgadmin-hackers] Impossible to compile from CVS

2003-06-23 Thread Jean-Michel POURE
Cheers, Jean-Michel
*
g++ -DDATA_DIR=\/usr/share/pgadmin3/\ -Wall -g -I./include/ -I -Wall -g -O0  
-L/usr/lib -L/usr/lib -o pgAdmin3  pgAdmin3.o pgConn.o pgSet.o pgAggregate.o 
pgCast.o pgCheck.o pgCollection.o pgColumn.o pgConstraints.o pgConversion.o 
pgDatabase.o pgDomain.o pgForeignKey.o pgFunction.o pgGroup.o pgIndex.o 
pgIndexConstraint.o pgLanguage.o pgObject.o pgOperator.o pgOperatorClass.o 
pgRule.o pgSchema.o pgSequence.o pgServer.o pgTable.o pgTrigger.o pgType.o 
pgUser.o pgView.o pgDatatype.o ctlSQLBox.o ctlSQLResult.o frmExport.o 
dlgAddTableView.o events.o frmAbout.o frmChildTableViewFrame.o frmConnect.o 
frmMain.o frmOptions.o frmPassword.o frmQuery.o frmQueryBuilder.o frmHelp.o 
frmQBJoin.o frmSplash.o frmVacuum.o frmEditGrid.o dlgProperty.o dlgUser.o 
dlgGroup.o dlgDatabase.o dlgLanguage.o dlgSchema.o dlgDomain.o dlgTable.o 
dlgColumn.o dlgIndex.o dlgFunction.o dlgView.o dlgRule.o dlgOperator.o 
dlgAggregate.o dlgCast.o dlgConversion.o dlgIndexConstraint.o dlgForeignKey.o 
dlgSequence.o dlgTrigger.o dlgType.o dlgCheck.o frmStatus.o misc.o 
sysLogger.o sysSettings.o  -lssl -lcrypto /usr/lib/libpq.a -lcrypt 
/usr/lib/libwx_gtk2ud_stc-2.5.a /usr/lib/libwx_gtk2ud_xrc-2.5.a  -pthread
/usr/lib/libwx_gtk2ud-2.5.a -Wl,--export-dynamic -pthread -lgtk-x11-2.0 
-lgdk-x11-2.0 -latk-1.0 -lgdk_pixbuf-2.0 -lm -lpangoxft-1.0 -lpangox-1.0 
-lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -ldl -lgthread-2.0 -lglib-2.0 -lpng 
-ljpeg -ltiff -lz -Wl,--export-dynamic -lpangoft2-1.0 -lpango-1.0 
-lgobject-2.0 -lgmodule-2.0 -ldl -lglib-2.0 -lm
frmHelp.o(.gnu.linkonce.d._ZTV13ctlHelpWindow+0x210):/usr/local/include/wx/gtk/bitmap.h:69:
 
référence indéfinie vers « wxHtmlWindow::OnDraw(wxDC) »
dlgOperator.o(.text+0xcb0): In function `dlgOperator::Go(bool)':
ui/dlgOperator.cpp:104: référence indéfinie vers « 
dlgTypeProperty::AddType(wxString const, unsigned long, wxString)»
dlgOperator.o(.text+0xd79):ui/dlgOperator.cpp:105: référence indéfinie vers « 
dlgTypeProperty::AddType(wxString const, unsigned long, wxString)»
dlgOperator.o(.text+0x111c):ui/dlgOperator.cpp:139: référence indéfinie vers « 
dlgTypeProperty::AddType(wxString const, unsigned long, wxString)»
dlgOperator.o(.text+0x1420): In function 
`dlgOperator::CreateObject(pgCollection*)':
ui/dlgOperator.cpp:151: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgOperator.o(.text+0x147b):ui/dlgOperator.cpp:151: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgOperator.o(.text+0x2328): In function 
`dlgOperator::OnChangeType(wxNotifyEvent)':
ui/dlgOperator.cpp:218: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgOperator.o(.text+0x241f):ui/dlgOperator.cpp:224: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgOperator.o(.text+0x2af6):ui/dlgOperator.cpp:256: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgOperator.o(.text+0x2c64):ui/dlgOperator.cpp:265: encore plus de références 
indéfinies suivent vers « dlgTypeProperty::GetTypeOid(int)   »
dlgOperator.o(.text+0x39cd): In function `dlgOperator::GetSql()':
ui/dlgOperator.cpp:333: référence indéfinie vers « 
dlgTypeProperty::GetQuotedTypename(int)   »
dlgOperator.o(.text+0x3abc):ui/dlgOperator.cpp:334: référence indéfinie vers « 
dlgTypeProperty::GetQuotedTypename(int)   »
dlgAggregate.o(.text+0xaa5): In function `dlgAggregate::Go(bool)':
ui/dlgAggregate.cpp:95: référence indéfinie vers « 
dlgTypeProperty::AddType(wxString const, unsigned long, wxString)»
dlgAggregate.o(.text+0x1361): In function 
`dlgAggregate::OnChangeType(wxNotifyEvent)':
ui/dlgAggregate.cpp:150: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgAggregate.o(.text+0x13c0):ui/dlgAggregate.cpp:150: référence indéfinie vers 
« dlgTypeProperty::GetTypeOid(int)   »
dlgAggregate.o(.text+0x1422):ui/dlgAggregate.cpp:150: référence indéfinie vers 
« dlgTypeProperty::GetTypeOid(int)   »
dlgAggregate.o(.text+0x1dac):ui/dlgAggregate.cpp:178: référence indéfinie vers 
« dlgTypeProperty::GetTypeOid(int)   »
dlgAggregate.o(.text+0x2585): In function `dlgAggregate::GetSql()':
ui/dlgAggregate.cpp:216: référence indéfinie vers « 
dlgTypeProperty::GetQuotedTypename(int)   »
dlgAggregate.o(.text+0x2640):ui/dlgAggregate.cpp:216: référence indéfinie vers 
« dlgTypeProperty::GetQuotedTypename(int)   »
dlgCast.o(.text+0x878): In function `dlgCast::Go(bool)':
ui/dlgCast.cpp:80: référence indéfinie vers « 
dlgTypeProperty::AddType(wxString const, unsigned long, wxString)»
dlgCast.o(.text+0x92c):ui/dlgCast.cpp:81: référence indéfinie vers « 
dlgTypeProperty::AddType(wxString const, unsigned long, wxString)»
dlgCast.o(.text+0xba9): In function `dlgCast::CreateObject(pgCollection*)':
ui/dlgCast.cpp:101: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgCast.o(.text+0xc04):ui/dlgCast.cpp:101: référence indéfinie vers « 
dlgTypeProperty::GetTypeOid(int)   »
dlgCast.o(.text+0x142f): In function 

Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Dave Page


 -Original Message-
 From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
 Sent: 23 June 2003 16:09
 To: Dave Page
 Cc: [EMAIL PROTECTED]
 Subject: pgAdmin3 doc location
 
 
 Hi Dave,
 I've seen you just added options-tab doc under en_US/*.html.
 I wanted to comment on doc location before, just forgot to do it. I 
 think making the location for application documentation doesn't make 
 sense, because each version of the binary should be packed with the 
 exact matching doc version. Therefore, only one version is 
 needed. On the other side, if the doc location is well-known 
 to us, we could 
 easily switch directories to the best matching language version 
 (fall-back language will be of course en_US). Additionally, 
 if we switch 
 to a different format (e.g. HTML workstop) to support search 
 and index, 
 upgrading the setting wouldn't be possible anyway.

Yeah, that's been on my mind as well. The problem is, how do you specify
a higher location that will still allow web versions to work? Or do you
propose junking web versions of the app docs and searching for them
using a similar algorithm to that used to find xrcs?

BTW, did you get a chance to look at the row insert bug I mentioned in
the edit grid?

Regards, Dave.

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[pgadmin-hackers] Japanese translation

2003-06-23 Thread Jean-Michel POURE
Dear Hiroshi,

Thank you very much for your translation. The files have been published on 
CVS. Separate RPMs are being built with your Japanese translation.

Are you aware of a Japanese documentation of PostgreSQL? If there is one, we 
could well integrate it in pgAdmin3 + language packages...

Cheers,
Jean-Michel


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


[pgadmin-hackers] RPM packages + language files

2003-06-23 Thread Jean-Michel POURE
Dear all,

I uploaded new RedHat9 RPMS packages to 
http://www.pgadmin.org/snapshots/linux/redhat9/RPMS.

We now have seperate additional RPMs for translations:
- pgadmin3-0.1.1-20030623.i386.rpm

- pgadmin3-i18N-de_DE-0.1.1-20030623.i386.rpm
- pgadmin3-i18N-fr_FR-0.1.1-20030623.i386.rpm
- pgadmin3-i18N-ja_JP-0.1.1-20030623.i386.rpm

Presently, only German, French and Japanese are supported.

I though is would be better to have separate packages for downloading stats 
and future inclusion of translated documentation.

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] pgAdmin3 doc location

2003-06-23 Thread Andreas Pflug
Hi Dave,
I've seen you just added options-tab doc under en_US/*.html.
I wanted to comment on doc location before, just forgot to do it. I 
think making the location for application documentation doesn't make 
sense, because each version of the binary should be packed with the 
exact matching doc version. Therefore, only one version is needed.
On the other side, if the doc location is well-known to us, we could 
easily switch directories to the best matching language version 
(fall-back language will be of course en_US). Additionally, if we switch 
to a different format (e.g. HTML workstop) to support search and index, 
upgrading the setting wouldn't be possible anyway.

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


Re: [pgadmin-hackers] Japanese translation

2003-06-23 Thread Andreas Pflug
Jean-Michel POURE wrote:

Dear Hiroshi,

Thank you very much for your translation. The files have been published on 
CVS. Separate RPMs are being built with your Japanese translation.

Very good work, thanks. In the meantime, some 17 strings have been added 
(new dialog: export data). Hiroshi, if you download the newest 
pgAdmin3.pot from cvs, you easily can merge the new strings into the 
existing translation file using the Catalog/Update from pot file.

Are you aware of a Japanese documentation of PostgreSQL? If there is one, we 
could well integrate it in pgAdmin3 + language packages...

I'd prefer not to include more pgsql docs into the pgAdmin distribution, 
but merely give the user hints where to obtain the latest. We might well 
be stressed too much to keep up with that for all languages.

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


Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Andreas Pflug
Jean-Michel POURE wrote:

Maybe docs/lang_Country is easier to maintain because you will be able to ls 
-l docs and see how many docs are translated... 

Dave?

We will deliver .mo files and documentation in the same packages, like :
- http://www.pgadmin.org/snapshots/linux/redhat9/RPMS
- http://www.pgadmin.org/snapshots/linux/mandrake91/RPMS
Are you able to switch back to English when a French page does not exist?

No, because after the root file for help is located, the help controller 
will handle all stuff itself, it's merely a big structured single 
document. There are no side entries. Partial translation won't work, all 
or nothing. It's only the application help (contents) that will be 
translatable, the pgsql doc is external. Of course, the user might point 
to an external site that's providing translated pgsql doc, hopefully all 
page names are identical

Regards,
Andreas


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Dave Page
It's rumoured that Andreas Pflug once said:
 Dave Page wrote:

Dunno, you wanted the web support for the help! If you want to remove
it, go ahead.

 I invented the web help for *pgsql* help, which depends on the system
 in  use, and may change while pgAdmin is still used (I'm using the 7.4
 doc,  and will always use the newest). BTW, we should drop a note in
 the doc  that some pgAdmin3 options depend on the backend, and may not
 be
 available for older versions.

Yeah, I know - I'm just messin with ya! Seriously though, we need to be
careful about what docs *we* use, and what we say other people should use.
We will never release pgAdmin for an unreleased version of PostgreSQL
(even if it's in feature freeze) - catalogues etc. can change even at the
last minute. We should be sure we absolutely know what versions we are
coding for and make pgAdmin behave appropriately (not that we haven't been
afaik).
 I'll recode pgAdmin help calling as soon as we have agreed where files
 should go for release installs. I'd vote to put them under the existing
  ui/lang_Country directories, parallel to *.mo, but I feel you wouldn't
  like that... Just give me your vote for a better place.

I think share/doc/lang_country in parallel with share/ui/lang_country.
That's where I put them now iirc.
 I haven't worked with HTMLWorkshop before, it's hopefully easy to
 import  html files into a htmlws project at a later time. Can you do
 that? I  just tried the pgadmin2 help directory under win32 and gtk2
 (wxHtmlHelpController) and it displayed nicely.

Oh right, OK. In that case I'll take a look. Building a chm from htmls is
no problem. Dunno how you reference individual pages though...
 I tend to fix things so fast, that I forget they ever existed :-)
 Therefore, I didn't mention it.

:-)

Regards, Dave



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


Re: [pgadmin-hackers] Japanese translation

2003-06-23 Thread Dave Page
It's rumoured that Andreas Pflug once said:
 Jean-Michel POURE wrote:

 I'd prefer not to include more pgsql docs into the pgAdmin
 distribution,  but merely give the user hints where to obtain the
 latest. We might well  be stressed too much to keep up with that for
 all languages.

Agreed. As far as I know the only translations are being done by a
publisher in Germany anyway - no-one ever really translated them before as
they are so big, and change so often during the dev cycle. I did have
email from Peter Eisentraut about the German ones though, so when we add
them to www.postgresql.org we can add a note to our docs telling the users
where to find them.


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [pgadmin-hackers] pgAdmin3 doc location

2003-06-23 Thread Andreas Pflug
Dave Page wrote:

Oh right, OK. In that case I'll take a look. Building a chm from htmls is
no problem. Dunno how you reference individual pages though...
Not chm, just the hhp, hhc and hhk file and their subfolders. I haven't 
been deeper into this, but we seem to need this source level 
(alternatively, this can be put into a zip file).

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


Re: [pgadmin-hackers] Japanese translation

2003-06-23 Thread Hiroshi Saito
 Jean-Michel POURE wrote:

 Dear Hiroshi,
 
 Thank you very much for your translation. The files have been published
on
 CVS. Separate RPMs are being built with your Japanese translation.
 
 Very good work, thanks. In the meantime, some 17 strings have been added
 (new dialog: export data). Hiroshi, if you download the newest
 pgAdmin3.pot from cvs, you easily can merge the new strings into the
 existing translation file using the Catalog/Update from pot file.


Thank you.
I have this work continued.

 
 Are you aware of a Japanese documentation of PostgreSQL? If there is one,
we
 could well integrate it in pgAdmin3 + language packages...
 
 I'd prefer not to include more pgsql docs into the pgAdmin distribution,
 but merely give the user hints where to obtain the latest. We might well
 be stressed too much to keep up with that for all languages.

 Regards,
 Andreas

It agrees.
Because there is renewal of the revision and the information,
it thinks that it is good to be the guidance of URL.
If it says about Japan, a translation is being done in the sectional meeting
of
http://www.potgresql.jp which I belong to.
Of course, it can follow from http://www.postgresql.org/

regards,
Hiroshi-Saito


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


[pgadmin-hackers] gettext template for pgadmin3

2003-06-23 Thread Howard Bagcat
anyone,

Just want to ask is there any .pot for pgadmin3? I'm thinking of creating a
Filipino/Tagalog translation. I'm new to poEdit but I guess hardwork will paid
off. :)

Hiroshi, mind if you could share your idea how you come up with your pgadmin3 jp
version? I mean the translation procedure and all that.

Thanks.

Cheers, Howard.

Sulat @MU v.2.2 (Fresh) 
...
An extended module for MUWeb4 Project of Howard R. Bagcat
Powered by GNU General Public License softwares.

http://my.mu.edu.ph - a personalized portal is soon to come.



---(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