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

2012-02-02 Thread Tom Lane
eshkinkot writes: > Ah, sorry, looks like it already fixed in > REL9_1_STABLE 5d7d12de56be2c746bfc30214d3300644e8dc0f3 Oh, of course. I couldn't reproduce it because I was testing 9.1 branch tip. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgre

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

2012-02-02 Thread eshkinkot
Ah, sorry, looks like it already fixed in REL9_1_STABLE 5d7d12de56be2c746bfc30214d3300644e8dc0f3 Author: Tom Lane Date: Tue Dec 20 19:57:40 2011 -0500 Fix gincostestimate to handle ScalarArrayOpExpr reasonably. On Thu, Feb 2, 2012 at 4:35 AM, Sergey Burladyan wrote: > Sergey Burladyan

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, may be this

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

2012-02-01 Thread Sergey Burladyan
Tom Lane writes: > d...@rosfirm.ru writes: > > When making "in" query to fiels with gin index, server crashes. Below > > create table tmp(id serial not null primary key, f1 integer, f2 text); > > insert into tmp (f1,f2) values (1,'a'),(2,'b'),(3,'c'); > > create index tmp_f1_idx on tmp using gin

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

2012-01-22 Thread Tom Lane
d...@rosfirm.ru writes: > When making "in" query to fiels with gin index, server crashes. Below > create table tmp(id serial not null primary key, f1 integer, f2 text); > insert into tmp (f1,f2) values (1,'a'),(2,'b'),(3,'c'); > create index tmp_f1_idx on tmp using gin (f1); > create index tmp_f2_

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

2012-01-22 Thread don
The following bug has been logged on the website: Bug reference: 6407 Logged by: Yury Don Email address: d...@rosfirm.ru PostgreSQL version: 9.1.2 Operating system: Linux (Debian) Description: When making "in" query to fiels with gin index, server crashes. Below crea