Re: [pgadmin-hackers] pgadmin3 on FreeBSD4.8

2003-06-30 Thread Dave Page


> -Original Message-
> From: Hiroshi Saito [mailto:[EMAIL PROTECTED] 
> Sent: 30 June 2003 03:27
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: pgadmin3 on FreeBSD4.8
> 
> 
> Hi Dave.
> 
> I am the environment that FreeBSD4.8 is important.
> It is tried variously to make it move.
> But, a movement by UNICODE (UTF-8) is difficult.
> So, it is being None support UNICODE.
> 
> screen shot in the examination. 
> http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_sample
> 5.jpg
> http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_sample6.jpg
> 
> I go into the Japanese adjustment from now.

:-(. Is that just because of the older version of FreeBSD?

Do you have a test database you can email me that I can play with
please?

> 
> BTW.
> Attached patch is necessary with this environment. 
> But, Is it likely to be unnecessary with FreeBSD5.1?

I don't think so - it compiles and runs OK on 5.1 with tweaks to
configure. Is there anything defined that we could use easily to detect
FreeBSD 4 or 5?

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


Re: [pgadmin-hackers] wxWindows Build

2003-06-30 Thread Dave Page


> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
> Sent: 28 June 2003 09:40
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] wxWindows Build
> 
> 
> Dave Page wrote:
> 
> >It's rumoured that Andreas Pflug once said:
> >
> >  
> >
> >>We need our own version at the moment, which may be based on 
> >>2003-06-07  or 2003-06-18, and has the additional wxString patch to 
> >>support that's  still open.
> >>
> >>
> >
> >Shal we go with the later one then if we know it's good, and stick a 
> >patched tarball on Snake? Regards, Dave
> >  
> >
> Yes, and apply the patch appended to this mail.

It's not on the wx site any more - can you email a copy of ftp it to
Snake please?

Regards, Dave

---(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] running error

2003-06-30 Thread Dave Page


> -Original Message-
> From: Michael Tang [mailto:[EMAIL PROTECTED] 
> Sent: 30 June 2003 09:58
> To: [EMAIL PROTECTED]
> Subject: ??: running error
> 
> 
> Hi ,
> 
> I cannot run pgadminIII in my notebook(but pgadminII is 
> OK and III can run in desktop PC)!
> It  show windows system error "application error". it 
> cannot read the memory. 
> It seems "msvcrt.dll" error in VC6.0 debugging.
> My notebook model is DELL inspiron 1100. 
>Please help me.
> 

Hi Michael,

Can you let me know the exact error message, and what OS you are running
please?

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


Re: [pgadmin-hackers] wxWindows Build

2003-06-30 Thread Jean-Michel POURE
On Monday 30 June 2003 11:08, Dave Page wrote:
> It's not on the wx site any more - can you email a copy of ftp it to
> Snake please?

Do you mean it cannot be fetched using CVS?
Cheers, Jean-Michel


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


Re: [pgadmin-hackers] wxWindows Build

2003-06-30 Thread Dave Page


> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] 
> Sent: 30 June 2003 10:21
> To: Dave Page; Andreas Pflug
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] wxWindows Build
> 
> 
> On Monday 30 June 2003 11:08, Dave Page wrote:
> > It's not on the wx site any more - can you email a copy of 
> ftp it to 
> > Snake please?
> 
> Do you mean it cannot be fetched using CVS?
> Cheers, Jean-Michel

Probably if i new the time/timezone at which it was created. There may
also be some bootstraps to run before it's usable and I don't know what
that is.

Regards, Dave.

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


Re: [pgadmin-hackers] wxWindows Build

2003-06-30 Thread Jean-Michel POURE
On Monday 30 June 2003 11:23, Dave Page wrote:
> Probably if i new the time/timezone at which it was created. There may
> also be some bootstraps to run before it's usable and I don't know what
> that is.

A simple "autoconf" should suffice as explained in the wxWindows docs. I will 
have a try later today, after I finish some ongoing work, in order to upgrade 
the existing RPMs.

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] wxWindows Build

