Hi! Please send me an example (pseudo-code) for Serializable conflict. And I wanna know, if possible, that if more transactions only read the tables in Serializable mode, and one or others write to it, can I got some conflicts in read operation?
c = client t = transaction c1t1 begin serial c1t1 select sum(netto) from order_items where order_code = 1 c2t2 begin c2t2 insert into order_items .... c3t3 begin serial c3t3 select sum(netto) from order_items where order_code = 2 c2t2 commit c4t4 begin serial c4t4 select sum(netto) from order_items where order_code = 1 c1t1 select count(order_items) c4t4 rollback c1t1 rollback c3t3 rollback I wanna understand, which limitations I need to see in my code to avoid conflicts on "important queries" where my calculated items must be equal (like count(*) = len(fetched(*)). Sorry for the rtfm like question, but is rather DSFE like (Do and See the F*ed Experience). So your experience needed. Thanks for your help: dd