Re: [pgadmin-hackers] Preparation for 1.8

2007-04-04 Thread Hiroshi Saito

Hi.

Ok,  I do one's best:-)
more evolution the pgAdmin.!

Regards,
Hiroshi Saito

From: "Dave Page" <[EMAIL PROTECTED]>


Hi all,

Just a heads-up - I'd like to aim to be ready to go to beta by the end 
of the month, so if you have any outstanding patches or bugs, please 
post them ASAP!!


Hiroshi; for your info - I'd like to be able to start helping tidy up 
and complete the debugger after the end of next week, so if you can 
commit any major changes by then, that would be a big help. We can then 
fix any outstanding issues one at a time between us then.


Guillaume; you might want to consider updating the translations again 
and waking up the translators - there are likely to be more changes 
before we release, but I think it's probably most useful if they can get 
started as soon as possible and pickup those changes when they happen, 
rather than trying to do everything in one go.


Any other comments/thoughts/flames etc?

Thanks, Dave




---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate


[pgadmin-hackers] Two bugs

2007-04-04 Thread Robins

Hi all,

Couldn't find these two bugs in the known bugs list so am posting here.

Issue 1: When a view is changed (via SQL or any other source) and when one
tries to 'View all' the View, the column headers are blank. Refreshing the
'Views' parent twice (one when this view disappears, and the second time
when it reappears) solves the problem. Is it possible that (while the user
clicks on 'View all') ... when pgadmin notices that a view has changed, it
automatically refreshes the structure ?

Issue 2: PgAdmin has repeatedly been oddly singling out a specific function
( lets name it a) in my database to be renamed into the last used function
(lets name it b). That means, many times when PgAdmin crashes, and when I
restart, instead of finding two functions.
a(a_param1)
b(b_param1, b_param2)

Instead I find

b(a_param1)
b(b_param1, b_param2)

(and of course function a is now disappeared). One perculiar thing is that
although function b may vary depending on what i am working on while pgadmin
crashes, function a is almost always the same !!


Platform: Win XP
Language: English
Distribution: Postgresql 8.2.3
Version: 1.6.2
Debug option: Unable to do this, its a win environment and i didnt compile
this version.

If there is anything else I could provide, please do tell.

--
Robins


[pgadmin-hackers] SVN Commit by guillaume: r6175 - in trunk/pgadmin3/i18n: es_ES ko_KR tr_TR

2007-04-04 Thread svn
Author: guillaume

Date: 2007-04-04 22:14:33 + (Wed, 04 Apr 2007)

New Revision: 6175

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6175&view=rev

Log:
Automatic merge using stringmerge script.


Modified:
   trunk/pgadmin3/i18n/es_ES/pgadmin3.mo
   trunk/pgadmin3/i18n/ko_KR/pgadmin3.po
   trunk/pgadmin3/i18n/tr_TR/pgadmin3.po

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


[pgadmin-hackers] SVN Commit by guillaume: r6174 - trunk/pgadmin3/i18n/tr_TR

2007-04-04 Thread svn
Author: guillaume

Date: 2007-04-04 22:12:19 + (Wed, 04 Apr 2007)

New Revision: 6174

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6174&view=rev

Log:
Update turkish translation, per Onur Yalaz?\196?\177.



Modified:
   trunk/pgadmin3/i18n/tr_TR/pgadmin3.po

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

   http://archives.postgresql.org


[pgadmin-hackers] SVN Commit by guillaume: r6173 - branches/REL-1_6_0_PATCHES/pgadmin3/i18n/tr_TR

2007-04-04 Thread svn
Author: guillaume

Date: 2007-04-04 22:09:53 + (Wed, 04 Apr 2007)

New Revision: 6173

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6173&view=rev

Log:
Update turkish translation, per Onur Yalaz?\196?\177.



Modified:
   branches/REL-1_6_0_PATCHES/pgadmin3/i18n/tr_TR/pgadmin3.mo
   branches/REL-1_6_0_PATCHES/pgadmin3/i18n/tr_TR/pgadmin3.po

---(end of broadcast)---
TIP 1: 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] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread Guillaume Lelarge

Quan Zongliang(Gmail) a écrit :

It seems zh_CN needs some changes, too.



Done too. Thanks for telling me.

Regards.


--
Guillaume.


---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate


Re: [pgadmin-hackers] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread Guillaume Lelarge

Dave Page a écrit :

Guillaume Lelarge wrote:

Dave Page a ecrit le 04/04/2007 10:37:

[EMAIL PROTECTED] wrote:

Author: guillaume

Date: 2007-04-04 07:04:45 + (Wed, 04 Apr 2007)

New Revision: 6161

Revision summary:
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6161&view=rev

Log:
Add zh_TW translation of docs and hints, per ChaoYi Kuo.

Shouldn't there be some Makefile and pkg/win32/src/pgadmin3.wxs changes
with this?

:-)


Oops, sorry about this. I'll fix this tonight.


Thanks :-)



Done.

I hope the GUID part is correct. Can you check please ? Thanks.

Regards.


--
Guillaume.


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

  http://archives.postgresql.org


[pgadmin-hackers] SVN Commit by guillaume: r6172 - in trunk/pgadmin3: . pkg/win32/src

2007-04-04 Thread svn
Author: guillaume

Date: 2007-04-04 21:17:00 + (Wed, 04 Apr 2007)

New Revision: 6172

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6172&view=rev

Log:
Add zh_CN and zh_TW translation on build scripts.



Modified:
   trunk/pgadmin3/Makefile.am
   trunk/pgadmin3/pkg/win32/src/pgadmin3.wxs

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


[pgadmin-hackers] SVN Commit by guillaume: r6171 - in branches/REL-1_6_0_PATCHES/pgadmin3: . pkg/win32/src

2007-04-04 Thread svn
Author: guillaume

Date: 2007-04-04 21:06:19 + (Wed, 04 Apr 2007)

New Revision: 6171

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6171&view=rev

Log:
Add zh_CN and zh_TW translation on build scripts.



Modified:
   branches/REL-1_6_0_PATCHES/pgadmin3/Makefile.am
   branches/REL-1_6_0_PATCHES/pgadmin3/pkg/win32/src/pgadmin3.wxs

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


[pgadmin-hackers] Preparation for 1.8

2007-04-04 Thread Dave Page

Hi all,

Just a heads-up - I'd like to aim to be ready to go to beta by the end 
of the month, so if you have any outstanding patches or bugs, please 
post them ASAP!!


Hiroshi; for your info - I'd like to be able to start helping tidy up 
and complete the debugger after the end of next week, so if you can 
commit any major changes by then, that would be a big help. We can then 
fix any outstanding issues one at a time between us then.


Guillaume; you might want to consider updating the translations again 
and waking up the translators - there are likely to be more changes 
before we release, but I think it's probably most useful if they can get 
started as soon as possible and pickup those changes when they happen, 
rather than trying to do everything in one go.


Any other comments/thoughts/flames etc?

Thanks, Dave

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Dave Page

Florian G. Pflug wrote:

Maybe removing those libs from the output of pg_config that
we surely don't need or want (like -lpgport) is workable
alternative?


Yeah, that sounds reasonable.


I'll try to do that, and try to cleanup that part of acinclude.m4.


Thanks :-)

Regards, Dave

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Florian G. Pflug

Dave Page wrote:

Florian G. Pflug wrote:

Dave Page wrote:

Florian G. Pflug wrote:

I'm currently thinking that unconditionally adding the output
of pg_config --libs to LIBS if linking statically might
be a better approach - thoughts?

That whole section of the file seems a bit kooky to me - it does some
weird stuff on Solaris as well.

pg_config --libs does output more than we need for libpq though, so I'm
a little loathe to use it - what about just conditionally adding the
-lssl, if you can grep it form the pg_config output?

