Re: [pgadmin-hackers] solaris port

2003-11-27 Thread Andreas Pflug
Raphaël Enrici wrote:


After that, we upgrade our snapshot to wx cvs HEAD, apply our patches 
and continue hoping that there might be some time in the distant 
future where we can use plain vanilla wx 


"hope"... that's a nice title for a song, I'm going to write some 
lyrics :)


So gimme hope, wx-a
hope, wx-a
gimme hope, wx-a,
'fore frustration come
gimme hope, wx-a
hope, wx-a
hope before frustration come.
--> your lyrics here

Maybe we can persuade Vadim to contribute a verse...

Regards,
Andreas


---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org


Re: [pgadmin-hackers] [querybuilder patch] Re: I asks for again,

2003-11-27 Thread Hiroshi Saito
Hi Andreas.

From: "Andreas Pflug" <[EMAIL PROTECTED]>
(snip)

> How is a join visualized?

Because m_aliases couldn't take it any more by injustice patch,
the place of the join couldn't be taken as it.

Sigh...
However,
wxWindows is further pursued because it guessed a little thanks to Raphaël.

regards,
Hiroshi Saito


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


Re: [pgadmin-hackers] [pgadmin-support] pgAdmin web site translated into 10 languages

2003-11-27 Thread Jean-Michel POURE
Le Jeudi 27 Novembre 2003 17:28, Tino Wildenhain a écrit :
> Hm. why doesn't the site respects my browser settings?
> (Preferred language order: German [de], English [en].
> Who needs help?

You are right... Language detection is not implented yet. I am planning to do 
it soon. Feel free to do it in PHP if you preffer. The souce can be fetched 
from CVS. Any help is welcome.

Also, I added icons displaying the available languages instead of a menu.

Cheers, Jean-Michel


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


Re: [pgadmin-hackers] solaris port

2003-11-27 Thread Raphaël Enrici
Andreas Pflug wrote:

Raphaël Enrici wrote:

-pthreads -D_REENTRANT -Wall src/common/intl.cpp
In file included from src/common/intl.cpp:49: include/wx/intl.h:40: 
warning: `_N' redefined
/usr/include/iso/ctype_iso.h:38: warning: this is the location of the 
previous definition
> src/common/intl.cpp: In method `bool 
wxPluralFormsScanner::nextToken()':

src/common/intl.cpp:241: `_N' undeclared (first use this function)
src/common/intl.cpp:241: (Each undeclared identifier is reported only 
once
src/common/intl.cpp:241: for each function it appears in.)


This doesn't talk to me, it's not caused by our fixes.
_N is one of the gettext macros, and there seems to be some conflict 
between wx (intl.h) and system (ctype_iso.h). 
Ok,
I found this in docs/gtk/install.txt
--enable-permissive Enable compilation without checking for strict
   ANSI conformance.  Useful to prevent the build
   dying with errors as soon as you compile with
   Solaris' ANSI-defying headers.
Maybe it's the way to follow...

also found this:

- Solaris compilation with gcc: if the compiler has problems with the variable
 argument functions, try putting the gcc fixinclude file paths early in the
 include path.

I'd recommend you use the official wx cvs HEAD to get it compiled. If 
problems persist, you (maybe) get some support on wx-hackers, or we'll 
find out ourselves how to solve it. In the second case, we certainly 
should post the fix to the wx patch manager. 
ok, I'll try this too.

After that, we upgrade our snapshot to wx cvs HEAD, apply our patches 
and continue hoping that there might be some time in the distant 
future where we can use plain vanilla wx 
"hope"... that's a nice title for a song, I'm going to write some lyrics :)

Thank you for your explanations, I'll tell you if I get something working.

Regards,
Raphaël


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


Re: [pgadmin-hackers] [querybuilder patch] Re: I asks for again,

2003-11-27 Thread Andreas Pflug
Raphaël Enrici wrote:

As for screen to add a table?
which is it?
case 1)
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/FreeBSD_QueryBuilder_1.jpg
case 2)
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/FreeBSD_QueryBuilder_2.jpg
It's just like the first case. (note that I find it has a better look 
than second one... so, I'm happy! ;p)


How is a join visualized?

Regards,
Andreas


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


Re: [pgadmin-hackers] solaris port

2003-11-27 Thread Andreas Pflug
Raphaël Enrici wrote:

-pthreads -D_REENTRANT -Wall src/common/intl.cpp
In file included from src/common/intl.cpp:49: include/wx/intl.h:40: 
warning: `_N' redefined
/usr/include/iso/ctype_iso.h:38: warning: this is the location of the 
previous definition


src/common/intl.cpp: In method `bool wxPluralFormsScanner::nextToken()':
src/common/intl.cpp:241: `_N' undeclared (first use this function)
src/common/intl.cpp:241: (Each undeclared identifier is reported only 
once
src/common/intl.cpp:241: for each function it appears in.)
This doesn't talk to me, it's not caused by our fixes.
_N is one of the gettext macros, and there seems to be some conflict 
between wx (intl.h) and system (ctype_iso.h).
I'd recommend you use the official wx cvs HEAD to get it compiled. If 
problems persist, you (maybe) get some support on wx-hackers, or we'll 
find out ourselves how to solve it. In the second case, we certainly 
should post the fix to the wx patch manager.

After that, we upgrade our snapshot to wx cvs HEAD, apply our patches 
and continue hoping that there might be some time in the distant future 
where we can use plain vanilla wx

Regards,
Andreas


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


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] solaris port

