Re: Cursor

 -------------- Original message ----------------------
From: Tom Lane <tgl@sss.pgh.pa.us>
> "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;
                   ^^^^^^^^^^

Just to clarify is this supposed to be schema p_id,table p_id,column p_id_id?

>
> You probably ought to qualify the column reference in the cursor.
>
>             regards, tom lane
>


--
Adrian Klaver
aklaver@comcast.net