Bob Pawley wrote:
Is it allowed to declare a cursor in this manner??
Declare
procgraphic cursor for select p_id.p_id.process_id
from p_id.p_id, processes_count
where p_id.p_id.p_id_id = processes_count.p_id_id;
Using DECLARE instead of OPEN? Yes, but that won't somehow make a cursor
Could somebody translate this error message for me??
Bob
cursor unnamed portal 1 is not simply updateable scan of table p_id
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Bob Pawley [EMAIL PROTECTED] writes:
Could somebody translate this error message for me??
cursor unnamed portal 1 is not simply updateable scan of table p_id
You're trying to do an UPDATE WHERE CURRENT OF cursor, right?
What it means is that the cursor definition is too complicated for
Postgres
PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Thursday, July 31, 2008 9:30 AM
Subject: Re: [GENERAL] Cursor Error
Bob Pawley [EMAIL PROTECTED] writes:
Could somebody translate this error message for me??
cursor unnamed portal 1 is not simply updateable scan of table p_id
You're
Bob Pawley [EMAIL PROTECTED] writes:
Right.
This is the cursor statement.
Open procgraphic for select p_id.p_id.process_id from p_id.p_id,
processes_count
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
PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Thursday, July 31, 2008 9:50 AM
Subject: Re: [GENERAL] Cursor Error
Bob Pawley [EMAIL PROTECTED] writes:
Right.
This is the cursor statement.
Open procgraphic for select p_id.p_id.process_id from p_id.p_id,
processes_count
where