Re: [HACKERS] git.postgresql.org vs. REL8_1_STABLE

'TIDBitmap' ../../../../src/include/nodes/execnodes.h:959: error: expected specifier-qualifier-list before 'TIDBitmap' make[4]: *** [indexvalid.o] Error 1 postgresql-8.1.18.tar.bz2 from www.postgresql.org/ compiled successful. -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] gettext, plural form and translation

this ? ps: i try to translate psql message (1 row)/(3 rows) but can't do this correctly without plural form support. need some work with source for implement it and xgettext params used for extract messages for http://babel.postgresql.org/ Thanks for comments ! -- Sergey Burladyan - -- Sent via

Re: [HACKERS] gettext, plural form and translation

Alvaro Herrera alvhe...@commandprompt.com writes: Sergey Burladyan escribió: gnu gettext have support for correct plural form translation (http://www.gnu.org/software/gettext/manual/html_node/Plural-forms.html), but postgresql does not use it. why not ? maybe it have some problem in some

Re: [HACKERS] gettext, plural form and translation

Alvaro Herrera alvhe...@commandprompt.com writes: Sergey Burladyan escribió: Alvaro Herrera alvhe...@commandprompt.com writes: Yes, the main reason is that it is not clear whether this is supported on all OS, or moreover that I believe it is not. So some allowances

Re: [HACKERS] gettext, plural form and translation

row) ! msgid_plural (%lu rows) ! msgstr[0] (%lu строка) ! msgstr[1] (%lu строки) ! msgstr[2] (%lu строк) #: startup.c:138 #, c-format -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] gettext, plural form and translation

Sergey Burladyan eshkin...@gmail.com writes: gettext-plural-ru-test.patch: - correct translation for 1 rows message hmmm... encoding is broken... i post it again in gzip gettext-plural-ru-test.patch.gz Description: gettext-plural-ru-test.patch -- Sergey Burladyan -- Sent via pgsql

Re: [HACKERS] gettext, plural form and translation

8.4 will be released ? Have i time for translate HEAD before release will be ? I try to find 8.4 release date but it is 1st March 2009 %) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: XML only working in UTF-8 - Re: [HACKERS] 8.4 open items list

nodes and it values written correctly (it is UTF-8), except attribute value, this is strange, imho. xmltype * xmlelement(XmlExprState *xmlExpr, ExprContext *econtext) from xml.c not use xmlTextWriterStartDocument and return html entities in attribute values. -- Sergey Burladyan -- Sent via pgsql

Re: [HACKERS] Solution of the file name problem of copy on windows.

Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp writes: There are some issues: * Is it possible to determine the platform encoding? There is no platform encoding in linux. File name encoding depend on user locale, so different users can have different encoding of file name. -- Sergey

Re: [HACKERS] Improving the ngettext() patch

, FUNC_MAX_ARGS), FUNC_MAX_ARGS))); It seems extremely far-fetched that FUNC_MAX_ARGS would ever be small enough that it would make any language's special cases kick in. Russian plural forms for 100, 101, 102 etc. is different, as for 0, 1, 2. -- Sergey

Re: [HACKERS] Not quite a security hole in internal_in

,integer) utils_pg.gtrgm_compress(internal) utils_pg.gtrgm_decompress(internal) utils_pg.gtrgm_picksplit(internal,internal) utils_pg.gtrgm_union(bytea,internal) (19 rows) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

[HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

=0 loops=1) One-Time Filter: false Total runtime: 0.048 ms Is this expected behavior ? Can 8.4 optimize first query like 8.3 ? Thinks ! ps: no response in pgsql-performance so i try ask in pgsql-hackers -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

Sergey Burladyan eshkin...@gmail.com writes: Thinks ! Th_a_nks ! :) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

..0.011 rows=0 loops=1) One-Time Filter: false Total runtime: 0.179 ms (3 rows) Thank you, Tom ! -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

--- Seq Scan on t (cost=0.00..17030.00 rows=1 width=4) (actual time=449.651..449.651 rows=0 loops=1) Filter: ((i = 10) AND (i = 1)) Total runtime: 449.726 ms -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

Tom Lane t...@sss.pgh.pa.us writes: Sergey Burladyan eshkin...@gmail.com writes: Oh, now problem with simple query: 8.4.0 from Debian explain analyze select i from t where i = 10 and i = 1; QUERY PLAN

