Il 02/07/2018 16:51, Marco Fochesato ha scritto:
> Dear all,
> I have a table with 21 columns.
> Primary key is done with 20 of these colums.
>
> I have 3.313 records.
> I don't know why, but I'm not able to update some of these records.
> I don't understand, it seems that I'm not able to fetch.
Could you post some of the statement you execute? If you are unable to
SELECT some record, it's quite straightforward that you can't UPDATE them.
> It happens with Pgadmin, with Python Psycopg2 and also through
> Libreoffice Base.
OS? PG Version?
>
> Looking to the properties of the table in Pgadmin, I can see only the
> estimated number
> of rows. Counted rows are 'not counted'.
Seems that autovacuum is not active, or has never run (but i'm quite
sure it's not related to your problem, so it can be investigated later).
Cheers
Moreno.-