Re: Cursor Error
От | Bob Pawley |
---|---|
Тема | Re: Cursor Error |
Дата | |
Msg-id | 006101c8f32c$d2505610$6401a8c0@owner обсуждение исходный текст |
Ответ на | Cursor Error ("Bob Pawley" <rjpawley@shaw.ca>) |
Ответы |
Re: Cursor Error
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: