After executing my update script successfully I could see that Dbeaver statistics tab showing updated row count as 0. But the changes are updated and script is executed without any error. Does anyone know the reason ?.
script:
do $$
-- start a transaction
declare
success integer := -1;
err_context text := 'Error during script execution';
begin
UPDATE table1 p SET name= pt.name
FROM table2 pt WHERE p.id = pt.tableid;
raise notice ' script executed Successfully';
exception
when others then
RAISE INFO 'Error Name:%',SQLERRM;
RAISE INFO 'Error State:%', SQLSTATE;
RAISE INFO 'Error Context:%', err_context;
end $$;