2003-11-27 Thread Raphaël Enrici
Hi guys!

first of all I would like to tell that the 2.4 release of wx builds ok 
(that's a good point to start, I think).
But, did someone here succeeded to build wx 2.5 snapshots on Solaris ? 
If so I would be interested in the configuration (compiler, os and so 
on) used to do the build.

Here is the build error of our wx snap (I'll give the full configure 
line later):
./bk-deps g++ -c -o monolib_intl.o  -D__WXGTK__  -I./include
-I./src/expat/lib -DwxUSE_BASE=1 -D__WXDEBUG__ -Ilib/wx/include/gtk2ud-2.5
-I./include -threads -I/home/testuser/usr/include/gtk-2.0
-I/home/testuser/usr/lib/gtk-2.0/include
-I/home/testuser/usr/include/atk-1.0
-I/home/testuser/usr/include/pango-1.0 -I/usr/openwin/include
-I/home/testuser/usr/include/glib-2.0
-I/home/testuser/usr/lib/glib-2.0/include -I
/home/testuser/usr/include -g -O0 -I /home/testuser/usr/include
-pthreads -D_REENTRANT -Wall src/common/intl.cpp
In file included from src/common/intl.cpp:49:
include/wx/intl.h:40: warning: `_N' redefined
/usr/include/iso/ctype_iso.h:38: warning: this is the location of the
previous definition
src/common/intl.cpp: In method `bool wxPluralFormsScanner::nextToken()':
src/common/intl.cpp:241: `_N' undeclared (first use this function)
src/common/intl.cpp:241: (Each undeclared identifier is reported only once
src/common/intl.cpp:241: for each function it appears in.)
gmake: *** [monolib_intl.o] Error 1

Andreas does it talk to you (I mean, something to do with one of your 
patches ?) ?
In fact I had no time to look further in the source to see if I 
understand a piece of line.

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


Re: [pgadmin-hackers] [querybuilder patch] Re: I asks for again,

2003-11-27 Thread Raphaël Enrici
Hiroshi Saito wrote:

From: "Raphaël Enrici" <[EMAIL PROTECTED]>

 

Hi Hiroshi,

Hiroshi Saito wrote:

   

Question 2)
Please send screen shots to me.
 

Shall I ?
   

As for screen to add a table?
which is it?
case 1)
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/FreeBSD_QueryBuilder_1.jpg
case 2)
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/FreeBSD_QueryBuilder_2.jpg
It's just like the first case. (note that I find it has a better look 
than second one... so, I'm happy! ;p)

Question 3)
What is Version of gcc and gtk?
 

gcc 2.95.4-11woody1
libgtk2: 2.2.2-1woody2
   

I guessed.
bug seems to lurk around wxSashLayoutWindow and wxLayoutAlgorithm.
or, whether to be a specification...
 

If you want I can try a build on debian unstable ( it should be
libgtk2=2.2.4-1 and gcc 3.3.2-1)
   

I finally built it on unstable (gtk 2.2.4 and gcc 3.3.2), pgA3 crashes 
with a wxassert logged in pgadmin.log...

Thank you for taking the time to help me in this.
 

It was a question of minutes for me. I think the only one that should be 
thanksed is YOU!
Go on with this patch and feel free to contact me.

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


[pgadmin-hackers] pgadmin3 1.0.1 RPMS for FC1

2003-11-27 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


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,

- -- 
Devrim GUNDUZ
[EMAIL PROTECTED]   [EMAIL PROTECTED] 
http://www.tdmsoft.com
http://www.gunduz.org
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/xjObtl86P3SPfQ4RAg00AJ4mdnxzULDbB57x4ZasPRM0V+6yEQCg58xN
KU+YMd0ZxVJsBZptnxgpeqY=
=VkHh
-END PGP SIGNATURE-


---(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-support] pgAdmin web site translated into 11 languages

2003-11-27 Thread Tino Wildenhain
Hi,

Jean-Michel POURE schrieb:
Dear friends,

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
Hm. why doesn't the site respects my browser settings?
(Preferred language order: German [de], English [en].
Who needs help?

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


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


[pgadmin-hackers] Another crash of pgadmin under Fedora

2003-11-27 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


Hi,

pgadmin3-devel (yesterday's snapshot) crashed on FC1.

Here is the strace output:
=
write(2, "\n(pgadmin3:25724): Gdk-CRITICAL "..., 117
(pgadmin3:25724): Gdk-CRITICAL **: file gdkgc.c: line 221 
(gdk_gc_set_background): assertion `color != NULL' failed
) = 117
=

Here is the wxwindows debug:
==
src/gtk/colour.cpp(272): assert "wxAssertFailure" failed: invalid colour



Regards,
- -- 
Devrim GUNDUZ
[EMAIL PROTECTED]   [EMAIL PROTECTED] 
http://www.tdmsoft.com
http://www.gunduz.org
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/xg5Jtl86P3SPfQ4RAv+3AJ4vpDfIoxY0YoVbY4yPcL29BHydnQCgwRi2
jjn6wDixlZQEBXV2WpBNpgY=
=qGcl
-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])


[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] [querybuilder patch] Re: I asks for again, And Apology.

2003-11-27 Thread Hiroshi Saito
Hi Raphaël.

Thank you very much.!
for the additional info. :-)

From: "Raphaël Enrici" <[EMAIL PROTECTED]>


> Hi Hiroshi,
>
> Hiroshi Saito wrote:
>
> >Question 1)
> >Can you operate QueryBuilder well?
> >
> Here are the quick tests I did :
> I tried to launch the querybuilder from today's snapshots (debian stable
> version) and it simply crashes when I select a table to add...

Hmm..
Not only the machine of Dave and me but also linux was included, and it was the 
phenomenon of Unix all.

> I then took your patch and applied it.
> Now I can select the table to add but I have some wx asserts:
(snip)
>
> These asserts are coming up everytime I add a table and in the same order.

It can be understood as a phenomenon which probably happens by patch.
This information was precious.:-)

>
> >Question 2)
> >Please send screen shots to me.
> >
> Shall I ?

As for screen to add a table?
which is it?
case 1)
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/FreeBSD_QueryBuilder_1.jpg
case 2)
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/FreeBSD_QueryBuilder_2.jpg

>
> >Question 3)
> >What is Version of gcc and gtk?
> >
> gcc 2.95.4-11woody1
> libgtk2: 2.2.2-1woody2

I guessed.
bug seems to lurk around wxSashLayoutWindow and wxLayoutAlgorithm.
or, whether to be a specification...

>
> If you want I can try a build on debian unstable ( it should be
> libgtk2=2.2.4-1 and gcc 3.3.2-1)
>
> Hope this helps,
>
> Raphaël Enrici

Thank you for taking the time to help me in this.

regards,
Hiroshi Saito


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