Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 2B1E66332A8
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 20 Apr 2010 11:49:43 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 24362-04-2
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 20 Apr 2010 14:49:23 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f214.google.com (mail-gx0-f214.google.com
	[209.85.217.214])
	by mail.postgresql.org (Postfix) with ESMTP id 22E0E636801
	for <pgsql-admin@postgresql.org>; Tue, 20 Apr 2010 11:29:10 -0300 (ADT)
Received: by gxk6 with SMTP id 6so101657gxk.14
	for <pgsql-admin@postgresql.org>; Tue, 20 Apr 2010 07:29:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:received:message-id:subject:from:to:cc:content-type;
	bh=S4hBBAAKmx+qjn4aDZMA1VxvymQsIobJW/ZnyWeU/MM=;
	b=V7aOpF6IZ2ycKPiu43dlUPEbCIR2WLGjwBcT/Wy2HLlqlFOEzuq/1PPwirw6q4SUW4
	fHAeIlx9S6zz9VQ9IiTjzZTl5DL/NuTGcFgf162+MrLvnZJpF6/H0DcbI/EcwMpv9XbK
	qnfrwL5ZmPsXaodRmeZq2gc+OQxhHxtrTttxc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=cfdzefGbm3qP/C+r1rzD6N5OqSk/eHc0AA8buegyzecooSzTDKsSFJEZ9IOhZNA2jp
	rvw2bS6J8/WNVMu7PaiTHPNDrdxs3ymzF8FroJ2p4ZFJlsHDhN2uX3Jn+JVSe7qhECvm
	njoXZmuLoXN2EVe7OvGv2zIoqK7lnk/WuC4Vk=
MIME-Version: 1.0
Received: by 10.150.218.9 with HTTP; Tue, 20 Apr 2010 07:29:08 -0700 (PDT)
In-Reply-To: <25670.1271770280@sss.pgh.pa.us>
References: <480516.98593.qm@web28311.mail.ukl.yahoo.com>
	<l2nc3a7de1f1004190852nbbfb67f3v9cba052fdbb0b599@mail.gmail.com>
	<z2j4ec1cf761004191824ibad49657odff2914710d343fc@mail.gmail.com>
	<15823.1271729409@sss.pgh.pa.us>
	<h2vdcc563d11004192007u167088d7g77900fca2c3a40e3@mail.gmail.com>
	<25670.1271770280@sss.pgh.pa.us>
Date: Tue, 20 Apr 2010 08:29:08 -0600
Received: by 10.151.118.9 with SMTP id v9mr7310370ybm.346.1271773748896; Tue,
	20 Apr 2010 07:29:08 -0700 (PDT)
Message-ID: <m2wdcc563d11004200729ze7e8b6bfu63b0ffc94b7d9eb5@mail.gmail.com>
Subject: Re: How to disconnect a single user in Postgresql 8.2.5 from
	a database
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Josh Kupershmidt <schmiddy@gmail.com>,
 Sergey Konoplev <gray.ru@gmail.com>,
	Steph L <engel306sl@yahoo.fr>, pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.085 tagged_above=-10 required=5 tests=AWL=-0.185,
	BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201004/273
X-Sequence-Number: 34367

On Tue, Apr 20, 2010 at 7:31 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Scott Marlowe <scott.marlowe@gmail.com> writes:
>> On Mon, Apr 19, 2010 at 8:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> The reason the function isn't there before 8.4 is that that's not
>>> promised to work before 8.4 ... most of the time it will work, but
>>> once in awhile you could get nasty side-effects.
>
>> So, pg_cancel_backend(pid) is the 8.3 version, that may or may not
>> always work then, right?
>
> No, I didn't say that.

Well, my experience with it has been that it's similar and it doesn't
always work.