X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B1DA152886 for ; Tue, 21 Jun 2005 11:36:54 -0300 (ADT) 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 15993-05 for ; Tue, 21 Jun 2005 14:36:48 +0000 (GMT) Received: from hightowergroup.com (mail005.readyhosting.com [63.99.209.11]) by svr1.postgresql.org (Postfix) with ESMTP id 1CAEE52881 for ; Tue, 21 Jun 2005 11:36:47 -0300 (ADT) Received: from hightower10.mail.hightowergroup.com [66.109.231.196] by hightowergroup.com with ESMTP (SMTPD32-8.05) id A5FD4B70066; Tue, 21 Jun 2005 09:36:45 -0500 Message-Id: <6.1.2.0.2.20050621102941.03118720@mail.hightowergroup.com> X-Sender: dleedom@hightowergroup.com@mail.hightowergroup.com X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Tue, 21 Jun 2005 10:43:10 -0400 To: "Anjan Dave" , From: "David A. Leedom" Subject: Re: Temporary Tables In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78502EA14CB@vt-pe2550-001.van tage.vantage.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78502EA14CB@vt-pe2550-001.vantage.vantage.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_199820703==.ALT" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.539 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200506/159 X-Sequence-Number: 17914 --=====================_199820703==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Anjan, I would be very interested in this feature as well. However, my understanding is that you must keep the connection open AND your application must retain the SAME connection between database interactions. The only way that I have done this is by creating a Session ID column to your table of interest and make it a permanent table. The application then maintains the Session ID in memory and uses it to segregate the data from various users. My main interest in this is to create my own user table which triggers on other tables will somehow use to know that a specific user is making a change on a specific row(s). How do others handle this issue? Enthusiastically, Dave Leedom At 11:20 AM 6/20/2005, Anjan Dave wrote: >Hi, > >A developer is trying to use a Temporary Table via the java based >application. The problem is following the temp table creation, he wants >subsequent queries to query the temp table, but they are not in the same >database session as the temp table. Is this something I can setup >somewhere in the config? I would appreciate any pointers/info I can >forward to him. > >Thanks, >Anjan > > >****************************************************************************************** >This e-mail and any files transmitted with it are intended for the use of the >addressee(s) only and may be confidential and covered by the attorney/client >and other privileges. If you received this e-mail in error, please notify >the >sender; do not disclose, copy, distribute, or take any action in reliance on >the contents of this information; and delete it from your system. Any other >use of this e-mail is prohibited. >****************************************************************************************** > The Hightower Group, Inc. Custom Software Solutions Designed To Fit Your Business Like A Glove. 165 West Airport Road, Suite B/Lititz, PA 17543 V:717-560-4002, 877-560-4002 x: 114 F:717-560-2825 www.hightowergroup.com --=====================_199820703==.ALT Content-Type: text/html; charset="us-ascii" Anjan,

I would be very interested in this feature as well.  However, my understanding is that you must keep the connection open AND your application must retain the SAME connection between database interactions. 

The only way that I have done this is by creating a  Session ID column to your table of interest and make it a permanent table. The application then maintains the Session ID in memory and uses it to segregate the data from various users.

My main interest in this is to create my own user table which triggers on other tables will somehow use to know that a specific user is making a change on a specific row(s).

How do others handle this issue?

Enthusiastically,

Dave Leedom

At 11:20 AM 6/20/2005, Anjan Dave wrote:
Hi,
 
A developer is trying to use a Temporary Table via the java based application. The problem is following the temp table creation, he wants subsequent queries to query the temp table, but they are not in the same database session as the temp table. Is this something I can setup somewhere in the config? I would appreciate any pointers/info I can forward to him.
 
Thanks,
Anjan
 

******************************************************************************************

This e-mail and any files transmitted with
it are intended for the use of the

addressee(s) only and may be confidential
and covered by the attorney/client

and other privileges.  If you
received this e-mail in error, please notify the

sender; do not disclose, copy, distribute,
or take any action in reliance on

the contents of this information; and
delete it from your system. Any other

use of this e-mail is
prohibited.

******************************************************************************************
 



The Hightower Group, Inc.
Custom Software Solutions Designed To Fit Your Business Like A Glove.
165 West Airport Road, Suite B/Lititz, PA 17543
V:717-560-4002, 877-560-4002 x: 114
F:717-560-2825
www.hightowergroup.com
--=====================_199820703==.ALT--