Skip site navigation (1) Skip section navigation (2)

Re: Cursor

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 (view raw or flat)
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

In response to

  • Re: Cursor at 2008-07-29 21:42:45 from Bob Pawley

Responses

  • Re: Cursor at 2008-07-29 22:05:17 from Bob Pawley

pgsql-general by date

Next:From: David WilsonDate: 2008-07-29 21:55:36
Subject: Re: Cursor
Previous:From: John ChengDate: 2008-07-29 21:47:23
Subject: Re: How do I set up automatic backups?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group