The problem is not stop there, I had a table that can't be updated since then with this simply command: update prdttable set webinclude = '0' where prdtnumber = '6002'
Again, the errors (invalid input syntax for integer: "") apears. Then I found this temporary solution to make replica to this record to another table in sense of update the value in the new table. 1. Create table prdt_problem as select * form prdttable where prdtnumber = '6002'; 2. Update prdt_problem set webinclude = '0' where prdtnumber = '6002'; 3. Delete from prdttable where prdtnumber = '6002'; 4. Insert into prdttable select * from prdt_problem How to fix this bug? > None. That's an intentional change. The fact that it ever accepted > '' as meaning 0 was a bug. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings