Le 16 janv. 2015 06:27, "sri harsha" <sriharsha9...@gmail.com> a écrit : > > 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 ?? >
If they are both regular tables, they can insert at the same time. But you can't rename a take while it's being read or written. > --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 > >