2003-06-30 Thread Dave Page


> -Original Message-
> From: Raphaël Enrici [mailto:[EMAIL PROTECTED] 
> Sent: 29 June 2003 23:19
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] wxWindows Build
> 
> 
> Here is my new "plan" :
> may be it's too early to upload pgadmin3 to the official debian 
> repository (I'll keep on trying building against wxWindows 2.4, which 
> works well for me for the moment... I mean that my package do 
> build on 
> it about two days ago).
> I'am now building some wxWindows 2.5 packages based on 
> checkout of the 
> CVS 2003-06-18 (it should be this one unless I did some 
> mistake in cvs 
> line...) and I patched them with the string.cpp from Andreas Pflug : 
> these packages are quite the same as Jean-Michel's one and 
> are called : pgadmin3-libwxgtk2ud2.5-contrib_2.5-20030618_i386.deb
> pgadmin3-libwxgtk2ud2.5-dev_2.5-20030618_i386.deb
> pgadmin3-libwxgtk2ud2.5_2.5-20030618_i386.deb
> Please tell me when your patched tarball will be available so that I 
> build packages with it.
> 
> They are static (no more shared) libraries and headers needed 
> to build 
> pgadmin3. I prefixed package's name with 'pgadmin3' so to be 
> sure there 
> won't be a clash with future official debian packages names. These 
> packages should not be installed unless you want to do some 
> development 
> on pgadmin3.
> 
> I now build pgadmin3 linked statically against these versions of 
> wxWindows (just as Jean-Michel's does with RPMS).
> As I think we can't integrate debian for the moment, we don't 
> need to be 
> fully compliant with its policy
> 
> As soon as some official debian packages will be available 
> that permit a 
> good integration of pgadmin3 I will go to some more compliant build.
> 
> As I said in the mail before, any suggestions are welcome.

It all sounds good to me. The important thing is that there will be a Debian distro, 
and as soon as it complies with their rules it can potentially be made 'official'.

> Dave, thank you for the account, don't hesitate to contact me if you 
> need some information.
> 
> Another thing :
> I need to know the "upstream author" to complete the package 
> form from 
> debian, who shall I write down ?
> you ? pgadmin development team ? and which email ? yours or 
> pgadmin-hackers ?

Officially it's:

The pgAdmin development Team
[EMAIL PROTECTED]

Of course, we don't write wxWindows...

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


Re: [pgadmin-hackers] pga3: FreeBSD Port

2003-06-30 Thread Dave Page


> -Original Message-
> From: Dave Page 
> Sent: 27 June 2003 19:34
> To: Adam H. Pendleton
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] pga3: FreeBSD Port
> 
> 
> 
> 
> > -Original Message-
> > From: Adam H. Pendleton [mailto:[EMAIL PROTECTED]
> > Sent: 27 June 2003 17:32
> > To: Dave Page
> > Subject: Re: pga3: FreeBSD Port
> > 
> > 
> > Dave Page wrote:
> > 
> > >Hi All,
> > >
> > >First problem, FreeBSD seems to evaluate:
> > >
> > >if test "$pgsql_cv_libpq" == "yes" -a 
> "$pgsql_cv_libpqfe_h" == "yes"
> > >
> > I didn't have this problem when I compiled pgadmin3.  What
> > shell are you 
> > using?
> 
> /bin/csh is the default in /etc/passwd, but I ran from a 
> Konsole window (I assume that was a csh as well). Stupidly 
> I'm at home now and didn't create a non-root account before I 
> left so I can't get in to check.

Hi Adam,

It fails with sh and csh.

Regards, Dave.

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

   http://archives.postgresql.org


Re: [pgadmin-hackers] Translation request of pgAdmin3 into Czech

2003-06-30 Thread Jean-Michel POURE
Dear Jan,

> Yes, I will do it.

Great. We are very thankfull for your help to translate into Czech.

Maybe you should register [EMAIL PROTECTED] mailing list from 
http://www.pgadmin.org/pgadmin2.php?ContentID=4? This is where translations 
are coordinated. I CC my answer to the list for information.

You will also need to checkout pgAdmin3 from CVS to get pgadmin3.pot file 
updates.

> 1. Is there any deadline for translation?

No, pgAdmin is free software, there are no deadlines. Just do your best.

> 2. Do you recommend for translation of database terms any terminologie?
> (Oracle, IBM, MS, Sybase ...). I will not translate db terms myself (like
> trigger etc.), but I will use terms, which are in use.

Personnaly, I keep many db terms untranslated in French because users may be 
confused. We wrote some guidelines about it, but they still need approvement 
of other translators. 

> 3. Do I have to use UTF-8 or iso-8859-2 codepage for translation?

We try to use UTF-8 when possible.

Do not hesitate to get back to us on [EMAIL PROTECTED] for any 
question.

Cheers,
Jean-Michel



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


Re: [pgadmin-hackers] wxWindows Build

2003-06-30 Thread Dave Page


> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] 
> Sent: 30 June 2003 11:03
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] wxWindows Build
> 
> 
> On Monday 30 June 2003 11:23, Dave Page wrote:
> > Probably if i new the time/timezone at which it was 
> created. There may 
> > also be some bootstraps to run before it's usable and I don't know 
> > what that is.
> 
> A simple "autoconf" should suffice as explained in the 
> wxWindows docs. I will 
> have a try later today, after I finish some ongoing work, in 
> order to upgrade 
> the existing RPMs.

