Re: [pgadmin-hackers] gettext template for pgadmin3

2003-06-24 Thread Dave Page


 -Original Message-
 From: Howard Bagcat [mailto:[EMAIL PROTECTED] 
 Sent: 24 June 2003 16:13
 To: [EMAIL PROTECTED]
 Subject: [pgadmin-hackers] gettext template for pgadmin3
 
 
 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. :)

Hi Howard,

Any new translations will be gratefully received. You can find the .pot
file in CVS - on the web it's in
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3/

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] gettext template for pgadmin3

2003-06-24 Thread Andreas Pflug
Howard Bagcat wrote:

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. :)
 

Hello Howard,

sure there is! Look at http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3

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.
Using poEdit from poedit.sourceforge.org makes it easy editing a new 
language. Look at HOWTOTRANSLATE.txt for further instructions.

Regards,
Andreas
 



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


Re: [pgadmin-hackers] pgAdmin3 doc location

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

I think share/doc/lang_country in parallel with share/ui/lang_country.

pgAdmin will now try to locate a doc version that fits the language 
settings, and will fall back to en_US.
The options setting is removed.

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


Re: [pgadmin-hackers] Request for translation of pgAdmin3 into Traditional Chinese

2003-06-24 Thread Jean-Michel POURE
 Dear Jean-Michel,

 I appreciate your kind invitation to join the translation team of pgAdmin3.
 I am an amateur programmer using visual basic and java, however, without
 any experience on c++. I know nothing how the i18n is done in wxWindows.
 Actually, I have no idea how Gettext and poEdit work. Could you provide me
 more information on how should I do to make a translation file for your
 project?

 sincerely,

 Chih-Hsin Lee,
 Department of Internal Medicine,
 Far-Eastern Memorial Hospital, Taiwan

Dear Chih-Hsin,

Thank you very much! We would be very gratefull if you could help for the 
translation of pgAdmin3. You do not need to be a programmer to translate. 
Please find enclosed a copy of the translation_steps.html file, which can be 
found in our documentation.

So not hesitate to come back to us for any question.

Best regards,
Jean-Michel POURE
Title: Translation steps








Translation steps


	pgAdmin3 is a localised application, which means it was designed to be easily translated into several languages, using Gettext technologies and Unicode (UTF-8). Also, as described in the translation guidelines, we made sure that all strings could be translated.



  Anyone can translate pgAdmin3 into his/her mother tongue. You don't need to be a programmer. The required steps for translation are the followings:



  
Declare yourself as a translator by sending an email to pgAdmin3 [EMAIL PROTECTED] mailing list. Anonymous post is not aloud, you may need to subscribe by sending an email to [EMAIL PROTECTED] with subject "subscribe".

In the case of widely spread European and Asian languages, we prefer native speakers translating to their mother tongue. In the case of less common languages, we have no special requirements.
  

  
  Download and install a Gettext translation software. We recommend using poEdit as it can be installed under GNU/Linux or MS Windows and has a nice GUI interface, which makes translating easier.
  

  
  Download the latest pgadmin3.pot language file from CVS. There are two ways of doing it:
		
	
			The easy way
  
  Download pgadmin3.pot from our graphical CVS interface. It is very fast, but if you are planning to update your translations often, you may prefer to checkout from CVS.
  
  The hard way
  
  Checkout pgAdmin3 source code using a CVS client. Under Windows, we recommend using WinCVS. Under GNU/Linux, there are several command lines and graphical clients available.
  
  Anonymous read access is available at the following CVSRoot (no password is required): <:pserver:[EMAIL PROTECTED]:/disk1/cvsroot>. You need to checkout pgadmin3 repository.
  
  Under GNU/Linux, the checkout command line is:
  
			# cvs -d :pserver:[EMAIL PROTECTED]:/disk1/cvsroot co pgadmin3
  
  
  Create an empty folder in pgadmin3/src/ui, using the "Languagecode_COUNTRYCODE" code, like for example de_DE (German spoken in Germany), fr_FR (French spoken in France), pt_BR (Portuguese spoken in Brazil), etc... The list of language codes can be found on Debian site. Copy the .pot file to the new folder and rename it pgadmin3.po.

  

  Translate the pgadmin3.po file into your mother tongue. Because poEdit is sometimes instable, do not hesitate to save partial work every 10 minutes.
  
	

  When the translation is finished, send the resulting pgadmin3.po and pgadmin3.pot files to [EMAIL PROTECTED] after zipping of taring them.
	
	

  
	Because pgAdmin3 is under heavy development, we recommend updating translations regularly. Under GNU/Linux, you can retrieve the latest pgadmin3.pot with:
  
	# cd path_to_pgadmin3_source_code
  
  # cvs update -P -C -d
  
	poEdit has a nice feature, at startup of software, which merges the updated pgadmin3.pot file into your pgadmin.po file.
  
  When you are finished with translations, create a patch:
  
	# cvs diff -u path_to_your_pgadmin3_po_file > language_patch.txt
  
  and send it to us.
  






---(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] Documentation location problem

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

Dear all,

