Re: updateable cursors & visibility

Bruce Momjian wrote:
>
> Sorry, no idea.  Peter's idea is that FOR UPDATE requires SENSITIVE, so
> INSENSITIVE has to be READONLY because the update has to see other
> changes to be accurate.
>
> I think clearly SENSITIVE/READONLY should be possible, so:
>
>         READONLY/SENSITIVE      possible
>         READONLY/INSENSITIVE    possible
>         FOR UPDATE/SENSITIVE    possible
>         FOR UPDATE/INSENSITIVE  not possible
>
> READONLY can be either way, while FOR UPDATE requires SENSITIVE.

SENSITIVE doesn't mean *not INSENESITIVE*.
INSENSITIVE doesn't mean *not SENSITIVE*.

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/