Don't worry, doing it now

Regards, Dave

---(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 translation request into Swedish

2003-06-30 Thread Jean-Michel POURE
Dear Dennis,

> I've translated a lot of things before (all using emacs). That is not a
> problem. I also saw what you/someone wrote in the guidelines about upper
> case strings. But still, it's not good.
>
> Now I'm tempted to look at the source instead and understand why it has to
> be like this.

Your help is welcome. Some strings are extracted using wxrc tool. It may be 
difficult to modify it and submit it back to the wxWindows community. But why 
not?

> I ran into a small problem when I just checked out the current cvs version
> and ran bootstrap. As usual there was some problem with automake. Lots of
> programs have problems with different versions of automake.

Yes, this is a kwown issue. Recent versions of Autoconf and Automake are 
needed.

> Maybe I should get on the mailinglist to discuss this (and read the
> archive).

We would welcome you on the list. You can register 
[EMAIL PROTECTED] from 
http://www.pgadmin.org/pgadmin2.php?ContentID=4.

Can I add you as a Swedish translator. No need to translate now. You can wait 
until you find time to do so.

Do not hesitate to contact me on [EMAIL PROTECTED] about 
translations.

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] pgAdmin3 translation request into Swedish

2003-06-30 Thread Dennis Björklund
On Mon, 30 Jun 2003, Jean-Michel POURE wrote:

> Can I add you as a Swedish translator. No need to translate now. You can wait 
> until you find time to do so.

Sure, do that.

-- 
/Dennis


---(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] pgAdmin3 translation request into Russian

2003-06-30 Thread Serguei Mokhov
Hello Jean-Michel,

Your proposal sounds like fun. I can also derive fr_CA
version of it if needed ;)

Thank you for considering me doing pgAdmin3 Russian
translation.

-s

- Original Message -
From: "Jean-Michel POURE" <[EMAIL PROTECTED]>
To: "Serguei A. Mokhov" <[EMAIL PROTECTED]>
Sent: June 30, 2003 7:45 AM
Subject: pgAdmin3 translation request into Russian


On Monday 30 June 2003 13:32, Dennis Björklund wrote:
> Here is another update of the swedish translation. I sent one a couple of
> months ago but it never was commited (and therefor not tested by anybody
> but me).

Dear Serguei,

