X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8F03ED1B550 for ; Tue, 2 Sep 2003 22:51:34 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 10355-10 for ; Tue, 2 Sep 2003 19:51:06 -0300 (ADT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.184]) by svr1.postgresql.org (Postfix) with ESMTP id 979B5D1B52C for ; Tue, 2 Sep 2003 19:50:58 -0300 (ADT) Received: from [212.227.126.205] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 19uJz9-0003lM-00; Wed, 03 Sep 2003 00:50:51 +0200 Received: from [80.129.130.184] (helo=pse-consulting.de) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 19uJz9-0002SL-00; Wed, 03 Sep 2003 00:50:51 +0200 Message-ID: <3F551EEC.7070001@pse-consulting.de> Date: Wed, 03 Sep 2003 00:51:24 +0200 From: Andreas Pflug User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bupp Phillips Cc: pgsql-bugs@postgresql.org Subject: Re: session variable References: <200309011811.37135.sad@bankir.ru> <200309011657.h81Gva817128@candle.pha.pa.us> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/17 X-Sequence-Number: 6648 Bupp Phillips wrote: >Could you possible have some type of variable (preferably the Transaction >ID) that can identify an individual process? > There's pg_backend_pid() for 7.4 and backend_pid() as contrib module for earlier releases. Regards, Andreas