Re: AW: BLERe: AW: AW: [HACKERS] relation ### modified while in use

[Hiroshi Inoue]

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