Yeah - realized that too, seconds after I mailed..
The problem with grepping for -lssl is that AFAIK some
plattforms need more than -lssl (Like -lcrypto). So
if we're going that way, we won't get rid of all that
plattform-specific uglyness in that section.

Maybe removing those libs from the output of pg_config that
we surely don't need or want (like -lpgport) is workable
alternative?


Yeah, that sounds reasonable.


I'll try to do that, and try to cleanup that part of acinclude.m4.

greetings, Florian Pflug



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


Re: [pgadmin-hackers] Debugger issues

2007-04-04 Thread Hiroshi Saito

Hi.

From: "Dave Page" <[EMAIL PROTECTED]>



Hi Hiroshi,

In case you haven't spotted these, here are a couple of issues I've
found with the debugger:

- Debugging seems to start on about line 3 of the function :-(


Ahh.. Yes, I am going for it to offer repair work with handling of a line.



- The debugger displays the parameters dialog then promptly crashes if
debugging a function with no parameters :-(


Oh, sure -- I understanding now.



Also, there are quite a lot of warnings when compiling with GCC that
need to be cleaned up - many of these are caused by images we're not
using I think.


It was made the schedule to brush up.

Thanks!

Regards,
Hiroshi Saito

---(end of broadcast)---
TIP 1: 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] Mac OS X Query Result Pane

2007-04-04 Thread Dave Page
Ketema wrote:
> I did not know how to describew this, so I included a mpg showing what
> I have noticed.  If the mpg is removed from the post I also included a
> link.
> 
> In a nut shell the result pane row header does not move with thactual
> result columns when scrolling horizontally.  when there are many
> result columns this becomes very confusing.

This appears to be a wxWidgets bug which I have reported to them:

https://sourceforge.net/tracker/index.php?func=detail&aid=1694403&group_id=9863&atid=109863

Thanks for the report.

Regards, Dave

---(end of broadcast)---
TIP 1: 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] SVN Commit by dpage: r6170 - trunk/pgadmin3

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 16:14:10 + (Wed, 04 Apr 2007)

New Revision: 6170

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6170&view=rev

Log:
Note wxGrid scrolling bug, reported by Ketema



Modified:
   trunk/pgadmin3/BUGS

---(end of broadcast)---
TIP 1: 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] Debugger integration

2007-04-04 Thread Dave Page
Florian G. Pflug wrote:
> Dave Page wrote:
>> Florian G. Pflug wrote:
>>> I'm currently thinking that unconditionally adding the output
>>> of pg_config --libs to LIBS if linking statically might
>>> be a better approach - thoughts?
>>
>> That whole section of the file seems a bit kooky to me - it does some
>> weird stuff on Solaris as well.
>>
>> pg_config --libs does output more than we need for libpq though, so I'm
>> a little loathe to use it - what about just conditionally adding the
>> -lssl, if you can grep it form the pg_config output?
> 
> Yeah - realized that too, seconds after I mailed..
> The problem with grepping for -lssl is that AFAIK some
> plattforms need more than -lssl (Like -lcrypto). So
> if we're going that way, we won't get rid of all that
> plattform-specific uglyness in that section.
> 
> Maybe removing those libs from the output of pg_config that
> we surely don't need or want (like -lpgport) is workable
> alternative?

Yeah, that sounds reasonable.

Regards, Dave

---(end of broadcast)---
TIP 1: 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] Debugger integration

2007-04-04 Thread Florian G. Pflug

Dave Page wrote:

Florian G. Pflug wrote:

I'm currently thinking that unconditionally adding the output
of pg_config --libs to LIBS if linking statically might
be a better approach - thoughts?


That whole section of the file seems a bit kooky to me - it does some
weird stuff on Solaris as well.

pg_config --libs does output more than we need for libpq though, so I'm
a little loathe to use it - what about just conditionally adding the
-lssl, if you can grep it form the pg_config output?


