Hi,
Is there any way to stop concurrent inserts to happen on a single table
??
Query 1 : INSERT INTO TABLE_A SELECT * FROM TABLE1;
Query 2 : INSERT INTO TABLE_A SELECT * FROM TABLE2;
Query 3 : SELECT * FROM TABLE_A;
Assume i have the above queries. Query 1 and Query 3 can occur concurrently
. If one insert is taking place , the other should wait. How do i achieve
this ??
How do the concurrent inserts take place in postgres ?? Is data stored
temporarily for both queries separately and then written into the table ??
Thanks,
Harsha