We are wondering if you would like to contribe a translation into Russian of
pgAdmin3 (http://www.pgadmin.org/snapshots), PostgreSQL GUI developped under
wxWindows for GNU/Linux, Win32 and other Unix systems.

If you are interested, please find enclosed some documentation and guidelines.

If you are busy now and would like to register for a future translation, just
email me back and I will add your name to the ongoing translation work.

Cheers,
Jean-Michel POURE


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


[pgadmin-hackers] pga3: wxWindows pgAdmin3 Build

2003-06-30 Thread Dave Page
Hi all,

There is now a tarball of wxWindows specifically for use with pgAdmin3
available at
http://www.pgadmin.org/snapshots/wxWindows/wxWindows-pgAdmin3.tar.gz.
This is based on the wxWindows CVS tree as of 2003-06-18, and includes
Andreas' string.cpp patch.

The is the last known-to-be-good snapshot before the wx guys started
seriously hacking their tree about, therefore this version should be
used for future versions of pgAdmin3 for the forseeable future.

Regards, Dave.

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


Re: [pgadmin-hackers] pgAdmin3 translation request into Russian

2003-06-30 Thread Jean-Michel POURE
On Monday 30 June 2003 16:13, Serguei Mokhov wrote:
> Your proposal sounds like fun. I can also derive fr_CA
> version of it if needed ;)
>
> Thank you for considering me doing pgAdmin3 Russian
> translation.

Welcome Russia! Thank you very much for contributing your time and work. Do 
not hesitate to get back to us on the list for any question.

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] pgadmin3 on FreeBSD4.8

2003-06-30 Thread Hiroshi Saito
Hi Dave.

