Re: Cursor

"Bob Pawley" <rjpawley@shaw.ca> writes:
> Following is more complete. The balance of the trigger that is not shown
> works when tested separately. I didn't include it because it is quite long.

Hmm, I still don't see anything that looks like a syntax error, but
I'll bet this is a name collision rather than the effect you want:

>  DECLARE
>  process_total integer ;
>  process_id integer ;
   ^^^^^^^^^^
>  procgraphic cursor for select process_id from p_id.p_id, processes_count
                                 ^^^^^^^^^^
>    where p_id.p_id.p_id_id = processes_count.p_id_id;

You probably ought to qualify the column reference in the cursor.

            regards, tom lane