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;
If process_total = 1 Then
Fetch first from procgraphic into process_id;
Update p_id.p_id
set proc_graphic_position = '1'
where current of procgraphic;
I get the same error message when I define the cursor with the same select.
I am not sure how to make the query simpler and still have it access the
right row on fetch.
Bob
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "PostgreSQL" <pgsql-general@postgresql.org>
Sent: Thursday, July 31, 2008 9:30 AM
Subject: Re: [GENERAL] Cursor Error
> "Bob Pawley" <rjpawley@shaw.ca> 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 to figure out which row to update. Without seeing the
> cursor definition it's hard to say more.
>
> regards, tom lane