[HACKERS] Patch for BUG #6480, psql incorrect indent for inherited tables names with UTF-8 NLS

will be with Russian translation again (thank you, Alexander!) and this tiny bug is slightly annoying. From aaa828e05691ca58067d74cea43dabe8863ccdf7 Mon Sep 17 00:00:00 2001 From: Sergey Burladyan eshkin...@gmail.com Date: Thu, 23 Feb 2012 04:09:10 +0400 Subject: [PATCH] Fix NLS text width and pg_wcswidth

Re: [HACKERS] Patch for BUG #6480, psql incorrect indent for inherited tables names with UTF-8 NLS

Alvaro Herrera alvhe...@commandprompt.com writes: I'm sorry, but the releases are already tagged :-( So they will contain the buggy output for a while yet. Ah, I see, ok, wait next! :) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Recovery target 'immediate'

into pg_xlog and remove recovery.conf. It seems that we're missing a setting, something like recovery_target = 'immediate', which would mean stop as soon as consistency is reached. Or am I missing some trick? This will be helpful :) -- Sergey Burladyan

[HACKERS] UTF8 regexp and char classes still does not work

and it call pg_wc_isalpha like this: for (i = 0; i = UCHAR_MAX; i++) { if (pg_wc_isalpha((chr) i)) addchr(cv, (chr) i); } UCHAR_MAX is 255 I do not understand fully this algorithm of regular expressions, but i think cclass function also need fix. -- Sergey Burladyan -- Sent via pgsql

Re: [HACKERS] UTF8 regexp and char classes still does not work

| f| t -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] FreeBSD 8.0 i386, plpythonu, threaded Python not supported on this platform

whether Python is compiled with thread support... yes configure: error: threaded Python not supported on this platform --8---cut here---end---8--- Where can I find a description of this problem? Is any chance to fix it? -- Sergey Burladyan -- Sent via pgsql

Re: [HACKERS] Draft release notes for 9.3.2

! Is it possible to fix my surname in changelog? -Sergey Burladyn +Sergey Burladyan it is not a problem if it is impossible :-) Thanks! -- Sergey Burladyan

Re: [HACKERS] [BUGS] BUG #9223: plperlu result memory leak

Hello, All! eshkin...@gmail.com writes: create function perl_test(IN data text, OUT v1 text, OUT v2 integer, OUT v3 integer, OUT v4 json, OUT v5 json) returns record as $BODY$ use strict; use warnings; my $res-{'v1'} = 'content'; return $res; $BODY$ language plperlu volatile

Re: [HACKERS] [BUGS] BUG #9223: plperlu result memory leak

Alex Hunsaker bada...@gmail.com writes: On Tue, Feb 25, 2014 at 6:56 AM, Sergey Burladyan eshkin...@gmail.com wrote: It looks like I found the problem, Perl use reference count and something that is called Mortal for memory management. As I understand it, mortal is free after

Re: [HACKERS] [BUGS] BUG #9223: plperlu result memory leak

to repo. -- Sergey Burladyan

[HACKERS] pg_upgrade and epoch

://lists.pgfoundry.org/pipermail/skytools-users/2014-April/001812.html -- Sergey Burladyan

Re: [HACKERS] pg_upgrade and epoch

/postgresql/9.3/bin -k /usr/lib/postgresql/9.3/bin/postgres -D d9.3 -p 5433 -k`pwd`/s psql -At -h localhost -p 5433 -c 'select txid_current()' postgres 756 34359739064 switched to 756 after upgrade -- Sergey Burladyan

Re: [HACKERS] Broken hint bits (freeze)

20 июн. 2017 г. 1:21 пользователь "Bruce Momjian" написал: We are saying that Log-Shipping should match "Latest checkpoint location", but the WAL for that will not be sent to the standby, so it will not match, but that is OK since the only thing in the non-shipped WAL file is

Re: [HACKERS] Broken hint bits (freeze)

Bruce Momjian <br...@momjian.us> writes: > On Mon, Jun 19, 2017 at 10:59:19PM -0400, Bruce Momjian wrote: > > On Tue, Jun 20, 2017 at 03:50:29AM +0300, Sergey Burladyan wrote: > > > 20 июн. 2017 г. 1:21 пользователь "Bruce Momjian" <br...@momjian.us> &g

