sri harsha wrote:
>>>Is there any way to stop concurrent inserts to happen on a single table
>>> ??
>> If you really want that, it is easy with table locks.
> Actually i am using a FDW , in which the data is written into a single
> file. So when i do
> concurrent inserts , the data is w
Hi,
Actually i am using a FDW , in which the data is written into a single
file. So when i do concurrent inserts , the data is written into the file
simultaneously and this is causing a data corruption . Is TABLE LOCK the
only option available ??
--Harsha
On Wed, Jan 21, 2015 at 3:22 PM, A
sri harsha wrote:
>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
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
.
