Re: Long running INSERT+SELECT query

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Vitaliy Garnashevich <vgarnashevich(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Long running INSERT+SELECT query
Date: 2018-04-26 17:51:25
Message-ID: 39121e73-b04a-77c4-cb5f-55530e82f0d3@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/26/2018 10:45 AM, Vitaliy Garnashevich wrote:
>
>> SELECT .. FOR UPDATE?:
>>
>> https://www.postgresql.org/docs/10/static/sql-select.html#SQL-FOR-UPDATE-SHARE
>>
>>
>> https://www.postgresql.org/docs/10/static/explicit-locking.html#LOCKING-ROWS
>>
>
> It says: "Currently, FOR NO KEY UPDATE, FOR UPDATE, FOR SHARE and FOR
> KEY SHARE cannot be specified with GROUP BY."

Without the query we are flying blind, so suggestions will have a ?

>
> Regards,
> Vitaliy

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vitaliy Garnashevich 2018-04-26 18:08:01 Re: Long running INSERT+SELECT query
Previous Message Vitaliy Garnashevich 2018-04-26 17:45:37 Re: Long running INSERT+SELECT query