[BUGS] BUG #4364: type of "new.id" does not match that when preparing the plan

2008-08-19 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 4364 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: FreeBSD 7.0 Description:type of "new.id" does not match that when preparing the plan Detail

[BUGS] BUG #3561: CHAR(x) blank stripped. Server or documentation bug?

2007-08-21 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 3561 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: FreeBSD 6.2 Description:CHAR(x) blank stripped. Server or documentation bug? Details: Regarding

Re: [BUGS] BUG #3085: Performance BUG

2007-03-18 Thread Alexander Kirpa
ual time=2.758..2.760 rows=1 loops=999) -> Seq Scan on t1 subselect (cost=0.00..17.49 rows=333 width=0) (actual time=0.055..1.736 rows=499 loops=999) Filter: (i4 < $0) Total runtime: 2821.200 ms Best regards, Alexander Kirpa --

[BUGS] BUG #2394: Multiple TRUNCATE within transaction

2006-04-15 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 2394 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: FreeBSD 6.0 Description:Multiple TRUNCATE within transaction Details: Within one transaction each

[BUGS] BUG #2353: Temporary tables created within trigger function still exist after abend

2006-03-22 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 2353 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: FreeBSD 6.0 Description:Temporary tables created within trigger function still exist after abend

Re: [BUGS] BUG #2315: Crash engine after modify "active" function

2006-03-16 Thread Alexander Kirpa
On 15 Mar 2006, at 19:54, Tom Lane wrote: > "Alexander Kirpa" <[EMAIL PROTECTED]> writes: > > Description:Crash engine after modify "active" function > > I can't reproduce this in HEAD. I think it's probably the same bug > already re

[BUGS] BUG #2315: Crash engine after modify "active" function

2006-03-15 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 2315 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: FreeBSD 6.0 Description:Crash engine after modify "active" function Details: FUNCTION f1(

[BUGS] BUG #1900: pgdumpall: false function description for type 'opaque'

2005-09-20 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 1900 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta2 Operating system: FreeBSD 5.2 Description:pgdumpall: false function description for type 'opaque' Details

Re: [BUGS] BUG #1500: child dead

2005-02-23 Thread Alexander Kirpa
SELECT to_char(NOW() - '2000-10-02'::date, 'MonDD'); Clear CRASH and autorestart. Need fix :-| pg 8.0.1 FreeBSD 5.2.1 Core size 3334144 Best regards, Alexander Kirpa ---(end of broadcast)--- TIP 7: don't forget to

[BUGS] BUG #1427: Seq scan for SELECT 1 FROM p WHERE aid=133 LIMIT 1

2005-01-20 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 1427 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: FreeBSD 5.2.1 Description:Seq scan for SELECT 1 FROM p WHERE aid=133 LIMIT 1 Details: CREATE TABLE

Re: [BUGS] BUG #1252: Optimization of SELECT for NOT NULL case

2004-09-15 Thread Alexander Kirpa
background disk writer and improving using of shared buffers. Good DB engine have more knowledge about information in shared buffers and using her, that any disk cache system of OS, plus avoiding or minimize using cache remove don't need "moving" between cache and buffers. Best reg