When opening the online help, I have the following error:
Unable to open requested HTML document: /usr/bin.../docs/en_US/index.html
When it should be:
/usr/share/pgadmin3/docs/en_US/index.html
Was a typo in pgAdmin3.cpp; corrected.

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


Re: [pgadmin-hackers] gettext template for pgadmin3

2003-06-24 Thread Hiroshi Saito
Hi Howard.

It may have already been solved by the advice of  Dave and Andreas
and the document of Jean.
Say if I can help it.

I think about the way that the one for the difference copes with it from
now.

regards,
Hiroshi-Saito

From: Howard Bagcat [EMAIL PROTECTED]
 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)


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

2003-06-24 Thread Jean-Michel POURE
On Tuesday 24 June 2003 16:46, Darko Prenosil wrote:
 Confirmed ! I hope this weekend should be enough time to do it.
 I do not know how many users here in Croatia use the pgAdmin, but however,
 I translated PostgreSQL server messages , why not pgAdmin's ?

 I guess PostgreSQL service manager will wait until this is finished. For
 the information same translations can be used for BosnaHercegovina and
 Serbia. The dialect is a bit different, but they understand Croatian
 perfectly.

Thank you very much for your support, we really appreciate your help. We will 
add you to the list of translators. Please find enclosed a translation HOWTO. 
You may not need to read them as you already translated PostgreSQL messages.

Cheers,
Jean-Michel


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

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


Re: [pgadmin-hackers] Translation HOWTO

2003-06-24 Thread Weiping He
Hi, all

   We are translating the pot file to Chinese.
   Wish could finish it ASAP and submit it.
Regards

Weiping

Jean-Michel POURE wrote:

Dear Andreas,

I just noticed your new HOWTOTRANSLATE.txt file on top of the repository.

It is better explained than the HTML documentation I just committed to CVS. 
Therefore, I will merge your text into mine. When it is finished, I will send 
you an email for review, so that we work on the sames files.

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



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


Re: [pgadmin-hackers] Translation HOWTO

2003-06-24 Thread Jean-Michel POURE
On Tuesday 24 June 2003 17:33, Weiping He wrote:
 We are translating the pot file to Chinese.
 Wish could finish it ASAP and submit it.

Thank you very much. I am adding you to the translator list. We welcome your 
support. Is it simplified Chinese according to your com.cn extension?

Best regards,
Jean-Michel


---(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] pgAdmin3 stack trace

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

With the help of Reinhard, we finally got pgAdmin3 to compile under SuSE 8.2 
and uploaded RPMs to snapshots. Unfortunately, there is a segfault when 
running pgAdmin3. I am sending you the stack file seperately.

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


Re: [pgadmin-hackers] pgAdmin3 feature freeze?

2003-06-24 Thread Hiroshi Saito
Hi Andreas.

I am sorry that my response is dull...

I thought how pgadmin3 should handle LargeObject.
There is the following three approach with pgsql-7.3 as the way of handling
it.

1) It has the one related to the reference with column-OID.
Then, the actual condition is pg_lageobject.
   This suggests the standard use of psql.

2) It has the one related to the reference with column-lo.
   column data by the definition of  Type-lo
 This has been the property of the way of using it since the old days of
ODBC-Driver.

3)  It goes into column-bytea directly.
 This makes use with new ODBC possible.

It thinks that it has a headache.
Is there any thought?

---
Though a topic strays, Dave.
Usage Version7.3 following with ODBC.

CREATE FUNCTION lo_in(cstring)
   RETURNS lo
   AS 'int4in'
   LANGUAGE 'internal' WITH (ISCACHABLE, ISSTRICT);

CREATE FUNCTION lo_out(lo)
   RETURNS cstring
   AS 'int4out'
   LANGUAGE 'internal' WITH (ISCACHABLE, ISSTRICT);

CREATE TYPE lo (
   internallength = 4,
   externallength=10,
   input = lo_in,
   output = lo_out,
   alignment = int4,
   default = '',
   passedbyvalue
);

And Cast is necessary to begin to lead OID.

CREATE CAST (lo AS oid) WITHOUT FUNCTION;

Regards,
Hiroshi-Saito


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


Re: [pgadmin-hackers] Translation HOWTO

2003-06-24 Thread Weiping He
Jean-Michel POURE wrote:

On Tuesday 24 June 2003 17:33, Weiping He wrote:
 

We are translating the pot file to Chinese.
   Wish could finish it ASAP and submit it.
   

Thank you very much. I am adding you to the translator list. We welcome your 
support. Is it simplified Chinese according to your com.cn extension?

