[pgadmin-hackers] Translation
Hi. I'm intersted to translate pgadmin into Macedonian. Please, tell me where can I send informations, English and translated names of my language: 'French' and 'Franais', 'German' and 'Deutsch', etc. ? ---(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] Translation
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ? Sent: 28 January 2005 08:25 To: pgadmin-hackers@postgresql.org Subject: [pgadmin-hackers] Translation Hi. I'm intersted to translate pgadmin into Macedonian. Please, tell me where can I send informations, English and translated names of my language: 'French' and 'Franais', 'German' and 'Deutsch', etc. ? Hi, Please send translations to this list and one of us can commit them to CVS. What will the correct language code be, mk_MK ? Thanks for offering to help :-) Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-hackers] CVS Commit by dpage: Note pgInstaller download location
Log Message: --- Note pgInstaller download location Modified Files: -- www/pgadmin3/cnt: cnt_download.php (r1.73 - r1.74) Index: cnt_download.php === RCS file: /projects/www/pgadmin3/cnt/cnt_download.php,v retrieving revision 1.73 retrieving revision 1.74 diff -Lpgadmin3/cnt/cnt_download.php -Lpgadmin3/cnt/cnt_download.php -u -w -r1.73 -r1.74 --- pgadmin3/cnt/cnt_download.php +++ pgadmin3/cnt/cnt_download.php @@ -304,14 +304,16 @@ h1 id=win32?php echo _(MS Windows 2000 XP);?/h1 dl -dt?php echo sprintf(_(Packager: %s), Andreas Pflug);?/dt +dt?php echo sprintf(_(Packager: %s), Dave Page);?/dt dd ?php echo sprintf(_(pgAdmin III packages are available for %s.), MS Windows 2000/XP);? + brbr + ?php echo echo _(Note that the a href=\http://www.postgresql.org/ftp/win32/\;pgInstaller distribution of PostgreSQL for Windows/a comes with pgAdmin.);? /dd dd ?php echo sprintf(_(Download pgAdmin III package from our a href='%s'mirrors/a.), #mirrors);? - ?php echo On each mirror, the packages are located in:;? + ?php echo _(On each mirror, the packages are located in:);? /dd dd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-hackers] CVS Commit by dpage: Add Macedonian per tinodj at on.net.mk
Log Message: --- Add Macedonian per tinodj at on.net.mk Modified Files: -- pgadmin3/src/ui: pgadmin3.lng (r1.43 - r1.44) Index: pgadmin3.lng === RCS file: /projects/pgadmin3/src/ui/pgadmin3.lng,v retrieving revision 1.43 retrieving revision 1.44 diff -Lsrc/ui/pgadmin3.lng -Lsrc/ui/pgadmin3.lng -u -w -r1.43 -r1.44 --- src/ui/pgadmin3.lng +++ src/ui/pgadmin3.lng @@ -43,6 +43,7 @@ Japanese, 日本 Latvian, Latviešu Lithuanian, Lietuviskai +Macedonian, Македонски Norwegian (Bokmal), Norwegian (Bokmal) Polish, Polski Portuguese, Português ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-hackers] CVS Commit by dpage: Add Macedonian per tinodj at on.net.mk
Log Message: --- Add Macedonian per tinodj at on.net.mk Modified Files: -- www/pgadmin3/cnt: cnt_translation_status.php (r1.78 - r1.79) Index: cnt_translation_status.php === RCS file: /projects/www/pgadmin3/cnt/cnt_translation_status.php,v retrieving revision 1.78 retrieving revision 1.79 diff -Lpgadmin3/cnt/cnt_translation_status.php -Lpgadmin3/cnt/cnt_translation_status.php -u -w -r1.78 -r1.79 --- pgadmin3/cnt/cnt_translation_status.php +++ pgadmin3/cnt/cnt_translation_status.php @@ -1,4 +1,4 @@ -?php +?php // // Copyright pgAdmin Team 2003 // Released under the BSD licence @@ -33,6 +33,7 @@ $translated-addLanguage (ja_JP, Japanese, 斉藤 浩 (Hiroshi Saito), [EMAIL PROTECTED], pgadmin3.po, src/ui/ja_JP/pgadmin3.po, pgadmin3.pot, pgadmin3.pot); $outofdate-addLanguage (lt_LT, Lithuanian, Linas Jankauskas, [EMAIL PROTECTED], pgadmin3.po, src/ui/lt_LT/pgadmin3.po, pgadmin3.pot, pgadmin3.pot); $translated-addLanguage (lv_LV, Latvian, Lauris Bukšis, [EMAIL PROTECTED], pgadmin3.po, src/ui/lv_LV/pgadmin3.po, pgadmin3.pot, pgadmin3.pot); + $outofdate-addLanguage (mk_MK, Macedonian, Валентин Ѓорѓиоски, [EMAIL PROTECTED], pgadmin3.po, src/ui/mk_MK/pgadmin3.po, pgadmin3.pot, pgadmin3.pot); $outofdate-addLanguage (nb_NO, Norwegian Bokmål, Brage Førland, [EMAIL PROTECTED], pgadmin3.po,src/ui/nb_NO/pgadmin3.po, pgadmin3.pot, pgadmin3.pot); $translated-addLanguage (nl_NL, Dutch, Fred van Bemmel, [EMAIL PROTECTED], pgadmin3.po, src/ui/nl_NL/pgadmin3.po, pgadmin3.pot, pgadmin3.pot); $translated-addLanguage (pl_PL, Polish, Slawomir Sudnik, [EMAIL PROTECTED], pgadmin3.po, src/ui/pl_PL/pgadmin3.po, pgadmin3.pot, pgadmin3.pot); ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] CVS Commit by dpage: New Directory
Update of /projects/pgadmin3/src/ui/mk_MK In directory developer.pgadmin.org:/tmp/cvs-serv19983/mk_MK Log Message: Directory /projects/pgadmin3/src/ui/mk_MK added to the repository ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-hackers] CVS Commit by andreas: table statistics including TOAST and indexes
Log Message: --- table statistics including TOAST and indexes Modified Files: -- pgadmin3: BUGS.txt (r1.65 - r1.66) CHANGELOG.txt (r1.180 - r1.181) Index: BUGS.txt === RCS file: /projects/pgadmin3/BUGS.txt,v retrieving revision 1.65 retrieving revision 1.66 diff -LBUGS.txt -LBUGS.txt -u -w -r1.65 -r1.66 --- BUGS.txt +++ BUGS.txt @@ -1,7 +1,8 @@ bKnown issues/b ul li[Edit grid] bool editing doesn't know NULL; major redesign needed - li[Properties] GRANT option problems + li[Properties] GRANT WITH GRANT OPTION problems + li[all] suppressed public. prefix leads to modified objects in wrong schema if found in search_path /ulbr bKnown wxWindows issues/b ul Index: CHANGELOG.txt === RCS file: /projects/pgadmin3/CHANGELOG.txt,v retrieving revision 1.180 retrieving revision 1.181 diff -LCHANGELOG.txt -LCHANGELOG.txt -u -w -r1.180 -r1.181 --- CHANGELOG.txt +++ CHANGELOG.txt @@ -17,6 +17,7 @@ /ul br ul +li2005-01-14 AP 1.2.1 table statistics including TOAST and indexes li2005-01-14 AP 1.2.1 fix adding sequence columns li2005-01-14 AP 1.2.1 fix Grant Wizard for functions (r: Robert Köpferl) li2005-01-14 AP 1.2.1 fix reengineered DOMAIN with CHECK (r: Robert Köpferl) ---(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] CVS Commit by andreas: table statistics including TOAST and indexes
Log Message:
---
table statistics including TOAST and indexes
Modified Files:
--
pgadmin3/src/schema:
pgCollection.cpp (r1.36 - r1.37)
pgTable.cpp (r1.60 - r1.61)
Index: pgCollection.cpp
===
RCS file: /projects/pgadmin3/src/schema/pgCollection.cpp,v
retrieving revision 1.36
retrieving revision 1.37
diff -Lsrc/schema/pgCollection.cpp -Lsrc/schema/pgCollection.cpp -u -w -r1.36
-r1.37
Index: pgTable.cpp
===
RCS file: /projects/pgadmin3/src/schema/pgTable.cpp,v
retrieving revision 1.60
retrieving revision 1.61
diff -Lsrc/schema/pgTable.cpp -Lsrc/schema/pgTable.cpp -u -w -r1.60 -r1.61
--- src/schema/pgTable.cpp
+++ src/schema/pgTable.cpp
@@ -426,12 +426,16 @@
wxT(, tidx_blks_hit AS ) + qtIdent(_(Toast Index Blocks Hit));
if (GetConnection()-HasFeature(FEATURE_SIZE))
-sql += wxT(, pg_size_pretty(pg_relation_size(stat.relid)) AS ) +
qtIdent(_(Table Size));
-
+{
+sql += wxT(, pg_size_pretty(pg_relation_size(stat.relid)) AS ) +
qtIdent(_(Table Size))
++ wxT(, CASE WHEN cl.reltoastrelid = 0 THEN ) +
qtString(_(none)) + wxT( ELSE
pg_size_pretty(pg_relation_size(cl.reltoastrelid)) END AS ) + qtIdent(_(Toast
Table Size))
++ wxT(, pg_size_pretty(COALESCE((SELECT
SUM(pg_relation_size(indexrelid)) FROM pg_index WHERE
indrelid=stat.relid)::int8, 0)) AS ) + qtIdent(_(Indexes Size));
+}
sql += wxT(\n)
-wxT( FROM pg_stat_all_tables stat, pg_statio_all_tables statio\n)
-wxT( WHERE stat.relid = statio.relid\n)
-wxT( AND stat.relid = ) + GetOidStr();
+wxT( FROM pg_stat_all_tables stat\n)
+wxT( JOIN pg_statio_all_tables statio ON stat.relid =
statio.relid\n)
+wxT( JOIN pg_class cl ON cl.oid=stat.relid\n)
+wxT( WHERE stat.relid = ) + GetOidStr();
DisplayStatistics(statistics, sql);
}
@@ -467,7 +471,7 @@
wxT( LEFT OUTER JOIN pg_tablespace ta on
ta.oid=rel.reltablespace\n)
wxT( LEFT OUTER JOIN pg_description des ON des.objoid=rel.oid
AND des.objsubid=0\n)
wxT( LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND
c.contype='p'\n)
-wxT( WHERE ((relkind = 'r') OR (relkind = 's')) AND relnamespace
= ) + collection-GetSchema()-GetOidStr() + wxT(\n)
+wxT( WHERE relkind IN ('r','s','t') AND relnamespace = ) +
collection-GetSchema()-GetOidStr() + wxT(\n)
+ restriction +
wxT( ORDER BY relname));
}
@@ -479,7 +483,7 @@
wxT( FROM pg_class rel\n)
wxT( LEFT OUTER JOIN pg_description des ON des.objoid=rel.oid
AND des.objsubid=0\n)
wxT( LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND
c.contype='p'\n)
-wxT( WHERE ((relkind = 'r') OR (relkind = 's')) AND relnamespace
= ) + collection-GetSchema()-GetOidStr() + wxT(\n)
+wxT( WHERE relkind IN ('r','s','t') AND relnamespace = ) +
collection-GetSchema()-GetOidStr() + wxT(\n)
+ restriction +
wxT( ORDER BY relname));
}
@@ -533,12 +537,15 @@
if (hasSize)
statistics-AddColumn(_(Size), 60);
-wxString sql=wxT(SELECT relname, n_tup_ins, n_tup_upd, n_tup_del);
+wxString sql=wxT(SELECT st.relname, n_tup_ins, n_tup_upd, n_tup_del);
if (hasSize)
-sql += wxT(, pg_size_pretty(pg_relation_size(relid)) AS size);
-
-sql += wxT(\n FROM pg_stat_all_tables)
- wxT(\n WHERE schemaname = ) +
qtString(collection-GetSchema()-GetName())
+sql += wxT(, pg_size_pretty(pg_relation_size(st.relid))
+ wxT( + CASE WHEN cl.reltoastrelid = 0 THEN 0 ELSE
pg_relation_size(cl.reltoastrelid) END)
+ wxT( + COALESCE((SELECT SUM(pg_relation_size(indexrelid)) FROM
pg_index WHERE indrelid=st.relid)::int8, 0)) AS size);
+
+sql += wxT(\n FROM pg_stat_all_tables st)
+ wxT( JOIN pg_class cl on cl.oid=st.relid\n)
+ wxT( WHERE schemaname = ) +
qtString(collection-GetSchema()-GetName())
+ wxT(\n ORDER BY relname);
pgSet *stats = collection-GetDatabase()-ExecuteSet(sql);
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[pgadmin-hackers] CVS Commit by andreas: table statistics including TOAST and indexes
Log Message:
---
table statistics including TOAST and indexes
Tags:
REL-1_2_0_PATCHES
Modified Files:
--
pgadmin3/src/schema:
pgTable.cpp (r1.59.2.1 - r1.59.2.2)
Index: pgTable.cpp
===
RCS file: /projects/pgadmin3/src/schema/pgTable.cpp,v
retrieving revision 1.59.2.1
retrieving revision 1.59.2.2
diff -Lsrc/schema/pgTable.cpp -Lsrc/schema/pgTable.cpp -u -w -r1.59.2.1
-r1.59.2.2
--- src/schema/pgTable.cpp
+++ src/schema/pgTable.cpp
@@ -426,12 +426,16 @@
wxT(, tidx_blks_hit AS ) + qtIdent(_(Toast Index Blocks Hit));
if (GetConnection()-HasFeature(FEATURE_SIZE))
-sql += wxT(, pg_size_pretty(pg_relation_size(stat.relid)) AS ) +
qtIdent(_(Table Size));
-
+{
+sql += wxT(, pg_size_pretty(pg_relation_size(stat.relid)) AS ) +
qtIdent(_(Table Size))
++ wxT(, CASE WHEN cl.reltoastrelid = 0 THEN ) +
qtString(_(none)) + wxT( ELSE
pg_size_pretty(pg_relation_size(cl.reltoastrelid)) END AS ) + qtIdent(_(Toast
Table Size))
++ wxT(, pg_size_pretty(COALESCE((SELECT
SUM(pg_relation_size(indexrelid)) FROM pg_index WHERE
indrelid=stat.relid)::int8, 0)) AS ) + qtIdent(_(Indexes Size));
+}
sql += wxT(\n)
-wxT( FROM pg_stat_all_tables stat, pg_statio_all_tables statio\n)
-wxT( WHERE stat.relid = statio.relid\n)
-wxT( AND stat.relid = ) + GetOidStr();
+wxT( FROM pg_stat_all_tables stat\n)
+wxT( JOIN pg_statio_all_tables statio ON stat.relid =
statio.relid\n)
+wxT( JOIN pg_class cl ON cl.oid=stat.relid\n)
+wxT( WHERE stat.relid = ) + GetOidStr();
DisplayStatistics(statistics, sql);
}
@@ -467,7 +471,7 @@
wxT( LEFT OUTER JOIN pg_tablespace ta on
ta.oid=rel.reltablespace\n)
wxT( LEFT OUTER JOIN pg_description des ON des.objoid=rel.oid
AND des.objsubid=0\n)
wxT( LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND
c.contype='p'\n)
-wxT( WHERE ((relkind = 'r') OR (relkind = 's')) AND relnamespace
= ) + collection-GetSchema()-GetOidStr() + wxT(\n)
+wxT( WHERE relkind IN ('r','s','t') AND relnamespace = ) +
collection-GetSchema()-GetOidStr() + wxT(\n)
+ restriction +
wxT( ORDER BY relname));
}
@@ -479,7 +483,7 @@
wxT( FROM pg_class rel\n)
wxT( LEFT OUTER JOIN pg_description des ON des.objoid=rel.oid
AND des.objsubid=0\n)
wxT( LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND
c.contype='p'\n)
-wxT( WHERE ((relkind = 'r') OR (relkind = 's')) AND relnamespace
= ) + collection-GetSchema()-GetOidStr() + wxT(\n)
+wxT( WHERE relkind IN ('r','s','t') AND relnamespace = ) +
collection-GetSchema()-GetOidStr() + wxT(\n)
+ restriction +
wxT( ORDER BY relname));
}
@@ -533,12 +537,15 @@
if (hasSize)
statistics-AddColumn(_(Size), 60);
-wxString sql=wxT(SELECT relname, n_tup_ins, n_tup_upd, n_tup_del);
+wxString sql=wxT(SELECT st.relname, n_tup_ins, n_tup_upd, n_tup_del);
if (hasSize)
-sql += wxT(, pg_size_pretty(pg_relation_size(relid)) AS size);
-
-sql += wxT(\n FROM pg_stat_all_tables)
- wxT(\n WHERE schemaname = ) +
qtString(collection-GetSchema()-GetName())
+sql += wxT(, pg_size_pretty(pg_relation_size(st.relid))
+ wxT( + CASE WHEN cl.reltoastrelid = 0 THEN 0 ELSE
pg_relation_size(cl.reltoastrelid) END)
+ wxT( + COALESCE((SELECT SUM(pg_relation_size(indexrelid)) FROM
pg_index WHERE indrelid=st.relid)::int8, 0)) AS size);
+
+sql += wxT(\n FROM pg_stat_all_tables st)
+ wxT( JOIN pg_class cl on cl.oid=st.relid\n)
+ wxT( WHERE schemaname = ) +
qtString(collection-GetSchema()-GetName())
+ wxT(\n ORDER BY relname);
pgSet *stats = collection-GetDatabase()-ExecuteSet(sql);
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[pgadmin-hackers] CVS Commit by andreas: todo update
Log Message: --- todo update Modified Files: -- pgadmin3: TODO.txt (r1.128 - r1.129) Index: TODO.txt === RCS file: /projects/pgadmin3/TODO.txt,v retrieving revision 1.128 retrieving revision 1.129 diff -LTODO.txt -LTODO.txt -u -w -r1.128 -r1.129 --- TODO.txt +++ TODO.txt @@ -15,6 +15,8 @@ liEnhancements ul + liTrack connection usage by property dialogs to prevent closing used connections + liAllow Sequence to be attached to existing int4/int8 columns liDisplay column comments in table definition liAllow unix socket connections liAllow server registration without connect ---(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] CVS Commit by andreas: faq update
Log Message: --- faq update Modified Files: -- www/pgadmin3/faq: index.php (r1.12 - r1.13) Index: index.php === RCS file: /projects/www/pgadmin3/faq/index.php,v retrieving revision 1.12 retrieving revision 1.13 diff -Lpgadmin3/faq/index.php -Lpgadmin3/faq/index.php -u -w -r1.12 -r1.13 --- pgadmin3/faq/index.php +++ pgadmin3/faq/index.php @@ -18,6 +18,7 @@ A HREF=#UnsuppProtocolServer log: unsupported protocol/ABR A HREF=#FontProblem1Font problem: too big/ABR A HREF=#FontProblem2Font problem: SQL shows weird characters/ABR +A HREF=#gtk-qtCrash on Linux: QPixmap: Invalid pixmap parameters/ABR A HREF=#ConnDropConnection to database dropped/ABR A HREF=#EncodingProblemEncoding Problem: My data is not shown/ABR /B @@ -169,13 +170,23 @@ font to have a correct display. [AP] /pbr +H3A Name=gtk-qtCrash on Linux: Qpixmap: Invalid pixmap parameters/A/H3 +p +When running on a machine with gtk-qt-engine installed, pgAdmin III will crash with a +segmentation fault. A console will print QPixmap: Invalid pixmap parameters. +p/p +This is caused by a broken gtk-qt-engine; not only pgAdmin III suffers from this. +p/p +To fix, remove the broken gtk-qt-engine or install a fixed version if available. +/pbr H3A Name=ConnDropConnection to database dropped/A/H3 p I'm connecting to the database server via a firewall. After some minutes of inactivity, the connection to the database is dropped. Some admins report that bogus backend processes remain that are never terminated. /pp -Unfortunately some network administrators extend functions meant for external web server access to cover +Unfortunately some network administrators or default firewall settings extend functions +meant for external web server access to cover internal database traffic too. After some minutes of inactivity, the TCP/IP connection is interrupted without notice to both sides of the connection. As a result, the backend doesn't know that there's no connection to the client (in this case: pgAdmin III, but any ---(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] dlgUser.xrc_patch.txt
Hiroshi Saito wrote: Hi Andreas. I want this hidden. Check this, please. I never did this because the SQL page will show it anyway, and there's no prerequisite to suppress it there. Regards, Andreas ---(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] Translate to pt_BR
Hello, Im translating pgAdmin to brazillian portuguese (pt_BR), soon as possible I will send the file. -Adriano ---(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] CVS Commit by dpage: Fix page
Log Message: --- Fix page Modified Files: -- www/pgadmin3/cnt: cnt_download.php (r1.74 - r1.75) Index: cnt_download.php === RCS file: /projects/www/pgadmin3/cnt/cnt_download.php,v retrieving revision 1.74 retrieving revision 1.75 diff -Lpgadmin3/cnt/cnt_download.php -Lpgadmin3/cnt/cnt_download.php -u -w -r1.74 -r1.75 --- pgadmin3/cnt/cnt_download.php +++ pgadmin3/cnt/cnt_download.php @@ -309,7 +309,7 @@ dd ?php echo sprintf(_(pgAdmin III packages are available for %s.), MS Windows 2000/XP);? brbr - ?php echo echo _(Note that the a href=\http://www.postgresql.org/ftp/win32/\;pgInstaller distribution of PostgreSQL for Windows/a comes with pgAdmin.);? + ?php echo sprintf(_(Note that the a href='%s'pgInstaller distribution of PostgreSQL for Windows/a comes with pgAdmin.), http://www.postgresql.org/ftp/win32;);? /dd dd ?php echo sprintf(_(Download pgAdmin III package from our a href='%s'mirrors/a.), #mirrors);? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