Re: [HACKERS] Broken hint bits (freeze)

Amit Kapila <amit.kapil...@gmail.com> writes: > On Tue, Jun 20, 2017 at 3:40 PM, Sergey Burladyan <eshkin...@gmail.com> wrote: > > Bruce Momjian <br...@momjian.us> writes: > > > >> On Mon, Jun 19, 2017 at 10:59:19PM -0400, Bruce Momjian wrote: >

Re: [HACKERS] Broken hint bits (freeze)

for relation "public.test_id_idx" ("s/9.2/base/16384/16393" to "m/9.4/base/16422/16393"): No such file or directory Failure, exiting I touch this file (s/9.2/base/16384/16393) and rerun pg_upgrade from scratch and it complete successfully. -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Broken hint bits (freeze)

Sergey Burladyan <eshkin...@gmail.com> writes: > 1. create master > 2. create standby from it > 3. create unlogged table and hash index like: > create unlogged table test (id int primary key, v text); > create index on test using hash (id); > 3. stop master > 4. prom

Re: [HACKERS] Broken hint bits (freeze)

Bruce Momjian <br...@momjian.us> writes: > On Tue, Jun 20, 2017 at 01:10:26PM +0300, Sergey Burladyan wrote: > > Bruce Momjian <br...@momjian.us> writes: > > > > Uh, as I understand it the rsync is going to copy the missing WAL file > > > > from the

Re: [HACKERS] Broken hint bits (freeze)

in/pg_xlog/ | awk '/4ED0A00AE/,/xxx/ { print }' | wc -l 2456 === See https://www.postgresql.org/docs/9.2/static/wal-configuration.html > they are recycled (renamed to become the next segments in the numbered > sequence) -- Sergey Burladyan -- Sent via pgsql-hackers mailin

Re: [HACKERS] Broken hint bits (freeze)

Bruce Momjian <br...@momjian.us> writes: > On Tue, Jun 20, 2017 at 06:42:58PM +0300, Sergey Burladyan wrote: > > If file at standby in old data directory is different from same file at > > master, but it have same size, it will be hardlinked into new data > > di

[HACKERS] Questions about upgrade standby with rsync

017-06-01 16:09:32 MSK ReadRecord: record with zero len at 0/1280 This WAL file is only at master pg_xlog, and not in WAL archive. And my second question, this algorithm with rsync described only starting from pg 9.5, is it possible to use it for upgrade from pg 9.2 to pg 9.4? Thanks! --

Re: [HACKERS] Broken hint bits (freeze)

Vladimir Borodin <r...@simply.name> writes: > > 6 июня 2017 г., в 23:30, Sergey Burladyan <eshkin...@gmail.com> написал(а): > > > > Dmitriy Sarafannikov <dsarafanni...@yandex.ru> writes: > > > >> Starting and stopping master after running pg_u

Re: [HACKERS] Broken hint bits (freeze)

Bruce Momjian <br...@momjian.us> writes: > On Fri, Jun 16, 2017 at 04:33:16AM +0300, Sergey Burladyan wrote: > > Bruce Momjian <br...@momjian.us> writes: > > > ! > > > ! Also, if upgrading standby servers, change wal_level > > &g

Re: [HACKERS] Broken hint bits (freeze)

Bruce Momjian <br...@momjian.us> writes: > On Fri, Jun 16, 2017 at 08:10:13PM +0530, Amit Kapila wrote: > > On Fri, Jun 16, 2017 at 7:03 AM, Sergey Burladyan <eshkin...@gmail.com> > > wrote: > > > Bruce Momjian <br...@momjian.us> writes: > > >

Re: [HACKERS] Broken hint bits (freeze)

he master server 2017-06-16 01:22:14 GMT HINT: Either set wal_level to "replica" on the master, or turn off hot_standby here. 2017-06-16 01:22:14 GMT LOG: startup process (PID 27916) exited with exit code 1 = PS: Thank you for answer, Bruce! -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Broken hint bits (freeze)

gresql.org/docs/9.6/static/pgupgrade.html > f. Start and stop the new master cluster > In the new master cluster, change wal_level to replica in the postgresql.conf > file and then start and stop the cluster. and there is no any suggestion to disable autovacuum for it. -- Sergey Burlad