Hi,
Another problem with PL (I got no replies to the bug report last Friday
about problems with PL when using FOR UPDATE OF ..).
I think the following may be impossible fomr PL, but I store information
in different tables depending on the type of job that is being handled.
On reset I want to clear these tables, so i store the names of the
tables in a separate table and have a loop in PL
FOR table IN
SELECT jb_name FROM jobparams p, jobs j
WHERE jb_type = type AND j.job = tsk.job
LOOP
DELETE FROM table.jb_name
WHERE job = tsk.job AND id = vid
AND date >= tsk.fromdate AND date <= tsk.uptodate;
END LOOP;
and PL does not like a variable in the table name.
ERROR: parser: parse error at or near "$1"
I guess this may have to do with the way the query plan is stored, so
that this may just be impossible to fix. Could somebody who knows how PL
works please confirm whether I'm asking something impossible here?
Adriaan