Re: [BUGS] BUG #5183: Wrong select results using multicolumn gin indexes

2009-11-13 Thread Teodor Sigaev
tisfy conditions. The same results with one column type int[] and other column type text or integer. -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] BUG #5183: Wrong select results using multicolumn gin indexes

2009-11-13 Thread Teodor Sigaev
e, you can probably work around it by disabling fastupdate on these indexes.) regards, tom lane -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@post

Re: [BUGS] BUG #4933: ts_rewrite() causes segfault when query with more than one node becomes empty

2009-07-28 Thread Teodor Sigaev
Description:ts_rewrite() causes segfault when query with more than one node becomes empty Fixed, thank you -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs

Re: [BUGS] BUG #4697: to_tsvector hangs on input

2009-03-10 Thread Teodor Sigaev
e attached patch does that. Committed to HEAD, 8.3 and 8.2, thank you. Previous releases are not affected. -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs mailing l

Re: [BUGS] server crash when tsearch2 function is called from update trigger

2009-01-28 Thread Teodor Sigaev
I found bug in tsearch2 module (8.3, 8.4). Thank you, fixed http://archives.postgresql.org/message-id/20090128183133.0d6f9755...@cvs.postgresql.org (for 8.3 too) -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW

Re: [BUGS] BUG #4491: regression in gist indexes

2008-10-27 Thread Teodor Sigaev
Looks like this is a dup of #4479: Yep, exactly http://archives.postgresql.org/pgsql-bugs/2008-10/msg00094.php -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs

Re: [BUGS] BUG #4479: Incorrect TSearch2 results when inserting after deleting

2008-10-22 Thread Teodor Sigaev
Fixed, the reason is the same as for http://archives.postgresql.org/pgsql-general/2008-10/msg00845.php Patch: http://archives.postgresql.org/pgsql-committers/2008-10/msg00187.php -- Teodor Sigaev E-mail: [EMAIL PROTECTED

Re: [BUGS] BUG #4479: Incorrect TSearch2 results when inserting after deleting

2008-10-22 Thread Teodor Sigaev
Teodor, will you look at this? Yes, Of course -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] Problem loading ispell affix file with apostrophes

2008-07-22 Thread Teodor Sigaev
ld allow apostrophe as word character in replace field, may be in find field too. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) T

Re: [BUGS] 'Too many LWLocks held' with GIN pg_trgm_ops index [RE-SENT]

2008-04-21 Thread Teodor Sigaev
Following my -general post about this issue I'm supplying a test case for a query that fails with a 'Too many LWLocks held' error. Thank you, I reproduced the bug and now I'm working on it. -- Teodor Sigaev E-ma

Re: [BUGS] Crash 8.2.5 backend using tsearch2

2007-09-26 Thread Teodor Sigaev
is some other bug involved too. But I would say that compareWORD is broken nonetheless. Fixed, you are right. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru

Re: [BUGS] BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page

2007-05-24 Thread Teodor Sigaev
I haven't been able to reproduce it. I think its a race condition between some of the other processes running at the time. I'm not sure what else was running on it, but the error suggests an insert to me and there may have been a vacuum running (plus there are always plenty of selects running

Re: [BUGS] BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page

2007-05-24 Thread Teodor Sigaev
CREATE INDEX idx_picture_comments_id_tree_gist ON picture_comments USING gist (id_tree); and the server exited on signal 6 (core dumped) Is it reproducible? Pls, send to me dump of ltree column. ---(end of broadcast)

Re: [BUGS] BUG #3048: pg_dump dumps intarray metadata incorrectly

2007-04-10 Thread Teodor Sigaev
But it should dump them as "ALTER whatever" commands, right? No :(, see http://archives.postgresql.org/pgsql-hackers/2007-03/msg01112.php about ALTER OPERATOR CLASS -- Teodor Sigaev E-mail: [EMAIL

Re: [BUGS] ERROR: failed to build any 4-way joins

2006-12-13 Thread Teodor Sigaev
went up in smoke, and I ended up just having have_relevant_joinclause() Thank you a lot, I was near around it :) -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru

Re: [BUGS] ERROR: failed to build any 4-way joins

2006-12-12 Thread Teodor Sigaev
Sorry, versions are 8.2 & 8.3. 8.1 works well -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 9: In vers

[BUGS] ERROR: failed to build any 4-way joins

2006-12-12 Thread Teodor Sigaev
VIEW fooview AS SELECT f1.a AS a_for_max_b FROM foo f1 WHERE f1.b = (SELECT MAX(f2.b) FROM foo f2); then all is ok. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.siga

Re: [BUGS] BUG #2594: Gin Indexes cause server to crash on Windows

2006-08-30 Thread Teodor Sigaev
es forward: there is a corner case when documents has a lot of unique words (millions) and index creation time becomes very long. 8.2 will create index much faster in this case. And the performance is swt! Thanks Oleg & Teodor! :) -- Teodor Sigaev

Re: [BUGS] BUG #2594: Gin Indexes cause server to crash on Windows

2006-08-30 Thread Teodor Sigaev
that building a gin index on an empty table fails on any platform. I get a null pointer dereference with the following stack trace -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http