Skip site navigation (1) Skip section navigation (2)

bug in index ? (core dumped)

From: Vashenko Maxim <max(at)nino(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug in index ? (core dumped)
Date: 2000-05-11 07:33:33
Message-ID: 391A624D.A3F7BCB7@nino.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi.

i have some table (in work ~ 5000 records)
{
  mo varchar(6)
  se varchar(128)
  lo varchar(128)
  su float8
  nd int4
  as float8
  sk float8
}

delete from it. -> 0 records.
vacuum it -> OK


then run a program (c,libpq):
{
  begin work
  delete from table where ...
  
  loop { insert ... } ... about 1000 loops.
  commit work
}

then look on table
select * from table - OK.

then
CREATE INDEX table_idx ON table (lo);

backend closed the channel ...
core dumped.

there is no NULL values in table.

without indexes (on this table) all works (still ;-).


-- 
Max Vashenko
Nizhny Novgorod, Russia
(8312) 30-19-05, 34-00-02

pgsql-bugs by date

Next:From: Vashenko MaximDate: 2000-05-11 07:54:34
Subject: index problem ? (core dumped)
Previous:From: Tom LaneDate: 2000-05-11 04:01:24
Subject: Re: CLUSTER bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group