Yeah - realized that too, seconds after I mailed..
The problem with grepping for -lssl is that AFAIK some
plattforms need more than -lssl (Like -lcrypto). So
if we're going that way, we won't get rid of all that
plattform-specific uglyness in that section.

Maybe removing those libs from the output of pg_config that
we surely don't need or want (like -lpgport) is workable
alternative?

greetings, Florian Pflug

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


[pgadmin-hackers] SVN Commit by dpage: r6169 - in trunk/pgadmin3: . pgadmin/include/schema pgadmin/schema

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 15:50:07 + (Wed, 04 Apr 2007)

New Revision: 6169

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6169&view=rev

Log:
Display the constraint OID for index constraints, not the index OID. Add the 
index OID as a new property, per Harald.


Modified:
   trunk/pgadmin3/CHANGELOG
   trunk/pgadmin3/pgadmin/include/schema/pgIndexConstraint.h
   trunk/pgadmin3/pgadmin/schema/pgIndex.cpp
   trunk/pgadmin3/pgadmin/schema/pgIndexConstraint.cpp

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

   http://archives.postgresql.org


Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Dave Page
Florian G. Pflug wrote:
> Dave Page wrote:
>> Florian G. Pflug wrote:
>>> BTW, I've been working on an i386 binary of pgadmin3 that is statically
>>> linked.
>>> If've managed to compile static version of libxml, libxslt, wxwidgets
>>> and
>>> libpq, but configure fails for pgadmin3 because it doesn't know that
>>> it has
>>> to pass "-lssl" when linking against that static libpq. AFAIK, libtool
>>> ususally
>>> takes care of that, and provides dependency information for static libs.
>>>
>>> Neither wxwidgest nor postgres seem to create *.la files for my static
>>> libs -
>>> Does anyone know if they should - or how to deal with static linking
>>> without
>>> libtool?
>>
>> I'm missing something I guess - whilst it only links statically with wx
>> and pg, we already have --enable-static which works fine on intel and
>> ppc macs. That's the option I now force on when building an appbundle.
> 
> acinclude.m4 seems to special-case static linking on osx, and
> adds -lssl if it thinks that is needed. (I think it was me
> who added that code, but I seem to have forgotten about it.. ;-) ).
> 
> I'm currently thinking that unconditionally adding the output
> of pg_config --libs to LIBS if linking statically might
> be a better approach - thoughts?

That whole section of the file seems a bit kooky to me - it does some
weird stuff on Solaris as well.

pg_config --libs does output more than we need for libpq though, so I'm
a little loathe to use it - what about just conditionally adding the
-lssl, if you can grep it form the pg_config output?

Regards, Dave

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


Re: [pgadmin-hackers] Bug Report

2007-04-04 Thread Dave Page

Zongliang, Quan wrote:
> In pgServer.cpp, Line 752:
> 
> if (executed)
> {
> password = newVal;
> StorePassword();
> --->return false;
> }
> else
> return false;
> 
> Although the passwd had been changed successfully with "Change Password"
> dialog. "The password could not be changed!" message always popup.
> 
> Line 756 should be "return true";

Thanks, I've committed a fix for this and some related issues.

Regards, Dave


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

   http://www.postgresql.org/docs/faq


[pgadmin-hackers] SVN Commit by dpage: r6168 - in trunk/pgadmin3: . pgadmin/include/schema pgadmin/schema

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 15:21:11 + (Wed, 04 Apr 2007)

New Revision: 6168

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6168&view=rev

Log:
Ensure the password change dialog works with stored passwords.
Fix the incorrect password change confirmation, per Zongliang, Quan
Encrypt new passwords as they should be.


Modified:
   trunk/pgadmin3/CHANGELOG
   trunk/pgadmin3/pgadmin/include/schema/pgServer.h
   trunk/pgadmin3/pgadmin/schema/pgServer.cpp

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Florian G. Pflug

Dave Page wrote:

Florian G. Pflug wrote:

BTW, I've been working on an i386 binary of pgadmin3 that is statically
linked.
If've managed to compile static version of libxml, libxslt, wxwidgets and
libpq, but configure fails for pgadmin3 because it doesn't know that it has
to pass "-lssl" when linking against that static libpq. AFAIK, libtool
ususally
takes care of that, and provides dependency information for static libs.

Neither wxwidgest nor postgres seem to create *.la files for my static
libs -
Does anyone know if they should - or how to deal with static linking
without
libtool?


I'm missing something I guess - whilst it only links statically with wx
and pg, we already have --enable-static which works fine on intel and
ppc macs. That's the option I now force on when building an appbundle.


acinclude.m4 seems to special-case static linking on osx, and
adds -lssl if it thinks that is needed. (I think it was me
who added that code, but I seem to have forgotten about it.. ;-) ).

I'm currently thinking that unconditionally adding the output
of pg_config --libs to LIBS if linking statically might
be a better approach - thoughts?

greetings, Florian Pflug

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


[pgadmin-hackers] Mac OS X Query Result Pane

2007-04-04 Thread Ketema
I did not know how to describew this, so I included a mpg showing what
I have noticed.  If the mpg is removed from the post I also included a
link.

In a nut shell the result pane row header does not move with thactual
result columns when scrolling horizontally.  when there are many
result columns this becomes very confusing.

Thank You.

http://www.ketema.net/result_pane.mov


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

   http://archives.postgresql.org


[pgadmin-hackers] Debugger issues

2007-04-04 Thread Dave Page
Hi Hiroshi,

In case you haven't spotted these, here are a couple of issues I've
found with the debugger:

- Debugging seems to start on about line 3 of the function :-(

- The debugger displays the parameters dialog then promptly crashes if
debugging a function with no parameters :-(

Also, there are quite a lot of warnings when compiling with GCC that
need to be cleaned up - many of these are caused by images we're not
using I think.

Regards, Dave.

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[pgadmin-hackers] SVN Commit by dpage: r6167 - trunk/www/download

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 14:34:10 + (Wed, 04 Apr 2007)

New Revision: 6167

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6167&view=rev

Log:
Update Mac instruction, per Florian (iirc)



Modified:
   trunk/www/download/macosx.php

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[pgadmin-hackers] SVN Commit by dpage: r6166 - trunk/www/development

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 14:33:01 + (Wed, 04 Apr 2007)

New Revision: 6166

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6166&view=rev

Log:
Roadmap update



Modified:
   trunk/www/development/roadmap.php

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


[pgadmin-hackers] SVN Commit by dpage: r6165 - trunk/pgadmin3

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 14:23:29 + (Wed, 04 Apr 2007)

New Revision: 6165

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6165&view=rev

Log:
Add the Mac Command-W key issue to the bugs list



Modified:
   trunk/pgadmin3/BUGS

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


Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Dave Page
Florian G. Pflug wrote:
> Dave Page wrote:
>> The existing complete-bundle.sh code works fine, and rewrites the paths
>> to the wx libraries as expected, however the debugger crashes when run.
>> As best I can figure, this is because although the debugger has the
>> correct relative paths to the libraries, some of those (wx) libraries
>> are interdependent, and when run by the debugger executable, the
>> relative paths between them are incorrect.
> I'll look into this. One solution might be to symlink the wx libs
> into the Debugger bundle, but I hope that there is a cleaner solution.
> 
>> To resolve this until a better solution is found, I've modified the
>> build system such that static linking is forced when building an app
>> bundle. This also has the advantage of reducing the bundle size a
>> little :-)
> The only downside of this that I can see is that the pgadmin3 binary gets
> _really_ huge (about 200M or so) when statically linked against wx. My old
> powerbook G4 takes a few minutes to even open that with gdb..

So don't use --enable-appbundle with --enable-debug. The debug bundle
should still work in that instance shouldn't it?

> BTW, I've been working on an i386 binary of pgadmin3 that is statically
> linked.
> If've managed to compile static version of libxml, libxslt, wxwidgets and
> libpq, but configure fails for pgadmin3 because it doesn't know that it has
> to pass "-lssl" when linking against that static libpq. AFAIK, libtool
> ususally
> takes care of that, and provides dependency information for static libs.
> 
> Neither wxwidgest nor postgres seem to create *.la files for my static
> libs -
> Does anyone know if they should - or how to deal with static linking
> without
> libtool?

I'm missing something I guess - whilst it only links statically with wx
and pg, we already have --enable-static which works fine on intel and
ppc macs. That's the option I now force on when building an appbundle.

Regards, Dave.


---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Florian G. Pflug

Dave Page wrote:

The existing complete-bundle.sh code works fine, and rewrites the paths
to the wx libraries as expected, however the debugger crashes when run.
As best I can figure, this is because although the debugger has the
correct relative paths to the libraries, some of those (wx) libraries
are interdependent, and when run by the debugger executable, the
relative paths between them are incorrect.

I'll look into this. One solution might be to symlink the wx libs
into the Debugger bundle, but I hope that there is a cleaner solution.


To resolve this until a better solution is found, I've modified the
build system such that static linking is forced when building an app
bundle. This also has the advantage of reducing the bundle size a little :-)

