Re: [BUGS] BUG #7916: memory leak with array_agg

2013-03-05 Thread Sergey Burladyan
en a very optimistic calculation puts the space needed > for 70 10-element integer arrays at forty-some MB, and when I try > it I see more like 100MB consumed thanks to hashtable overhead. Yes you are right, Tom. My mistake. -- Sergey Burladyan -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #7710: Xid epoch is not updated properly during checkpoint

2012-11-30 Thread Sergey Burladyan
| txid_current | ?column? ---+--+- 2012-11-30 19:51:06.302396+04 | 439 | -4294966857 (1 row) Note this previous threads: Standbys, txid_current_snapshot, wraparound http://archives.postgresql.org/pgsql-hackers/2012-06/msg00888.php -- Sergey Burladyan -- Sent via

Re: [BUGS] BUG #6480: NLS text width problem

2012-03-12 Thread Sergey Burladyan
Tom Lane writes: > Ah, nevermind --- I re-read the patch and realized that it was already > doing exactly what I said. Committed, sorry for the noise. Great, thank you, Tom! -- Sergey Burladyan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes t

Re: [BUGS] BUG #6480: NLS text width problem

2012-03-07 Thread Sergey Burladyan
y possibility of libc doing something > other than what we intend. Sorry, I'm going on vacation for four days. Can't answer right now... -- Sergey Burladyan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6480: NLS text width problem

2012-03-06 Thread Sergey Burladyan
Peter Eisentraut writes: > On ons, 2012-02-22 at 22:37 +0400, Sergey Burladyan wrote: > > eshkin...@gmail.com writes: > > > > > The following bug has been logged on the website: > > > > > > Bug reference: 6480 > > > Logged by:

Re: [BUGS] BUG #6480: NLS text width problem

2012-02-22 Thread Sergey Burladyan
eshkin...@gmail.com writes: > The following bug has been logged on the website: > > Bug reference: 6480 > Logged by: Sergey Burladyan > Email address: eshkin...@gmail.com > PostgreSQL version: 9.1.2 > Operating system: Debian testing > Descriptio

Re: [BUGS] BUG #6407: Crash on queries to gin index with multiply values

2012-02-01 Thread Sergey Burladyan
Sergey Burladyan writes: > #1 0x7fe1efbbc2b2 in get_leftop (clause=0x7fe1f1d85230) at > /home/martin/debian/psql/9.1/build-area/postgresql-9.1-9.1.2/build/../src/backend/optimizer/util/clauses.c:189 I set breakpoint at src/backend/optimizer/util/clauses.c:188 and do some trace,

Re: [BUGS] BUG #6407: Crash on queries to gin index with multiply values

2012-02-01 Thread Sergey Burladyan
testyle = 'iso, dmy' lc_messages = 'ru_RU.UTF-8' # locale for system error message lc_monetary = 'ru_RU.UTF-8' # locale for monetary formatting lc_numeric = 'ru_RU.UTF-8' # locale for number formatting lc

Re: [BUGS] BUG #5950: backend terminating after altering table

2011-03-28 Thread Sergey Burladyan
n HEAD: Not fully. There are also two cases with Segmentation fault (from sql.ru forum): 1. create table t (); alter table t add childs t; create table selfchield_new (like t); 2. create table t (); alter table t add childs t; create table selfchield_new as select * from t; I have segmentation fault wi

Re: [BUGS] sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

2011-02-12 Thread Sergey Burladyan
[ OK ] Cancel│ └────────┘ -- Sergey Burladyan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

problem with glibc strerror messages translation (was: [BUGS] Could not open file pg_xlog/000000010....)

2010-10-12 Thread Sergey Burladyan
uot;)); /* postgres do this at starting */ printf("LC_CTYPE: %s\n", setlocale(LC_CTYPE, "")); /* can be fixed like this, but _libc_intl_domainname is private :( */ //printf("bind_textdomain_codeset: %s\n", bind_textdomain_codeset(/*_libc_intl_domainname*/"lib

[BUGS] psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'

2010-09-27 Thread Sergey Burladyan
on't know, may be this is expected behavior. -- Sergey Burladyan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly

2009-12-06 Thread Sergey Burladyan
The following bug has been logged online: Bug reference: 5234 Logged by: Sergey Burladyan Email address: eshkin...@gmail.com PostgreSQL version: 8.3.8 Operating system: Debian GNU/Linux 5.0.3 (lenny) + testing Description:ALTER TABLE ... RENAME COLUMN change view

Re: [BUGS] BUG #4907: stored procedures and changed tables

2009-07-09 Thread Sergey Burladyan
Sergey Burladyan writes: > Alvaro Herrera writes: > > > Michael Tenenbaum wrote: > > > > > If I have a stored procedure that returns a set of records of a table, I > > > get > > > an error message that the procedure's record is the wrong t

Re: [BUGS] BUG #4907: stored procedures and changed tables

