Re: [HACKERS] updateable cursors & visibility

[Hiroshi Inoue]

Bruce Momjian wrote:
> 
> Hiroshi Inoue wrote:
> > Bruce Momjian wrote:
> > >
> > > Peter Eisentraut wrote:
> > > > Bruce Momjian writes:
> > > >
> >
> > I don't understand what you two are discussing.
> > What's is SENSITIVE, INSENSITIVE or ASESNSITIVE ?
> 
> In SQL99 standard, I see:
> 
>          -  If the cursor is insensitive, then significant changes are not
>             visible.
> 
>          -  If the cursor is sensitive, then significant changes are
>             visible.
> 
>          -  If the cursor is asensitive, then the visibility of significant
>             changes is implementation-dependent.

While a cursor is open, another application inserted a
row which satisfies the condition to be contained in
the cursor and committed. Then
If the cursor is SENSITIVE, must it see the row ?
If the cursor is INSENSITIVE, it mustn't see the row ?
  
regards,
Hiroshi Inoue
        http://www.geocities.jp/inocchichichi/psqlodbc/


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly