Q : aborting requests ? - Mailing list pgsql-general

From Mart Käsper
Subject Q : aborting requests ?
Date
Msg-id 39D9A0DC.C9A13377@netsoftlund.se
Whole thread Raw
List pgsql-general
Hi,

I read in the docs that each user connection runs as a Unix process
(RedHat Linux in my case).

* suppose one user has several connections to the database (through
  JDBC). He/she performs a query but after a while loses interest -
  is it possible to abort the query (Statement.cancel() within a certain
  Connection) ?

  I tried this with Sybase but it just kept on going, and going, and
  going ...

BTW, is it one process per user or one per user specific connection ?

Thanks in advance,

======================================================================
   Mart Käsper                 E-mail            : mart@netsoftlund.se
   Netsoft Lund AB
   Bredgatan 17                Tel (in place)    : +46 46  19 04 95
   SE-222 21 Lund, Sweden      Tel (on the road) : +46 70 319 04 95
======================================================================
#include <std.disclaimer>
======================================================================

   Life can be broken down into just a single unit - either you do a
   certain thing, or you don't.

pgsql-general by date:

Previous
From: "Ragnar Hakonarson"
Date:
Subject: RE: case insensitive matching
Next
From: "Otwell, Andrew (ISSAtlanta)"
Date:
Subject: distinct