<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br
/>>May be this is needed to support savepoints/subtransactions? Or is it <br />> something else that i am
missing?<br/><br />It's for two-phase commit. A prepared transaction can hold locks that need <br />to be recovered.<br
/><br/></blockquote><br />When a transaction enters (successfully) the prepared state it only retains its exclusive
locksand releases any shared locks (i.e. multixacts)... or, at least, that's how it should be in principle according to
serializiatontheory, i haven't yet checked out if this is what is done in postgresql .<br /><p> Chiacchiera con i tuoi
amiciin tempo reale! <br /> http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com