From: "Dave Page" <[EMAIL PROTECTED]>
> > From: Hiroshi Saito [mailto:[EMAIL PROTECTED]
(snip)
> > I am the environment that FreeBSD4.8 is important.
(snip)
> :-(. Is that just because of the older version of FreeBSD?

patch-kit of the ports collection and the package hadn't satisfied it yet
with 5.x in Japan.
It seems that it was very much gathered at present.
However, the user who still hopes for the stability is using 4.x.

> Do you have a test database you can email me that I can play with
> please?

pgdump-sql that it Andreas play here, is put.
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_unicode_debug6.sql

> > BTW.
> > Attached patch is necessary with this environment.
> > But, Is it likely to be unnecessary with FreeBSD5.1?
>
> I don't think so - it compiles and runs OK on 5.1 with tweaks to
> configure. Is there anything defined that we could use easily to detect
> FreeBSD 4 or 5?

It doesn't seem to be a problem with 5.1.

But, make with UNICODE is difficult with 4.8.

c++ -c   -I./lib/wx/include/gtk2ud-2.5 -I../include -I../src/zlib -pthread -
I/usr/local/include/gtk-2.0 -I/usr/local/lib/gtk-2.0/include -I/usr/local/in
clude/atk-1.0 -I/usr/local/include/pango-1.0 -I/usr/X11R6/include -I/usr/loc
al/include/glib-2.0 -I/usr/local/lib/glib-2.0/include -I/usr/local/include -
D_FILE_OFFSET_BITS=64 -D_LARGE_FILES-D__WXGTK__ -D__WXDEBUG__ -g -O0 -MM
D -pthread -D_THREAD_SAFE -Wall  -o accel.o ../src/generic/accel.cpp
In file included from ../include/wx/memory.h:20,
 from ../include/wx/object.h:25,
 from ../include/wx/event.h:20,
 from ../src/generic/accel.cpp:34:
../include/wx/string.h: In method `bool wxString::IsSameAs(__wchar_t, bool =
1) const':
../include/wx/string.h:653: implicit declaration of function `int
towupper(...)'
../src/generic/accel.cpp: In method
`wxAcceleratorTable::wxAcceleratorTable(int, const wxAcceleratorEntry *)':
../src/generic/accel.cpp:98: implicit declaration of function `int
iswlower(...)'
gmake: *** [accel.o] error 1

Because, it isn't defined fundamentally.
/usr/include/wctype.h
#if 0
/* XXX: not implemented */
.
wint_t  towlower __P((wint_t));
.
#endif

By one, this is the case that it is not UNICODE, and it is about the
attached patch.
atoll() is glibc2.0.2 higher.
It doesn't go into 4.8.

But, these are not problems if 4.8 is the policy which isn't made a support
object.
I can move by the thing which is not UNICODE at least. (single-byte)
I may have to have 5.1. But, I want to solve this.
Until it can be used in Japanese, ...

Regards,
Hiroshi-Saito


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

   http://archives.postgresql.org


Re: [pgadmin-hackers] pgadmin3 on FreeBSD4.8

2003-06-30 Thread Dave Page
Thanks, patch applied.

> -Original Message-
> From: Hiroshi Saito [mailto:[EMAIL PROTECTED] 
> Sent: 30 June 2003 03:27
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: pgadmin3 on FreeBSD4.8
> 
> 
> Hi Dave.
> 
> I am the environment that FreeBSD4.8 is important.
> It is tried variously to make it move.
> But, a movement by UNICODE (UTF-8) is difficult.
> So, it is being None support UNICODE.
> 
> screen shot in the examination. 
> http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_sample
5.jpg
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_sample6.jpg

I go into the Japanese adjustment from now.

BTW.
Attached patch is necessary with this environment. 
But, Is it likely to be unnecessary with FreeBSD5.1?

any comment?

Regards,
Hiroshi-Saito

---(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 on FreeBSD4.8

2003-06-30 Thread Dave Page


> -Original Message-
> From: Hiroshi Saito [mailto:[EMAIL PROTECTED] 
> Sent: 30 June 2003 17:51
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: pgadmin3 on FreeBSD4.8
> 
> 
> But, these are not problems if 4.8 is the policy which isn't 
> made a support object. I can move by the thing which is not 
> UNICODE at least. (single-byte) I may have to have 5.1. But, 
> I want to solve this. Until it can be used in Japanese, ...

Hi Hiroshi,

I see no reason why we should not try to support FreeBSD 4.8. We should
support as many platforms a possible, even if we do not provide binaries
for them - I have FreeBSD 4.6 here which I might try sometime.

Thank you for the test db.

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 translation request into Hungarian

2003-06-30 Thread Jean-Michel POURE
On Monday 30 June 2003 23:13, you wrote:
> I would say "no" currently due to my busy summer, but thinking on it more,
> I'll probably have the oppurtunity to translate pgAdmin3 until the end of
> July. I'll write an article about i18n in a Hungarian Linux Gazette soon
> and I'll show the method of it on pgAdmin3. I saw some screenshots and it
> looks very nice, congratulations! :-)

Dear Zoltan,

"Viva Hungary !". Thank you very much for your proposal. Take your time if you 
are busy. I am adding you to the list of translators. Is your name Zoltan 
Kovzol, are there any accents?

Thank you too to promote pgAdmin3 via screenshots in your i18n articles. Do 
not hesitate to send us a PDF of your article when ready, we would love to 
reproduce part of it on pgAdmin3 web site.

Cheers,
Jean-Michel


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


[pgadmin-hackers] First Debian package release

2003-06-30 Thread Raphaël Enrici
Dear all,

I've just uploaded a first version of pgAdmin3 Debian package for Woody 
on snake.
The package need some cleaning but it is there and works for me.
In particular, I need better build-requisites in the source package.
If some of you want to test, they'll be welcome!
Don't be too hard with me, it's a first step in the long way to build a 
good package :)

I added a README.Debian in the linux/debian directory which explain the 
install process.
(http://www.pgadmin.org/snapshots/linux/debian/README.Debian as soon as 
the mirror will be ok)

When the mirror will be synced, it should be as simple as this :
<- cut here ->
edit /etc/apt/sources.list and add the following line :
deb http://www.pgadmin.org/snapshots/linux/debian woody pgadmin
Do this as root:
apt-get update
apt-get install pgadmin3
<- cut here ->
Note that I didn't uploaded the wxWindows package because I'm waiting 
for an answer from Ron Lee.
I'll surely upload it tomorrow or the day after. wxWindows is required 
to build the package from source.
I'll complete instructions to do this just after this upload.

Regards,

Raphaël



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