| 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: | Whole Thread | Raw Message | 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
| 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 |