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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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