Re: Not able to update some rows in a table

2018-07-02 Thread Marco Fochesato
gt; regards, tom lane > Dear Tom, you can bet all your money because you are right. I drop the table and re-created using numeric instead double precision. Now everything is ok, I can update every row of the table. Thank you. -- Marco Fochesato

Re: Not able to update some rows in a table

2018-07-02 Thread Marco Fochesato
> > I would suggest writing a self-contained script that creates the table, > inserts a single record, and updates that record. Present that for > consideration along with a description or capture of the results of running > the script on your machine. > > But not all the records fail the update..

Re: Not able to update some rows in a table

2018-07-02 Thread Marco Fochesato
date > By refreshing the table, in PgAdmin. > anything else to make the situation more clear (like errors in the > logfile, or anything else you think is relevant) > No errors in the GUI, no errors in PgAdmin.log -- Marco Fochesato

Not able to update some rows in a table

2018-07-02 Thread Marco Fochesato
pg2 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