[PATCHES] pt_BR FAQ update
Hi, This little patch change my e-mail address in the FAQ. If it's possible yet, please apply it to HEAD. = Euler Taveira de Oliveira euler[at]yahoo_com_br __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ faq.diff Description: faq.diff ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[PATCHES] Translation updates: pt_BR
Hi, This is a fully reviewed version of pt_BR message files. Please apply it to HEAD. http://br.geocities.com/eulerto/pg/nls_pt-br.tgz This another one, just resolved some fuzzy translations in 7.4. Please apply it to 7.4 branch. http://br.geocities.com/eulerto/pg/postgres.po.gz = Euler Taveira de Oliveira euler[at]yahoo_com_br ___ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ ---(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
[PATCHES] pg_get_viewdef returns one paren too much
[EMAIL PROTECTED] noticed a problem with pg_get_viewdef
in prettyprint mode.
create table gnrcitm (gnrcitmid int);
create table gnrcitmothrref (idntfyrefid int, gnrcitmid int);
create table other_ref(idntfyrefid int, catnmeclssid text, actvle text);
CREATE OR REPLACE VIEW test_view AS
SELECT or0.actvle AS treename
FROM gnrcitm g
LEFT JOIN (gnrcitmothrref g0
JOIN other_ref r0 ON g0.idntfyrefid = r0.idntfyrefid AND
r0.catnmeclssid::text = 'Tree Name'::text) or0
ON g.gnrcitmid = or0.gnrcitmid;
pg_get_viewdef(viewoid, true) will return
CREATE OR REPLACE VIEW test_view AS
SELECT or0.actvle AS treename
FROM gnrcitm g
LEFT JOIN
( --
(gnrcitmothrref g0
JOIN other_ref r0 ON g0.idntfyrefid = r0.idntfyrefid AND
r0.catnmeclssid = 'Tree Name'::text) or0
) --
ON g.gnrcitmid = or0.gnrcitmid;
The attached patch corrects this, without affecting the following:
CREATE OR REPLACE VIEW test_view2 AS
SELECT r0.actvle AS treename
FROM gnrcitm g
LEFT JOIN (gnrcitmothrref g0
JOIN other_ref r0 ON g0.idntfyrefid = r0.idntfyrefid AND
r0.catnmeclssid::text = 'Tree Name'::text)
ON g.gnrcitmid = g0.gnrcitmid
Regards,
Andreas
Index: ruleutils.c
===
RCS file: /projects/cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v
retrieving revision 1.185
diff -u -r1.185 ruleutils.c
--- ruleutils.c 5 Nov 2004 19:16:11 - 1.185
+++ ruleutils.c 10 Dec 2004 13:41:17 -
@@ -3876,7 +3876,8 @@
bool need_paren_on_right;
need_paren_on_right = PRETTY_PAREN(context)
- !IsA(j-rarg, RangeTblRef);
+ !IsA(j-rarg, RangeTblRef)
+ !(IsA(j-rarg, JoinExpr) ((JoinExpr*)j-rarg)-alias != NULL);
if (!PRETTY_PAREN(context) || j-alias != NULL)
appendStringInfoChar(buf, '(');
---(end of broadcast)---
TIP 8: explain analyze is your friend
[PATCHES] Translation updates: 8.0: pg_dump-ru, initdb-ru, psql-ru; 7.4/8.0: postgres-ru
Hello Peter, Attached please find newer Russian translation updates. For 8.0: pg_dump-ru.po.gz initdb-ru.po.gz psql-ru.po.gz For both, 7.4 and 8.0 branches: postgres-ru.po.gz Thanks, -s pg_dump-ru.po.gz Description: GNU Zip compressed data initdb-ru.po.gz Description: GNU Zip compressed data psql-ru.po.gz Description: GNU Zip compressed data postgres-ru.po.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
