Re: Cursor Error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cursor Error
Date: 2008-07-31 16:30:54
Message-ID: 9948.1217521854@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bob Pawley" <rjpawley(at)shaw(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2008-07-31 16:45:20 Re: Cursor Error
Previous Message Bob Pawley 2008-07-31 15:42:56 Cursor Error