The only downside of this that I can see is that the pgadmin3 binary gets
_really_ huge (about 200M or so) when statically linked against wx. My old
powerbook G4 takes a few minutes to even open that with gdb..

BTW, I've been working on an i386 binary of pgadmin3 that is statically linked.
If've managed to compile static version of libxml, libxslt, wxwidgets and
libpq, but configure fails for pgadmin3 because it doesn't know that it has
to pass "-lssl" when linking against that static libpq. AFAIK, libtool ususally
takes care of that, and provides dependency information for static libs.

Neither wxwidgest nor postgres seem to create *.la files for my static libs -
Does anyone know if they should - or how to deal with static linking without
libtool?

greetings, Florian Pflug

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


[pgadmin-hackers] SVN Commit by dpage: r6164 - in trunk/pgadmin3: . debugger pgadmin pkg/mac xtra/pgagent

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 12:28:32 + (Wed, 04 Apr 2007)

New Revision: 6164

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6164&view=rev

Log:
build a Debugger.app within the pgAdmin3.app resources directory in the 
Mac App bundle.

This does introduce one downside:

The existing complete-bundle.sh code works fine, and rewrites the paths
to the wx libraries as expected, however the debugger crashes when run.
As best I can figure, this is because although the debugger has the
correct relative paths to the libraries, some of those (wx) libraries
are interdependent, and when run by the debugger executable, the
relative paths between them are incorrect.

To resolve this until a better solution is found, I've modified the
build system such that static linking is forced when building an app
bundle. This also has the advantage of reducing the bundle size a little  :-) 





Added:
   trunk/pgadmin3/pkg/mac/debug.debugger.Info.plist.in
   trunk/pgadmin3/pkg/mac/debug.pgadmin.Info.plist.in
   trunk/pgadmin3/pkg/mac/debugger.Info.plist.in
   trunk/pgadmin3/pkg/mac/debugger.icns
   trunk/pgadmin3/pkg/mac/pgadmin.Info.plist.in
Removed:
   trunk/pgadmin3/pkg/mac/Info-Debug.plist.in
   trunk/pgadmin3/pkg/mac/Info.plist.in
Modified:
   trunk/pgadmin3/acinclude.m4
   trunk/pgadmin3/bootstrap
   trunk/pgadmin3/configure.ac.in
   trunk/pgadmin3/debugger/Makefile.am
   trunk/pgadmin3/pgadmin/Makefile.am
   trunk/pgadmin3/pgadmin/pgAdmin3.cpp
   trunk/pgadmin3/pkg/mac/Makefile.am
   trunk/pgadmin3/pkg/mac/debug-bundle.sh
   trunk/pgadmin3/xtra/pgagent/Makefile.am

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [pgadmin-hackers] Debugger integration

