Le 16 janv. 2015 06:27, "sri harsha" <sriharsha9992@xxxxxxxxx> 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 <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
>
>
