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 82FAED1B8FC for ; Tue, 2 Sep 2003 01:53:26 +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 95375-09 for ; Mon, 1 Sep 2003 22:53:19 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id EA947D1B8BD for ; Mon, 1 Sep 2003 22:53:15 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h821rFek041171 for ; Tue, 2 Sep 2003 01:53:15 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h821SVe1036686 for pgsql-bugs@postgresql.org; Tue, 2 Sep 2003 01:28:31 GMT From: "Bupp Phillips" X-Newsgroups: comp.databases.postgresql.bugs Subject: Re: session variable Date: Mon, 1 Sep 2003 18:28:47 -0700 Organization: Hub.Org Networking Services Lines: 29 Message-ID: References: <200309011811.37135.sad@bankir.ru> <200309011657.h81Gva817128@candle.pha.pa.us> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 To: pgsql-bugs@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/14 X-Sequence-Number: 6645 Could you possible have some type of variable (preferably the Transaction ID) that can identify an individual process? If something like this already exist, then disregard this post. "Bruce Momjian" wrote in message news:200309011657.h81Gva817128@candle.pha.pa.us... > sad wrote: > > Good day > > > > is it possible to define user variables in session ? > > If not then is it planned to implement ? > > or it is principially impossible in PosqtgreSQL > > psql has variables, but in general we don't support session varibles. > You could create a temp table and put a value in there easily. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >