From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
Cc: | "Richard Huxton" <dev(at)archonet(dot)com>, "PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Cursor |
Date: | 2008-07-29 21:51:24 |
Message-ID: | 22297.1217368284@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Bob Pawley" <rjpawley(at)shaw(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David Wilson | 2008-07-29 21:55:36 | Re: Cursor |
Previous Message | John Cheng | 2008-07-29 21:47:23 | Re: How do I set up automatic backups? |