[BUGS] BUG #4216: Index scan goes wrong with crosstype comparison and between in one statement

2008-05-31 Thread Sokolov Yura aka
The following bug has been logged online: Bug reference: 4216 Logged by: Sokolov Yura aka "funny_falcon" Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: debian etch 4r3 Description:Index scan goes wrong with crosstype comp

[BUGS] BUG #3875: Building GIN index on full table could be slower than filling table with existing index.

2008-01-15 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 3875 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC1 8.2.x Operating system: Debian 4.0 Description:Building GIN index on full table could be slower than filling table with

Re: [BUGS] BUG #3860: xpath crashes backend when is querying xmlagg result

2008-01-15 Thread Sokolov Yura
Tom Lane wrote: "Sokolov Yura" <[EMAIL PROTECTED]> writes: xpath() crashes backend when is querying particular xmlagg results. Please see whether this patch fixes it: http://archives.postgresql.org/pgsql-committers/2008-01/msg00190.php The specific examples you give

Re: [BUGS] BUG #3852: Could not create complex aggregate

2008-01-09 Thread Sokolov Yura
Sorry for previous message having no comments. Just remark: These aggregates created successfuly both in 8.2 and 8.3beta4: CREATE AGGREGATE array_concat(anyarray) ( SFUNC=array_cat, STYPE=anyarray ); CREATE AGGREGATE array_build(anyelement) ( SFUNC=array_append, STYPE=anyarray ); But aggregate

[BUGS] BUG #3860: xpath crashes backend when is querying xmlagg result

2008-01-09 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 3860 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta4 Operating system: Debian Linux 4.0r2 both 32bit and amd64 Description:xpath crashes backend when is querying xmlagg

Re: [BUGS] BUG #3852: Could not create complex aggregate

2008-01-09 Thread Sokolov Yura
Tom Lane wrote: Joe Conway <[EMAIL PROTECTED]> writes: Did you want me to work on this? I could probably put some time into it this coming weekend. I'll try to get to it before that --- if no serious bugs come up this week, core is thinking of wrapping 8.3.0 at the end of the week, so

[BUGS] BUG #3852: Could not create complex aggregate

2008-01-06 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 3852 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta4 Operating system: Linux Debian 4.0rel2 Description:Could not create complex aggregate Details: Possibly it's n

[BUGS] BUG #2720: plpythonu with Python 2.5 crashes

2006-10-26 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 2720 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2beta1 Operating system: Slackware linux 10.2 Description:plpythonu with Python 2.5 crashes Details: I don't know is

[BUGS] BUG #2215: Cannot restore backup cause of view's representaion

2006-01-26 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 2215 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Windows XP SP2, Slackware 10.2 Description:Cannot restore backup cause of view's representaion De

[BUGS] BUG #2148: Crashes on simple statement

2006-01-06 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 2148 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Slackware Linux 2.6.14.1 Description:Crashes on simple statement Details: select ms from (select 1) ms

[BUGS] BUG 1614 and BUG 1616 : Inadequate GIST Behaviour

2005-05-04 Thread Sokolov Yura
People!!! Please !!! Just answer me: Someone working on it or not?!!! Or it isn't a bug? I'm going to put this bug report to PostgreSQL related forums in 10 days (if no one will answer me) Sokolov Yura [EMAIL PROTECTED] ---(end of

[BUGS] BUG 1614 and BUG 1616 : Inadequate GIST Behaviour

2005-04-27 Thread Sokolov Yura
index) 6 seconds in 8.0.2/Windows and >18 seconds on 8.0.1/Slackware*/ vacuum full verbose try_gist; /* Postgres 8.0.2 Windows INFO: vacuuming "public.try_gist" INFO: "try_gist": found 0 removable, 2246 nonremovable row versions in 15 pages DETAIL: 0 dead row versions ca

[BUGS] BUG #1616: Inadequate behavior GIST (btree_gist) multicolumn: first not unique

2005-04-22 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 1616 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows2003, (and not tested, but sure Slackware10.0) Description:Inadequate behavior GIST (btree_gist

[BUGS] BUG #1614: Bug in contrib/btree_gist for text

2005-04-22 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 1614 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows2003, Slackware 10.0 Description:Bug in contrib/btree_gist for text Details: /* contrib

[BUGS] BUG #1391: Perl trusted language triggers can't properly access $_SHARED

2005-01-13 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 1391 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 rc2 Operating system: Windows2003 Description:Perl trusted language triggers can't properly access $_SHARED Details