Re: Cursor - Mailing list pgsql-general

From Bob Pawley
Subject Re: Cursor
Date
Msg-id 00db01c8f1c7$2f9fb200$6401a8c0@owner
Whole thread Raw
In response to Cursor  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Cursor
List pgsql-general
Thanks Tom

Qualifying the column was the solution.

Bob


----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Richard Huxton" <dev@archonet.com>; "PostgreSQL"
<pgsql-general@postgresql.org>
Sent: Tuesday, July 29, 2008 2:51 PM
Subject: Re: [GENERAL] 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


pgsql-general by date:

Previous
From: aklaver@comcast.net (Adrian Klaver)
Date:
Subject: Re: Cursor
Next
From: "Bob Pawley"
Date:
Subject: Re: Cursor