Re: Cursor

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cursor
Date: 2008-07-29 22:05:17
Message-ID: 00db01c8f1c7$2f9fb200$6401a8c0@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Tom

Qualifying the column was the solution.

Bob

----- Original Message -----
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>
Sent: Tuesday, July 29, 2008 2:51 PM
Subject: Re: [GENERAL] Cursor

> "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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2008-07-29 22:06:46 Re: Cursor
Previous Message Adrian Klaver 2008-07-29 22:03:18 Re: Cursor