2007-04-04 Thread Dave Page
Dave Page wrote:

> I'd be happy to go with the embedded bundle option - what puts me off is
> that I'm still not overly confident with make etc. The merged code
> option is nicest in theory, but I'd be concerned that it would always
> seem like bolted on code without an almost complete rewrite (which seems
> pointless - Korry's code is perfectly good, just architected very
> differently from the rest of pgAdmin).
> 
> If you can track down any info on embedded bundles, that would be a big
> help. I suspect this is the method that would be the most sensible overall.

For info, I'm just about to commit changes that do exactly this - build
a Debugger.app within the pgAdmin3.app resources directory - it seems to
work fine, with one caveat:

The existing complete-bundle.sh code works fine, and rewrites the paths
to the wx libraries as expected, however the debugger crashes when run.
As best I can figure, this is because although the debugger has the
correct relative paths to the libraries, some of those (wx) libraries
are interdependent, and when run by the debugger executable, the
relative paths between them are incorrect.

To resolve this until a better solution is found, I've modified the
build system such that static linking is forced when building an app
bundle. This also has the advantage of reducing the bundle size a little :-)

Regards, Dave.

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

   http://www.postgresql.org/docs/faq


[pgadmin-hackers] Bug Report

2007-04-04 Thread Zongliang, Quan
In pgServer.cpp, Line 752:

if (executed)
{
password = newVal;
StorePassword();
--->return false;
}
else
return false;

Although the passwd had been changed successfully with "Change Password"
dialog. "The password could not be changed!" message always popup.

Line 756 should be "return true";

Regards.
Quan

---
Zongliang, Quan
[EMAIL PROTECTED],[EMAIL PROTECTED]
Admin by
http://postgresql.oss.tw
http://postgresql-chinese.blogspot.com


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [pgadmin-hackers] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread Quan Zongliang(Gmail)
It seems zh_CN needs some changes, too.

:)

Regards.
Quan

On Wed, 04 Apr 2007 09:37:42 +0100
Dave Page <[EMAIL PROTECTED]> wrote:

> [EMAIL PROTECTED] wrote:
> > Author: guillaume
> > 
> > Date: 2007-04-04 07:04:45 + (Wed, 04 Apr 2007)
> > 
> > New Revision: 6161
> > 
> > Revision summary: 
> > http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6161&view=rev
> > 
> > Log:
> > Add zh_TW translation of docs and hints, per ChaoYi Kuo.
> 
> Shouldn't there be some Makefile and pkg/win32/src/pgadmin3.wxs changes
> with this?
> 
> :-)
> 
> Regards, Dave.
> 
> ---(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings

---
Zongliang Quan
[EMAIL PROTECTED],[EMAIL PROTECTED]
Admin by
http://postgresql.oss.tw
http://postgresql-chinese.blogspot.com


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


Re: [pgadmin-hackers] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread Dave Page
Guillaume Lelarge wrote:
> Dave Page a ecrit le 04/04/2007 10:37:
>> [EMAIL PROTECTED] wrote:
>>> Author: guillaume
>>>
>>> Date: 2007-04-04 07:04:45 + (Wed, 04 Apr 2007)
>>>
>>> New Revision: 6161
>>>
>>> Revision summary:
>>> http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6161&view=rev
>>>
>>> Log:
>>> Add zh_TW translation of docs and hints, per ChaoYi Kuo.
>>
>> Shouldn't there be some Makefile and pkg/win32/src/pgadmin3.wxs changes
>> with this?
>>
>> :-)
>>
> 
> Oops, sorry about this. I'll fix this tonight.

Thanks :-)

/D

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

   http://www.postgresql.org/docs/faq


Re: [pgadmin-hackers] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread Guillaume Lelarge

Dave Page a ecrit le 04/04/2007 10:37:

