| From: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Not able to update some rows in a table |
| Date: | 2018-07-02 15:07:10 |
| Message-ID: | ebbd616e-9be1-143c-5227-92c32783a6a7@evolu-s.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-07-02 15:13:28 | Re: Not able to update some rows in a table |
| Previous Message | Robert Zenz | 2018-07-02 15:03:00 | Re: Not able to update some rows in a table |