AW: BLERe: AW: AW: relation ### modified while in use - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: BLERe: AW: AW: relation ### modified while in use
Date
Msg-id 11C1E6749A55D411A9670001FA6879633680C8@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > > 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.

Andreas


pgsql-hackers by date:

Previous
From: Peter Mount
Date:
Subject: RE: JDBC now needs updates for large objects
Next
From: Hiroshi Inoue
Date:
Subject: Re: AW: BLERe: AW: AW: relation ### modified while in use