Re: [GENERAL] An example needed for Serializable conflict...

2009-07-07 Thread Albe Laurenz
Durumdara wrote: 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? You get a serialization conflict

Re: [GENERAL] An example needed for Serializable conflict...

2009-07-07 Thread durumdara
Hi! Thanks for your help! Another question if I use only SELECTS can I get some Serialization Error? For example: I need a report tool that can show the actual state of the business. Because of I use value-dependent logic, I MUST use consistent state to preserve the equality of many values

Re: [GENERAL] An example needed for Serializable conflict...

2009-07-07 Thread Andres Freund
Hi durumdara, On Tuesday 07 July 2009 12:10:52 durumdara wrote: Another question if I use only SELECTS can I get some Serialization Error? No. For example: I need a report tool that can show the actual state of the business. Because of I use value-dependent logic, I MUST use consistent

[GENERAL] An example needed for Serializable conflict...

2009-07-02 Thread Durumdara
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