Re: pg_clog problem (maybe)...

andrea gelmini <andrea.gelmini@linux.it> 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