Re: Information regarding Table-Locks

Le 16 janv. 2015 06:27, "sri harsha" <sriharsha9992(at)gmail(dot)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 <pierce(at)hogranch(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>