regarding isolation between threads

From: "Surabhi Ahuja " <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: regarding isolation between threads
Date: 2005-08-11 09:47:53
Message-ID: CE5C48E227F8ED4990FAC4332100ADC621B55C@EVS.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is in continuation of my previous mail:
each thread is using a different pgconn.

thanks again
Surabhi Ahuja

Dear All,

I am stuck in the following scenario:
In a dual processor machine, I am running 5 threads.
each of the threads is calling a particular stored procedure to insert a row in the table.

the insertion takes place in a transaction and i have set the transaction level to serializable.

However it seems that the insertion is not taking place properly because of the threads.

isnt the isolation mainiatined in case of threads?
what is it that I can possibly do to provide isolation amongst threads

Please tell, in case I should provide more info in regard to this scenario?

Thank You in advance
Regards
Surabhi Ahuja

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-08-11 10:00:13 Re: regarding isolation between threads
Previous Message Richard Huxton 2005-08-11 09:35:03 Re: about pg_dump with --blobs