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