Best regards,
Jean-Michel
---(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
 

yes, it's simplified Chinese.

Thanks and Regards

Laser

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


[pgadmin-hackers] Linux QueryBuilder error

2003-06-24 Thread Adam H . Pendleton
I have tracked down the QueryBuilder error, and it's not a wxWindows 
error, per se.  The problem lies in the frmQueryBuilder::OnSize() event 
handler.  Basically, the QueryBuilder form receives the OnSize event 
*before* the form has been created.  Here is a thread from the 
wxWindows list, discussing a similar problem a user had with a Windows 
application:

http://lists.wxwindows.org/archive/wx-users/msg05277.html

Our situation is a bit different, because the code called by 
frmQueryBuilder::OnSize is wxWindows code, and not custom code, 
buthere is the problem.  In src/generic/laywin.cpp (from 
wxWindows), the LayoutMDIFrame() function, calls the following code:

wxWindow* clientWindow = frame-GetClientWindow();

rect = event.GetRect();

clientWindow-SetSize(rect.x, rect.y, rect.width, rect.height);

Basically, frame-GetClientWindow() returns NULL, causing SetSize 
(which is a macro) to cause a segfault in DoSetSize(clientWindow, 
etc.).  The variable 'frame' is passed to LayoutMDIFrame by our code: 
LayoutMDIFrame(this).
frame-GetClientWindow() is indeed null as frame-m_clientWindow = 0x0. 
 I am looking for a solution to the problem, but I wanted to send it to 
the list in case someone could fix it faster than I could.

ahp


PGP.sig
Description: PGP signature


[pgadmin-hackers] Further QueryBuilder problems

2003-06-24 Thread Adam H . Pendleton
So, for the sake of a quick test, I commented out the code in 
frmQueryBuilder::OnSize() and pgAdmin3 happily started to display the 
query builder, but it crashed again.  This time it gets a segfault in 
wxListBase::GetFirst() const (this=0x30) at list.h:270 in list.  I will 
investigate further.  Perhaps someone who is more familiar with the 
Query Builder code can comment out the OnSize code and then debug this 
second problem.

ahp


PGP.sig
Description: PGP signature


Re: [pgadmin-hackers] Linux QueryBuilder error

2003-06-24 Thread Dave Page
Nice catch!

Regards, Dave.

 -Original Message-
 From: Adam H.Pendleton [mailto:[EMAIL PROTECTED] 
 Sent: 24 June 2003 21:39
 To: [EMAIL PROTECTED]
 Subject: [pgadmin-hackers] Linux QueryBuilder error
 
 
 I have tracked down the QueryBuilder error, and it's not a wxWindows 
 error, per se.  The problem lies in the 
 frmQueryBuilder::OnSize() event 
 handler.  Basically, the QueryBuilder form receives the OnSize event 
 *before* the form has been created.  Here is a thread from the 
 wxWindows list, discussing a similar problem a user had with 
 a Windows 
 application:
 
http://lists.wxwindows.org/archive/wx-users/msg05277.html

Our situation is a bit different, because the code called by 
frmQueryBuilder::OnSize is wxWindows code, and not custom code, 
buthere is the problem.  In src/generic/laywin.cpp (from 
wxWindows), the LayoutMDIFrame() function, calls the following code:

wxWindow* clientWindow = frame-GetClientWindow();

rect = event.GetRect();

clientWindow-SetSize(rect.x, rect.y, rect.width, rect.height);

Basically, frame-GetClientWindow() returns NULL, causing SetSize 
(which is a macro) to cause a segfault in DoSetSize(clientWindow, 
etc.).  The variable 'frame' is passed to LayoutMDIFrame by our code: 
LayoutMDIFrame(this).
frame-GetClientWindow() is indeed null as frame-m_clientWindow = 0x0.
  I am looking for a solution to the problem, but I wanted to send it to

the list in case someone could fix it faster than I could.

ahp

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

   http://archives.postgresql.org


Re: [pgadmin-hackers] pgAdmin3 feature freeze?

2003-06-24 Thread Hiroshi Saito
Hi Andreas.

From: Andreas Pflug [EMAIL PROTECTED]
 Hiroshi Saito wrote:

 Hi Andreas.
 
 I am sorry that my response is dull...
 
 I thought how pgadmin3 should handle LargeObject.
 There is the following three approach with pgsql-7.3 as the way of
handling
 it.
 
 
 Hiroshi,
 pgAdmin3 doesn't handle blobs at the moment, because it doesn't work
 with data a lot. If a selected column contains lo or bytea, the string
 output of libpq is shown. This might not be pretty looking, but
 interpretation of a blob is up to an application. I don't see a way to
 handle this in a meaningful way for the tools we have in pgAdmin3 at the
 moment.
 This might change if we support some dump/restore or load functionality,
 but this is a feature of forthcoming versions.

It was understood.
With the material which I enjoy.

Regards,
Hiroshi-Saito



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


[pgadmin-hackers] patch of wxstring, ..

2003-06-24 Thread Hiroshi Saito
Hi Andreas.

vadz isn't testing MultiByte
Hmm

I am not certain if it is seen though a comment and information were
contributed, either.
Is information insufficient in this?

http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/string_Before.jpg
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/string_After.jpg
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/MultiByteTest.cpp

Can I help besides?

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])

[pgadmin-hackers] pgConn.cpp.patch

2003-06-24 Thread Adam H . Pendleton
This patch fixes a bug in the error reporting of the new connection 
dialog when setting the database encoding.

ahp


pgConn.cpp.patch
Description: Binary data


PGP.sig
Description: PGP signature