bug in index ? (core dumped)

Started by Vashenko Maximalmost 26 years ago1 messagesbugs
Jump to latest
#1Vashenko Maxim
max@nino.ru

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