Re: [HACKERS] Optional message to user when terminating/cancelling backend

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Onder Kalaci <onder(at)citusdata(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Optional message to user when terminating/cancelling backend
Date: 2018-07-06 00:18:02
Message-ID: CAEepm=2v_QTDGjGq2N0sJDeXvJG99J1pb8R9sEgubNWtqwwUkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jun 15, 2018 at 9:56 AM, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
> attached

Hi Daniel,

6118 --select pg_cancel_backend(pg_backend_pid(), 'it brings on many changes');
6119 select pg_cancel_backend(pg_backend_pid(), NULL);
6120! ERROR: canceling statement due to user request
6121--- 25,32 ----
6122
6123 --select pg_cancel_backend(pg_backend_pid(), 'it brings on many changes');
6124 select pg_cancel_backend(pg_backend_pid(), NULL);
6125! pg_cancel_backend
6126! -------------------
6127! t

Apparently Windows can take or leave it as it pleases.

https://ci.appveyor.com/project/postgresql-cfbot/postgresql/build/1.0.4488

--
Thomas Munro
http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-07-06 00:21:41 Re: Copy function for logical replication slots
Previous Message Andrew Dunstan 2018-07-05 23:54:46 Re: Desirability of client-side expressions in psql?