Re: Is possible cancel cycle of reading pg_getcopydata?

Pavel Stehule <[email protected]> Thu, 11 Feb 2016 17:06:54 +0100 (CET)

Newsgroups	gmane.comp.db.postgresql.dbdpg
Message-ID	<[email protected]>

On Thu, 11 Feb 2016, Pavel Stehule wrote:

> Hi all
>
> I use synchronnous function pg_getcopydata. Sometimes I need to leave cycle 
> immediately. The exit is working, but it produce FATAL error "connection to 
> client lost". Is it possible to reset connection and leaving without this 
> message?

I found it - the necessary to call undocumented method pg_endcopy()

Regards

Pavel
>
> Regards
>
> Pavel Stehule
>
>