Re: Long running INSERT+SELECT query

From: Vitaliy Garnashevich <vgarnashevich(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Long running INSERT+SELECT query
Date: 2018-04-26 17:45:37
Message-ID: ce1a27f4-6085-6be4-8b9e-08598fd7e5eb@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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."

Regards,
Vitaliy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-04-26 17:51:25 Re: Long running INSERT+SELECT query
Previous Message Adrian Klaver 2018-04-26 17:30:09 Re: Issue on public schéma with Pg_restore