=?UTF-8?B?R3nFkXrFkSBQYXBw?= writes:
> A periodic task moves rows form `available_jobs` to `assigned_jobs`
> the jobs that has been assigned:
> WITH jobs_to_assign AS (
> DELETE FROM available_jobs
> USING v_assignable_jobs
> WHERE available_jobs.id = v_assignable_jobs.id
> RETURNIN
Hi all,
First and foremost I admit what follows is quite awkward and a bit
long. Sorry for both.
However I still would really like to understand what I am missing in
regards of transaction isolation levels and MVCC if CTE involved.
Given a sort of scheduler application with two tables:
CREATE T
