Hi John.
What if my query was INSERT INTO Postgres_Table_A SELECT * FROM Postgres_Table_B ?? What are the locks given for the two tables ??
--Harsha
On Fri, Jan 16, 2015 at 10:50 AM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 1/15/2015 9:14 PM, sri harsha wrote:
What kind of lock will the second table will be in ?
I suspect that depends on what FOREIGN_TABLE is connected to.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
