[pgadmin-hackers] wxWindows Right to Left (RTL) Support
Dear friends, Upon request of translators, I am testing RTL support in poEdit and pgAdmin3. Arabic and Persian display from right to left. Apparently, wxWindows supports RTL: http://www.wxwindows.org/manuals/2.4.0/wx460.htm http://www.wxwindows.org/manuals/2.4.0/wx238.htm#wxlocale I tried poEdit and was able to paste UTF-8 Arabic and Persian characters from http://www.unics.uni-hannover.de/nhtcapri/multilingual1.html UTF-8 page to poEdit. I could count the right number of characters in poEdit but not display them. I suppose this is a question of fonts. Could you have a try on your stations? I will send you the .po and .mo files seperately. Cheers, Jean-Michel POURE ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-hackers] wxWindows Snapshot for pgAdmin3
Morning all, Yesterday I posted a message about having built a new wxWindows tarball for pgAdmin use, based on the 2003-06-18 wxWindows CVS. Unfortunately this version will not compile properly on FreeBSD 5.1 (specifically xrc which has had a number of changes committed). Therefore I have re-packaged the wxWindows snapshot from the earlier 2003-06-07 snapshot which many of us were running previously and does compile OK on FreeBSD. Apologies for any inconvenience. Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] First Debian package release
On Tuesday 01 July 2003 01:40, Raphaël Enrici wrote: 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) Dear Raphaël, I added the Debian instructions to http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3/docs/en_US/snapshots.html Cheers, Jean-Michel ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] [wx-dev] Right to Left (RTL) language support
On Tuesday 01 July 2003 12:42, Robert Roebling wrote: pgAdmin3 is compiled against wxGTK 2.5 cvs versin (of 18th June) with Unicode and GTK2 bindings. In which extent can wxWindows display RTL languages? The builtin-widgets (i.e. label, text edit) have full support for all sorts of scripts (including RTL) under GTK2. Robert Dear Robert, Thank you very much for this answer. If the selection of fonts automatic? Which fonts are displayed in Arabic and Persian under GTK2 and Win32? Cheers, Jean-Michel ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] [wx-dev] Right to Left (RTL) language support
On Tuesday 01 July 2003 13:48, Jean-Michel POURE wrote: On Tuesday 01 July 2003 12:42, Robert Roebling wrote: pgAdmin3 is compiled against wxGTK 2.5 cvs versin (of 18th June) with Unicode and GTK2 bindings. In which extent can wxWindows display RTL languages? The builtin-widgets (i.e. label, text edit) have full support for all sorts of scripts (including RTL) under GTK2. Robert Dear Robert, Thank you very much for this answer. If the selection of fonts automatic? Which fonts are displayed in Arabic and Persian under GTK2 and Win32? Nice to see that wxWdinows can work with GTK2. In this case I think pgAdmin3 and poEdit shouldn't have problems supporting RTL languages like Farsi and Arabic (at least on Linux). Jean-Michel, about fonts which support Arabic and Farsi language, we have developed some fonts which support these languages. You can get the font set at http://www.linuxiran.org/modules.php?name=Downloadsd_op=viewdownloadcid=6 these fonts work on both Linux and Windows. alternativly, if you have any of these fonts newspaper clearlyu or Arial Unicode MS, they support Farsi. The first two can usually be found in major Linux distributions. Cheers -- /* This sig has been ROT26 encrypted. Reading it is unlawful under the terms of the DMCA.*/ Aryan Ameri ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] [wx-dev] Right to Left (RTL) language support
On Tuesday 01 July 2003 13:48, Jean-Michel POURE wrote: On Tuesday 01 July 2003 12:42, Robert Roebling wrote: pgAdmin3 is compiled against wxGTK 2.5 cvs versin (of 18th June) with Unicode and GTK2 bindings. In which extent can wxWindows display RTL languages? The builtin-widgets (i.e. label, text edit) have full support for all sorts of scripts (including RTL) under GTK2. Robert Dear Robert, Thank you very much for this answer. If the selection of fonts automatic? Which fonts are displayed in Arabic and Persian under GTK2 and Win32? Nice to see that wxWdinows can work with GTK2. In this case I think pgAdmin3 and poEdit shouldn't have problems supporting RTL languages like Farsi and Arabic (at least on Linux). Jean-Michel, about fonts which support Arabic and Farsi language, we have developed some fonts which support these languages. You can get the font set at http://www.linuxiran.org/modules.php?name=Downloadsd_op=viewdownloadcid=6 these fonts work on both Linux and Windows. alternativly, if you have any of these fonts newspaper clearlyu or Arial Unicode MS, they support Farsi. The first two can usually be found in major Linux distributions. Cheers -- /* This sig has been ROT26 encrypted. Reading it is unlawful under the terms of the DMCA.*/ Aryan Ameri ---(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] Edit Data dialog
When using the edit data dialog, there should be a way to add a new row to a table with no data. Right now, I can edit the data of an empty table, enter my data, but then there doesn't seem to be any way for me to add the data. Also, when using the edit data dialog, a column named OIDS exists, which I don't really understand. Isn't that a database-specific column? Should it even be visible? ahp ---(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] Edit Data dialog
-Original Message- From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 17:16 To: Dave Page; [EMAIL PROTECTED] Subject: Edit Data dialog When using the edit data dialog, there should be a way to add a new row to a table with no data. Right now, I can edit the data of an empty table, enter my data, but then there doesn't seem to be any way for me to add the data. You can - just start typing in the row marked with a *. Also, when using the edit data dialog, a column named OIDS exists, which I don't really understand. Isn't that a database-specific column? Should it even be visible? PostgreSQL has an 'oid' column which is unique within a given table (in theory, unless oid wraparound occurs). It used to be common for people to use this column as part of their schema. Nowadays, you can create tables WITHOUT OIDS to prevent premature wraparound, however some people do still use them, so seeing them may be useful. Note that you cannot edit them. Incidently, I did notice that when editting data in the grid, you only seem to be able to append data to a string if it exceeds the width of the column on screen. To insert data anywhere in the string, you must resize the column such that it can hold the whole string visible at once. :-( 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] [HACKERS] Index expressions: how to recreate
Tom Lane wrote: Andreas Pflug [EMAIL PROTECTED] writes: I noticed the new expression functionality of indices and while implementing them in pgadmin3 was wonderingnow to extract the definition from the catalog. The best way is to use pg_get_indexdef(indexOID), same as pg_dump and psql do. So far for the SQL window, which will show just a plain (and hopefully nicely formatted. readable) sql query to recreate the index. Still, a verbose display of the indexes property is not possible this way, unless I parse the pg_get_indexdef output... pg_get_indexdef converts that string to a list of nodes (not surprising), while pg_get_expr whill join these list elements with an explicit and (according to a comment, needed for partial index). Do I need to retrieve indexprs and split it myself (counting brackets) or is there a pg_xxx function that could help me (pg_get_element(indexprs, 0...n)) ? Actually it should be read as 1 0 4 0. The output converter for int2vector suppresses trailing zeroes, for largely-historical reasons. Ok, I understand that, because indkey[n4] will deliver 0 too, and indnatts will show that 4 arguments are needed. Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
