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
i
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
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_i
"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
--- pe
CTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
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 is no
"Bob Pawley" <[EMAIL PROTECTED]> writes:
> Could somebody translate this error message for me??
> "cursor 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 to fi
Could somebody translate this error message for me??
Bob
"cursor 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
