Re: Cursor Error

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Bob Pawley" <rjpawley(at)shaw(dot)ca> writes:
> Right.
> This is the cursor statement.

>  Open procgraphic for select p_id.p_id.process_id from p_id.p_id, 
> processes_count
>  where p_id.p_id.p_id_id = processes_count.p_id_id;

Sorry, we're not bright enough to handle WHERE CURRENT OF on a join
--- per the fine manual,

	The cursor must be a simple (non-join, non-aggregate) query on
	the UPDATE's target table.

I don't recall offhand whether there's some deep technical reason
for the restriction against joins, or we just didn't get around to
it.  In any case, you'll need to change the cursor to return the
table's primary key and use that to target the UPDATE.

			regards, tom lane