Re: [BUGS] Out of memory error during large hashagg

2006-09-19 Thread Casey Duncan
On Sep 19, 2006, at 1:51 AM, Simon Riggs wrote: On Mon, 2006-09-18 at 14:08 -0700, Casey Duncan wrote: I've reported variants of this in the past, but this case is entirely repeatable. Executing this query: select st_id, min(seed_id) as "initial_seed_id", count(*) as "seed_count" from seed g

Re: [BUGS] Optimizer Bug of Debug Version

2006-09-19 Thread Tom Lane
"Jackie Leng" <[EMAIL PROTECTED]> writes: > In 8.1, if we execute the following queries on an debug version: > create table t(a int,b int); > create index ttt on t(a,b); > explain select * from t t1,t t2 where (t1.a=1 and t2.b in (1,2)) or (t1.a=2 > and t2.b in (3,4)); > The server will halt in f

[BUGS] Optimizer Bug of Debug Version

2006-09-19 Thread Jackie Leng
In 8.1, if we execute the following queries on an debug version: create table t(a int,b int); create index ttt on t(a,b); explain select * from t t1,t t2 where (t1.a=1 and t2.b in (1,2)) or (t1.a=2 and t2.b in (3,4)); The server will halt in function "generate_bitmap_or_paths".Seems that "create

[BUGS] Startup Error

2006-09-19 Thread Bharat Manmode
Hello,   I installed PostGreSQL on LINUX Enterprise Edation 4.   when i start PGSQL i get error "nohup.out"   Plz. Give me solution.   Regards Bharat

[BUGS] BUG #2636: JDBC error behaviour incorrect

2006-09-19 Thread Kiren Pillay
The following bug has been logged online: Bug reference: 2636 Logged by: Kiren Pillay Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows Description:JDBC error behaviour incorrect Details: Hi Here is my code snippet: <--

Re: [BUGS] Out of memory error during large hashagg

2006-09-19 Thread Simon Riggs
On Mon, 2006-09-18 at 14:08 -0700, Casey Duncan wrote: > I've reported variants of this in the past, but this case is entirely > repeatable. > > Executing this query: > > select st_id, min(seed_id) as "initial_seed_id", count(*) as > "seed_count" > from seed group by st_id; > > The query pla