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

From Fabio Pardi
Subject Re: Not able to update some rows in a table
Date
Msg-id f0baca8a-5532-bb95-b509-415656cd6725@portavita.eu
Whole thread Raw
In response to Not able to update some rows in a table  (Marco Fochesato <marcofoc@gmail.com>)
Responses Re: Not able to update some rows in a table
List pgsql-general

Hi Marco,

I think more information would give to us a better picture.

can you please post the following?

postgres version

your table structure

how you are updating the records

if the problem is reproducible directly from the postgres prompt

how you are fetching results after the update

anything else to make the situation more clear (like errors in the logfile, or anything else you think is relevant)


regards,

fabio pardi



On 02/07/18 16:51, Marco Fochesato wrote:
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

pgsql-general by date:

Previous
From: Marco Fochesato
Date:
Subject: Not able to update some rows in a table
Next
From: Robert Zenz
Date:
Subject: Re: Not able to update some rows in a table