[EMAIL PROTECTED] wrote:

Author: guillaume

Date: 2007-04-04 07:04:45 + (Wed, 04 Apr 2007)

New Revision: 6161

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6161&view=rev

Log:
Add zh_TW translation of docs and hints, per ChaoYi Kuo.


Shouldn't there be some Makefile and pkg/win32/src/pgadmin3.wxs changes
with this?

:-)



Oops, sorry about this. I'll fix this tonight.

Regards.


--
Guillaume.

---(end of broadcast)---
TIP 1: 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] SVN Commit by dpage: r6163 - trunk/pgadmin3/pgadmin/dlg

2007-04-04 Thread svn
Author: dpage

Date: 2007-04-04 07:54:42 + (Wed, 04 Apr 2007)

New Revision: 6163

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6163&view=rev

Log:
Silence GCC warning



Modified:
   trunk/pgadmin3/pgadmin/dlg/dlgFunction.cpp

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


Re: [pgadmin-hackers] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread Dave Page
[EMAIL PROTECTED] wrote:
> Author: guillaume
> 
> Date: 2007-04-04 07:04:45 + (Wed, 04 Apr 2007)
> 
> New Revision: 6161
> 
> Revision summary: 
> http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6161&view=rev
> 
> Log:
> Add zh_TW translation of docs and hints, per ChaoYi Kuo.

Shouldn't there be some Makefile and pkg/win32/src/pgadmin3.wxs changes
with this?

:-)

Regards, Dave.

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


[pgadmin-hackers] SVN Commit by guillaume: r6162 - in trunk/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread svn
Author: guillaume

Date: 2007-04-04 07:04:57 + (Wed, 04 Apr 2007)

New Revision: 6162

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6162&view=rev

Log:
Add zh_TW translation of docs and hints, per ChaoYi Kuo.



Added:
   trunk/pgadmin3/docs/zh_TW/
   trunk/pgadmin3/docs/zh_TW/hints/
   trunk/pgadmin3/docs/zh_TW/hints/autovacuum.html
   trunk/pgadmin3/docs/zh_TW/hints/conn-hba.html
   trunk/pgadmin3/docs/zh_TW/hints/conn-ident.html
   trunk/pgadmin3/docs/zh_TW/hints/conn-listen.html
   trunk/pgadmin3/docs/zh_TW/hints/encoding-ascii.html
   trunk/pgadmin3/docs/zh_TW/hints/encoding-unicode.html
   trunk/pgadmin3/docs/zh_TW/hints/fki.html
   trunk/pgadmin3/docs/zh_TW/hints/instrumentation.html
   trunk/pgadmin3/docs/zh_TW/hints/multiple.html
   trunk/pgadmin3/docs/zh_TW/hints/object-editing.html
   trunk/pgadmin3/docs/zh_TW/hints/pk.html
   trunk/pgadmin3/docs/zh_TW/hints/saving-passwords.html
   trunk/pgadmin3/docs/zh_TW/hints/vacuum.html
   trunk/pgadmin3/docs/zh_TW/hints/view-without-pk.html
   trunk/pgadmin3/docs/zh_TW/pgadmin3.css
   trunk/pgadmin3/docs/zh_TW/tips.txt

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[pgadmin-hackers] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-04 Thread svn
Author: guillaume

Date: 2007-04-04 07:04:45 + (Wed, 04 Apr 2007)

New Revision: 6161

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6161&view=rev

Log:
Add zh_TW translation of docs and hints, per ChaoYi Kuo.



Added:
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/autovacuum.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/conn-hba.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/conn-ident.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/conn-listen.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/encoding-ascii.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/encoding-unicode.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/fki.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/instrumentation.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/multiple.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/object-editing.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/pk.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/saving-passwords.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/vacuum.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/hints/view-without-pk.html
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/pgadmin3.css
   branches/REL-1_6_0_PATCHES/pgadmin3/docs/zh_TW/tips.txt

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