Re: Cancelling Requests Frontend/Backend Protocol TCP/IP - Mailing list pgsql-general

From Raimon Fernandez
Subject Re: Cancelling Requests Frontend/Backend Protocol TCP/IP
Date
Msg-id B1EA5872-6E57-46A8-BF35-3192707A5C0F@montx.com
Whole thread Raw
In response to Re: Implementing Frontend/Backend Protocol TCP/IP  (Raimon Fernandez <coder@montx.com>)
Responses Re: Cancelling Requests Frontend/Backend Protocol TCP/IP
Re: Cancelling Requests Frontend/Backend Protocol TCP/IP
Encoding using the Frontend/Backend Protocol TCP/IP
List pgsql-general
Hello,


For what I've read in the manuals, this operation is only valid before
PostgreSQL has finished processing the SELECT statement ?

If for example I send  a SELECT * from myTable, it has 20000 rows, and
postgre starts sending the rows, how I can cancel this operation ?

I thought Cancelling Requests would be perfect for this ... the
workaround is closing and opening again the connection but I don't
like this approach ...

thanks,

regards,


raimon


pgsql-general by date:

Previous
From: Vasiliy G Tolstov
Date:
Subject: Re: cidr data type question
Next
From: Raimon Fernandez
Date:
Subject: Re: DataRow Null values Frontend/Backend Protocol TCP/IP