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/