Is it allowed to declare a cursor in this manner??
procgraphic cursor for select p_id.p_id.process_id from p_id.p_id,
where p_id.p_id.p_id_id = processes_count.p_id_id;
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, July 31, 2008 9:50 AM
Subject: Re: [GENERAL] Cursor Error
> "Bob Pawley" <rjpawley(at)shaw(dot)ca> writes:
>> This is the cursor statement.
>> Open procgraphic for select p_id.p_id.process_id from p_id.p_id,
>> where p_id.p_id.p_id_id = processes_count.p_id_id;
> Sorry, we're not bright enough to handle WHERE CURRENT OF on a join
> --- per the fine manual,
> The cursor must be a simple (non-join, non-aggregate) query on
> the UPDATE's target table.
> I don't recall offhand whether there's some deep technical reason
> for the restriction against joins, or we just didn't get around to
> it. In any case, you'll need to change the cursor to return the
> table's primary key and use that to target the UPDATE.
> regards, tom lane
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-general by date
|Next:||From: Magnus Hagander||Date: 2008-07-31 18:17:52|
|Subject: Re: Doing an LDAP lookup from a SQL SELECT|
|Previous:||From: Richard Huxton||Date: 2008-07-31 18:12:32|
|Subject: Re: PL/pgSQL equivalent to PQtransactionStatus?|