Re: AW: BLERe: AW: AW: relation ### modified while in use

Zeugswetter Andreas SB wrote:

> > > > Are there many applications which have many SELECT statements(without
> > > > FOR UPDATE) in one tx ?
> > >
> > > Why not ?
> > >
> > It seems to me that multiple SELECT statements in a tx has little
> > meaning unless the tx is executed in SERIALIZABLE isolation level.
>
> E.g. a table is accessed multiple times to select different data
> in an inner application loop. No need for serializable here.
>

And seems no need to execute in one tx.
Hmm,we seems to be able to call a cleanup procedure
internally which is equivalent to 'commit' after each
consecutive read-only statement.  Is it a problem ?

Regards.
Hiroshi Inoue