Thread

bug in index ? (core dumped)

Max Vaschenko <max@nino.ru> — 2000-05-11T07:33:33Z

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