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 <pie...@hogranch.com> 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
