"Guillaume MARTIN" <guillaume@eurovox.fr> writes:
> i tried the truncate and delete ... I had the following :
> allopass_db=# DELETE FROM pg_statistic ;
> FATAL 2: open of /var/pgsql/data/pg_clog/0022 failed: No such file or
> directory
I was afraid that wouldn't work, but it was worth a try.
> allopass_db=# TRUNCATE pg_statistic ;
> ERROR: TRUNCATE cannot be used on system tables. 'pg_statistic' is a system
> table
You need to do the TRUNCATE in a standalone backend with -O -P switches.
This is basically the same procedure as for REINDEXing a system table;
see the REINDEX man page for details.
regards, tom lane