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 written into the file simultaneously and this is causing a data
> corruption . Is TABLE LOCK the only option available ??
In that case I would say that the FDW is broken.
If concurrent modifications corrupt the data, the FDW should make sure that not more
than one modification to the same data can happen at the same time, perhaps by using
PostgreSQL advisory locks or IPC mechanisms.
Yours,
Laurenz Albe