Re: ERROR: canceling statement due to user request - Mailing list pgsql-general

From Pavel Stehule
Subject Re: ERROR: canceling statement due to user request
Date
Msg-id CAFj8pRBzwznwe4xn3iqf+ZNpnzEy5_dpFJVZDQxnamhze4H=SA@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: canceling statement due to user request  (Paul Förster <paul.foerster@gmail.com>)
List pgsql-general


st 5. 8. 2020 v 12:07 odesílatel Paul Förster <paul.foerster@gmail.com> napsal:
Hi Jaurès,

> On 05. Aug, 2020, at 11:35, FOUTE K. Jaurès <jauresfoute@gmail.com> wrote:
>
> Hello,
>
> How can I Solve this error ?
>
> ERROR:  canceling statement due to user request

simple: don't make the user hit ctrl-c or otherwise interrupt a transaction in progress.

As soon, as a transaction is interrupted, you'll get the message. This is mostly informational and not necessarily an error per se.

If we talk about "psql" then you can do nothing. If you want to change this behavior, you have to modify source code and recompile it.

Regards

Pavel

 
Cheers,
Paul

pgsql-general by date:

Previous
From: Paul Förster
Date:
Subject: Re: ERROR: canceling statement due to user request
Next
From: FOUTE K. Jaurès
Date:
Subject: Re: ERROR: canceling statement due to user request