Re: ERROR: canceling statement due to user request

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

st 5. 8. 2020 v 12:07 odesílatel Paul Förster <paul.foerster@xxxxxxxxx> napsal:

Hi Jaurès,

> On 05. Aug, 2020, at 11:35, FOUTE K. Jaurès <jauresfoute@xxxxxxxxx> 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