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: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

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.

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-2017 The PostgreSQL Global Development Group