Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement
Date
Msg-id 22641.1171955272@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement  (Arjen van der Meijden <acmmailing@tweakers.net>)
Responses Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement  (Arjen van der Meijden <acmmailing@tweakers.net>)
List pgsql-bugs
Arjen van der Meijden <acmmailing@tweakers.net> writes:
> I had a look at that _close_pgsql_link-function and this it the code:

>      while ((res = PQgetResult(link))) {
>          PQclear(res);
>      }

> So there is indeed a very clear loop. But I'm not sure whether this code
> is incorrect as a generic "close the connection cleanly without memory
> leaks"-function?

It's surely incorrect as a means of getting out of a COPY state.  To
tell the truth, if their intention is to close the connection
unceremoniously, they should just do that, ie PQfinish or just quit
the application.  So I'd suggest removing that loop.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement
Next
From: Arjen van der Meijden
Date:
Subject: Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement