Re: Not able to update some rows in a table

On 07/02/2018 07:51 AM, Marco Fochesato wrote:
> Dear all,
> I have a table with 21 columns.
> Primary key is done with 20 of these colums.

Do you mean the Primary Key is constructed from 20 columns?

> 
> I have 3.313 records.
> I don't know why, but I'm not able to update some of these records.

What is the SQL you are using?

Are there any error messages and if so what are they?

> 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


-- 
Adrian Klaver
adrian.klaver@aklaver.com