--- Helen Borrie <helebor@...> wrote:

> At 03:02 PM 30/12/2007, you wrote:
>
> >--- Helen Borrie <helebor@...> wrote:
> >
> >>
> >> At this point, transaction #2 is active and is interested in the completed
> >> (committed or rolled-back) transaction #1.
> >
> >why is it still active while it has been (hard-)committed?
>
> Silly question, I hope - but are you watching the database from another
> application (such as isql or some other tool)?

No.
Sorry I've just found that this mailing list doesn't allow attachment.

so here is a link to my demo program + script:
http://rt.cpan.org/Ticket/Attachment/404017/196797/stuck-oit-compared.tar.gz

i believe this stuck OIT behaviour for single select also occurs on other
language bindings, as long as they don't do the idle transaction trick or
create a dedicated transaction for DDL (such as in isql).

rgds,
Edwin.




________________________________________________________
Bergabunglah dengan orang-orang yang berwawasan, di di bidang Anda! Kunjungi Yahoo! Answers saat ini juga di http://id.answers.yahoo.com/