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