2009-07-09 Thread Sergey Burladyan
ed column count (2). КОНТЕКСТ: PL/pgSQL function "foo" line 1 at RETURN QUERY РАСПОЛОЖЕНИЕ: validate_tupdesc_compat, pl_exec.c:5143 -- Sergey Burladyan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] pg 8.3.7 libxml trying to free NULL pointer

2009-06-09 Thread Sergey Burladyan
ing=0x88991bc "select xpath('count(//)', ''::xml);") at postgres.c:1004 #31 0x0823f7fc in PostgresMain (argc=4, argv=0x8810cf4, username=0x8810cc4 "seb") at postgres.c:3631 #32 0x0820973f in ServerLoop () at postmaster.c:3207 #33 0x0820a6c3 in PostmasterMain

[BUGS] pg 8.3.7 libxml trying to free NULL pointer

2009-06-09 Thread Sergey Burladyan
free (pointer=0x0) at mcxt.c:580 #5 0xb7e6e5d2 in ?? () from /usr/lib/libxml2.so.2 #6 0x in ?? () -- Sergey Burladyan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4705: Software developer

2009-03-14 Thread Sergey Burladyan
Dave Page writes: -- С уважением, Сергей Бурладян -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #4700: SIGSEGV with incorrect input to to_char function

2009-03-11 Thread Sergey Burladyan
The following bug has been logged online: Bug reference: 4700 Logged by: Sergey Burladyan Email address: eshkin...@gmail.com PostgreSQL version: 8.3.6 Operating system: Debian GNU/Linux 5.0 (lenny) Description:SIGSEGV with incorrect input to to_char function Details

[BUGS] BUG #4622: xpath only work in utf-8 server encoding

2009-01-22 Thread Sergey Burladyan
The following bug has been logged online: Bug reference: 4622 Logged by: Sergey Burladyan Email address: eshkin...@gmail.com PostgreSQL version: 8.3.5 Operating system: Debian testing Description:xpath only work in utf-8 server encoding Details: hello, all ! i am

Re: [BUGS] can't delete record from second table in rules of view with join select

2008-03-25 Thread Sergey Burladyan
Hello, all > not important, is it one rule like: > create rule v_del as on delete to v do instead ( >delete from o1 where id = old.o1_id; >delete from o2 where id = old.o2_id; > ); > > or split into two rule like: > create rule v_del1 as on delete to v do instead ( >delete

[BUGS] can't delete record from second table in rules of view with join select

2008-03-25 Thread Sergey Burladyan
Hello, all From sql.ru forum: not important, is it one rule like: create rule v_del as on delete to v do instead ( delete from o1 where id = old.o1_id; delete from o2 where id = old.o2_id; ); or split into two rule like: create rule v_del1 as on delete to v do instead ( dele

Re: [BUGS] 8.3 can't convert cyrillic text from 'iso-8859-5' to other cyrillic 8-bit encoding

2008-03-19 Thread Sergey Burladyan
Thursday 20 March 2008 01:16:34 Heikki Linnakangas: Thanks for answer, Heikki ! > You'd need to modify the mic->ISO-8859-5 translation table as well, for > converting in the other direction. oops, i have not thought about it %) > Here's a patch that does the conversion in the other direction as

Re: [BUGS] 8.3 can't convert cyrillic text from 'iso-8859-5' to other cyrillic 8-bit encoding

2008-03-17 Thread Sergey Burladyan
Hi, all ! i'm find the problem. src/backend/utils/mb/conversion_procs/cyrillic_and_mic/cyrillic_and_mic.c does not have cyrillic letter 'IO' in ISO-8859-5 to mule internal code translation table (function iso2mic(const unsigned char *l, unsigned char *p, int len)). this is bug, because it is wi

[BUGS] 8.3 can't convert cyrillic text from 'iso-8859-5' to other cyrillic 8-bit encoding

2008-03-17 Thread Sergey Burladyan
Hi, all ! I can't convert with convert(bytea, name, name)::bytea from 'iso-8859-5' to 'windows-1251' or any other cyrillic 8-bit encoding. seb=> show client_encoding ; client_encoding - UTF8 seb=> show server_encoding; server_encoding - UTF8 seb=> select ver

[BUGS] bug or not bug, xmlvalidate(xml, text) can read and show one line from file

2008-02-29 Thread Sergey Burladyan
Hi, all seb=> select version(); version PostgreSQL 8.3.0 on x86_64-pc-linux-gnu, compiled by GCC x86_64-pc-linux-gnu-gcc (GCC

[BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-27 Thread Sergey Burladyan
The following bug has been logged online: Bug reference: 3494 Logged by: Sergey Burladyan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: CentOS release 5 (Final) Description:may be Query Error: subplan does not executed Details: i have

[BUGS] BUG #3396: strange error report for 'create domain ... default null'

2007-06-20 Thread Sergey Burladyan
The following bug has been logged online: Bug reference: 3396 Logged by: Sergey Burladyan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: CentOS release 5 (Final) Description:strange error report for 'create domain ... default