Hi,
I have a few doubts regarding table locks. Assume I am executing the
following query
Query 1 -- INSERT INTO FOREIGN_TABLE SELECT * FROM POSTGRES_TABLE
Query 2 -- INSERT INTO FOREIGN_TABLE SELECT * FROM FOREIGN_TABLE
If i get a table lock for the foreign table , will the second table from
which i am getting the data will also come under this lock ?? Or is it a
separate lock ?? Does postgres handle that lock ??
What kind of lock will the second table will be in ?? Can i rename the
second table while executing the INSERT QUERY ??
Thanks,
Harsha