Re: Cursor Error - Mailing list pgsql-general

From Tom Lane
Subject Re: Cursor Error
Date
Msg-id 9948.1217521854@sss.pgh.pa.us
Whole thread Raw
In response to Cursor Error  ("Bob Pawley" <rjpawley@shaw.ca>)
List pgsql-general
"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 by date:

Previous
From: "Bob Pawley"
Date:
Subject: Cursor Error
Next
From: "Bob Pawley"
Date:
Subject: Re: Cursor Error