Home > mailing lists

Not able to update some rows in a table - Mailing list pgsql-general

From	Marco Fochesato
Subject	Not able to update some rows in a table
Date	July 2, 2018 20:51:42
Msg-id	CAECC44feKzvSFx-EVB3zEFejwDJQPepvwjw1NXAL9X+qZp4HBg@mail.gmail.com Whole thread Raw
Responses	Re: Not able to update some rows in a table (Robert Zenz <robert.zenz@sibvisions.com>) Re: Not able to update some rows in a table (Fabio Pardi <f.pardi@portavita.eu>) Re: Not able to update some rows in a table (Moreno Andreo <moreno.andreo@evolu-s.it>) Re: Not able to update some rows in a table (Adrian Klaver <adrian.klaver@aklaver.com>)
List	pgsql-general

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.

It happens with Pgadmin, with Python Psycopg2 and also through Libreoffice Base.

Looking to the properties of the table in Pgadmin, I can see only the estimated number

of rows. Counted rows are 'not counted'.

Marco Fochesato

From: pinker
Date: 02 July 2018, 20:25:01
Subject: except all & WITH - syntax error?

From: Fabio Pardi
Date: 02 July 2018, 21:02:18
Subject: Re: Not able to update some rows in a table