Re: [pgadmin-hackers] GUI glitch (1.6.3)

2007-04-05 Thread Guillaume Lelarge

Dave Page a écrit :

Florian G. Pflug wrote:

Dave Page wrote:

Guillaume Lelarge wrote:

Dave Page a ecrit le 02/04/2007 17:04:

Guillaume Lelarge wrote:

[...]
I see it on trunk on Win32, and to a far lesser extent on 1.6.3 on
OSX. Are you still intending to fix it?


If you want to do it, go ahead. I have another bug to work on.

No, not at all - I have plenty of other stuff to do and was hoping
you'd get it :-)


No problem. I'll work on it.

Danke.

German? How comes? ;-)


Gotta practice once in a while :-)



:)

Still working on it.

I've installed pgAdmin 1.6.3 on a new PC with Windows XP and I still 
have this problem. I thought it could be a garbled xrc file but they 
seem to be integrated in the EXE file on Windows. So I can't tell you if 
my guess is right.


I don't have problems with a compiled linux build. I don't see changes 
on the dlgEditGridOption.xrc from SVN log. Unfortunately, I can't build 
the windows release. I wonder if it was possible that something break 
during the windows official build ? I mean, before the build, sources 
are fetched from SVN and compiled immediately ? or is there a 
possibility that the dlgEditGridOption.xrc could have been modified 
before the windows build ?


I'll do my best to be able to build a windows release when I get my new 
laptop. But now, I just can't.



Thanks for any info on the current official windows build.

Regards.


--
Guillaume.


---(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-05 Thread Dave Page

Guillaume Lelarge wrote:


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


Looks OK, and compiles OK - I assume the GUIDs were properly generated 
(ie. you didn't just make them up!)? If so, then it's fine - 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] SVN Commit by guillaume: r6161 - in branches/REL-1_6_0_PATCHES/pgadmin3/docs: . zh_TW zh_TW/hints

2007-04-05 Thread Guillaume Lelarge

Dave Page a ecrit le 05/04/2007 09:47:

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


Looks OK, and compiles OK - I assume the GUIDs were properly generated 
(ie. you didn't just make them up!)? If so, then it's fine - thanks.




Hmmm... You sent them to me in a previous email, so I think you properly 
generated them :)


Regards.


--
Guillaume.

---(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-05 Thread Dave Page

Guillaume Lelarge wrote:

Dave Page a ecrit le 05/04/2007 09:47:

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


Looks OK, and compiles OK - I assume the GUIDs were properly generated 
(ie. you didn't just make them up!)? If so, then it's fine - thanks.




Hmmm... You sent them to me in a previous email, so I think you properly 
generated them :)


I did? OK, as long as they didn't get used before!

/D

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

  http://archives.postgresql.org


[pgadmin-hackers] SVN Commit by dpage: r6176 - in trunk/pgadmin3/pgadmin: dlg ui

2007-04-05 Thread svn
Author: dpage

Date: 2007-04-05 08:53:01 + (Thu, 05 Apr 2007)

New Revision: 6176

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

Log:
Fix filter text box sizing bug


Modified:
   trunk/pgadmin3/pgadmin/dlg/dlgEditGridOptions.cpp
   trunk/pgadmin3/pgadmin/ui/dlgEditGridOptions.xrc
   trunk/pgadmin3/pgadmin/ui/xrcDialogs.cpp

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

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


Re: [pgadmin-hackers] GUI glitch (1.6.3)

2007-04-05 Thread Dave Page

Guillaume Lelarge wrote:

Dave Page a écrit :

Florian G. Pflug wrote:

Dave Page wrote:

Guillaume Lelarge wrote:

Dave Page a ecrit le 02/04/2007 17:04:

Guillaume Lelarge wrote:

[...]
I see it on trunk on Win32, and to a far lesser extent on 1.6.3 on
OSX. Are you still intending to fix it?


If you want to do it, go ahead. I have another bug to work on.

No, not at all - I have plenty of other stuff to do and was hoping
you'd get it :-)


No problem. I'll work on it.

Danke.

German? How comes? ;-)


Gotta practice once in a while :-)



:)

Still working on it.

I've installed pgAdmin 1.6.3 on a new PC with Windows XP and I still 
have this problem. I thought it could be a garbled xrc file but they 
seem to be integrated in the EXE file on Windows. So I can't tell you if 
my guess is right.


I don't have problems with a compiled linux build. I don't see changes 
on the dlgEditGridOption.xrc from SVN log. Unfortunately, I can't build 
the windows release. I wonder if it was possible that something break 
during the windows official build ? I mean, before the build, sources 
are fetched from SVN and compiled immediately ? or is there a 
possibility that the dlgEditGridOption.xrc could have been modified 
before the windows build ?


I'll do my best to be able to build a windows release when I get my new 
laptop. But now, I just can't.



Thanks for any info on the current official windows build.


Hmm, that was wierd - I think it must have been caused by a change in 
the new wxWidgets version. That control was loaded in code as a custom 
control, which appears to stop the sizer working properly. I've changed 
it to load in the same way we normally load those controls and all is 
well again :-)


BTW, to clear up any confusion about the XRC files, in a debug build on 
any platform, the dialogues are loaded from their respective XRC file on 
the fly. The files can be editted whilst pgAdmin is running, and the 
next time the dialogue is loaded, the new version will be displayed.


The embed-xrc scripts in pgadmin/ui are used to compile the XRC files 
into xrcDialogs.cpp. This is used in all release builds, where the XRc 
files are no longer required (one of the last remaining roadmap items is 
to stop them getting installed on *nix in fact).


Regards, Dave.

---(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: r6177 - trunk/www/download

2007-04-05 Thread svn
Author: dpage

Date: 2007-04-05 09:07:25 + (Thu, 05 Apr 2007)

New Revision: 6177

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

Log:
Add Solaris downloads


Added:
   trunk/www/download/solaris.php
Modified:
   trunk/www/download/menu.php

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


[pgadmin-hackers] pgAdmin packages for Solaris available

2007-04-05 Thread Dave Page
Thanks to the guys at Sun Microsystems, I'm happy to announce that the 
pgAdmin project is now able to offer pre-build Solaris packages for 
Sparc and Intel machines:


http://www.pgadmin.org/download/solaris.php

Enjoy :-)

Regards, Dave

--
Dave Page
pgAdmin Project

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


Re: [pgadmin-hackers] Two bugs

2007-04-05 Thread Dave Page

Robins wrote:

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 ?


The view can't change what it returns though, as you'll get an error 
from PostgreSQL like:


-- Executing query:
CREATE OR REPLACE VIEW bar_view AS
 SELECT 'a' AS cola, 'b' AS cola

ERROR: cannot change name of view column "col1"
SQL state: 42P16

The only way to do what you describe is to drop the view through SQL and 
create a new one with the same name. That will always screw up pgAdmin 
as it doesn't know you've done that unless you do it through the UI. The 
only way round this would be to check for changes like this on every 
action, but that would make pgAdmin unusable for users on slower network 
connections as every time the tried to do anything (even select a 
treeview node), one or more round trips to the server would be made.


The refresh twice thing is happening (I imagine) because you are 
refreshing the view node itself, which vanishes because the original 
view no longer exists. You then refresh the Views node which repopulates 
all of the views under it, thus picking up the new one. In this 
situation, just refresh the Views node.


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


Well first off, pgAdmin should *not* be crashing so please describe what 
you are doing when it does.


Secondly I honestly don't see any way in which pgAdmin would randomly 
rename one of your functions - that would involve it generating and 
executing an ALTER FUNCTION statement. Whilst I can imagine a bug that 
causes a crash or odd error, I have a hard time believing there is one 
that can randomly generate and execute perfectly valid SQL statements!


Are you sure you're not getting two dialogues mixed up? If not, please 
describe exactly what you are doing.


Regards, Dave

---(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 hiroshi: r6178 - in trunk/pgadmin3/debugger: . include

2007-04-05 Thread svn
Author: hiroshi

Date: 2007-04-05 18:54:12 + (Thu, 05 Apr 2007)

New Revision: 6178

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

Log:
Fixed debugger's store settings per pgAdmin.
The setting of pgAdmin is read. 
then, Debugger writes only Proc.



Modified:
   trunk/pgadmin3/debugger/debugger.cpp
   trunk/pgadmin3/debugger/include/debugger.h
   trunk/pgadmin3/debugger/wsRichWindow.cpp
   trunk/pgadmin3/debugger/wsStackWindow.cpp

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

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


[pgadmin-hackers] Debugger's store settings per pgAdmin.

2007-04-05 Thread Hiroshi Saito

Hi.

SVN Commit by hiroshi: r6178 - in trunk/pgadmin3/debugger

Fixed debugger's store settings per pgAdmin.
The setting of pgAdmin is read. 
then, debugger writes only Proc.


pgAdmin is expressible though I cannot read ZN_cn.:-)
http://winpg.jp/~saito/pgAdmin/debugger_ZN_cn.png

Regards,
Hiroshi Saito


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

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


Re: [pgadmin-hackers] Debugger's store settings per pgAdmin.

2007-04-05 Thread Guillaume Lelarge

Hi,

Hiroshi Saito a écrit :

SVN Commit by hiroshi: r6178 - in trunk/pgadmin3/debugger

Fixed debugger's store settings per pgAdmin.
The setting of pgAdmin is read. then, debugger writes only Proc.

pgAdmin is expressible though I cannot read ZN_cn.:-)
http://winpg.jp/~saito/pgAdmin/debugger_ZN_cn.png



This is so great. I can't wait to try the debugger. Thanks for your work 
on this.


There's something that bugs me. It's not that important but... the title 
of the debugger's window is pgAdmin3. I think it should be changed with 
pgAdmin III.


Regards.


--
Guillaume.


---(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 hiroshi: r6179 - trunk/pgadmin3/debugger

2007-04-05 Thread svn
Author: hiroshi

Date: 2007-04-05 23:59:01 + (Thu, 05 Apr 2007)

New Revision: 6179

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

Log:
Fixed title name.
Suggestion from Guillaume-san:-)



Modified:
   trunk/pgadmin3/debugger/debugger.cpp

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

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


Re: [pgadmin-hackers] Debugger's store settings per pgAdmin.

2007-04-05 Thread Hiroshi Saito

Hi.

From: "Guillaume Lelarge" <[EMAIL PROTECTED]>

This is so great. I can't wait to try the debugger. Thanks for your work 
on this.


Yea!:-)



There's something that bugs me. It's not that important but... the title 
of the debugger's window is pgAdmin3. I think it should be changed with 
pgAdmin III.


Ooops, thanks!

Regards,
Hiroshi Saito


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


[pgadmin-hackers] SVN Commit by hiroshi: r6180 - trunk/pgadmin3/debugger

2007-04-05 Thread svn
Author: hiroshi

Date: 2007-04-06 00:27:44 + (Fri, 06 Apr 2007)

New Revision: 6180

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

Log:
Fixed *nix build error.



Modified:
   trunk/pgadmin3/debugger/wsRichWindow.cpp

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

   http://archives.postgresql.org