X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 922393A3FA9 for ; Wed, 17 Nov 2004 14:27:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82421-10 for ; Wed, 17 Nov 2004 14:27:30 +0000 (GMT) Received: from web13912.mail.yahoo.com (web13912.mail.yahoo.com [216.136.174.62]) by svr1.postgresql.org (Postfix) with SMTP id 882343A3F59 for ; Wed, 17 Nov 2004 14:27:32 +0000 (GMT) Received: (qmail 60977 invoked by uid 60001); 17 Nov 2004 14:27:32 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=t6WiYYIToy1yG+Wbu/NK23eHyZGuVS8EHOpGXBZ8bs+nvzKRtYnzj5dvQJJO5CzR4QpJHzXM0qYa1O4ixerCRNeiaG7UmYiXZiLxzx4d46GaoN1hruu8Ze4WG/2WqOMU0hcbtIuIo5Ng7lKGh+jBNhuDgGloNHE00PsSMMnRt4Y= ; Message-ID: <20041117142732.60975.qmail@web13912.mail.yahoo.com> Received: from [80.67.100.162] by web13912.mail.yahoo.com via HTTP; Wed, 17 Nov 2004 06:27:32 PST Date: Wed, 17 Nov 2004 06:27:32 -0800 (PST) From: "Riccardo G. Facchini" Reply-To: abief_ag_-postgresql@yahoo.com Subject: Re: session_id To: Achilleus Mantzios , Richard Huxton Cc: abief_ag_-postgresql@yahoo.com, pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/172 X-Sequence-Number: 19491 --- Achilleus Mantzios <__> wrote: > O Richard Huxton έγραψε στις Nov 17, 2004 : > > > Riccardo G. Facchini wrote: > > > hi all, > > > > > > is there a way to determine the session id on a database session? > > > > > > I would need to have a unique number whenever a session is > started, and > > > have this available as a function or view result. > > Why not SELECT pg_backend_pid(); > ?? > > > [..] that could work. Is this the unique value for my own session? can somebody confirm it? regards, R.