Re: i got a process holding the lock

From: Vick Khera <vivek(at)khera(dot)org>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: i got a process holding the lock
Date: 2017-01-10 18:50:32
Message-ID: CALd+dccyCw14wXg+uJ99gHqvooacz+C_RrQFVJ4-yT4wAr3ghA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 10, 2017 at 1:39 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:

> *Why not just kill the blocking process first? Then everything else will
> proceed.*
>

That's what he said to do. You can do that with a `SELECT
pg_cancel_backend($pid)` query.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2017-01-10 19:31:09 Re: Materialized view vs. view
Previous Message Melvin Davidson 2017-01-10 18:44:12 Re: Materialized view vs. view