Andrus Moor wrote:
The command
UPDATE dok SET krdokumnr=NULL WHERE krdokumnr NOT in (select dokumnr from
dok);
That's a rather dangerous query; I'm pretty sure it updates a lot more
than you think.
There is a long standing "bug" in the SQL standard where NOT IN (...,
..., NULL) always evaluates
The command
UPDATE dok SET krdokumnr=NULL WHERE krdokumnr NOT in (select dokumnr from
dok);
runs forever. Postgres.exe process takes 90% of CPU time, disk LED is
flashing.
Platform: Win XP Prof SP2, Postgres 8
dok table has only 7651 rows
Killing client application does not help. Only killing pos
