Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Thu, 31 Jul 2008 12:30:54 -0400
  • Message-id: <9948.1217521854@sss.pgh.pa.us> <text/plain>

"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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group