Re: updateable cursors & visibility - Mailing list pgsql-hackers

From Han
Subject Re: updateable cursors & visibility
Date
Msg-id 20030328042755.6F60647631A@postgresql.org
Whole thread Raw
In response to updateable cursors & visibility  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Hiroshi Inoue,
But still can't explain this:SENSITIVE => not READ_ONLYIt's in the ODBC Spec.
>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/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Regards!

        Han
        zhouhanok@vip.sina.com
          2003-03-28



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: updateable cursors & visibility
Next
From: Hiroshi Inoue
Date:
Subject: Re: updateable cursors & visibility