andrea gelmini <[EMAIL PROTECTED]> writes: > 3) I open three connection to the same db and start operation as > "begin work; select p4(); update info set data=RANDOM();commit;" > "create index gino on info(x);" > "begin work; update info set data=RANDOM();"
> Well, db schema is nothink more than this: > create table info(meta text, data text, id serial primary key); Uh, there's no "x" column in "info". > 4) after a lot of work/insert I've got this: > ERROR: could not access status of transaction 859388209 > DETAIL: open of file "/home/gelma/pg4/bin/../db/pg_clog/0333" failed: > No such file or directory I spent some time trying to reproduce this, with no success. Could you give a clearer recipe? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly