X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BE6A49FCF68 for ; Mon, 28 Aug 2006 11:29:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 61623-07 for ; Mon, 28 Aug 2006 11:29:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 234ED9FCF60 for ; Mon, 28 Aug 2006 11:29:21 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so1622094ugc for ; Mon, 28 Aug 2006 07:29:20 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=CXCQDwpkrz9KegCT1QWE3Cbm6wl8PVHADeREHiYdRrNo7ldTURFu2b809t8IZMewRPj0DDmUaamOmWBqVZKqKMiamCUP+MoSZ7sWrWSDH/tDIhYLgi8SHuHWwxdbjKISbweOgC7LULNmwmD8aMm3OfmVagiKvAWvzghlbzwMQDk= Received: by 10.67.10.12 with SMTP id n12mr3764415ugi; Mon, 28 Aug 2006 07:29:20 -0700 (PDT) Received: by 10.66.248.13 with HTTP; Mon, 28 Aug 2006 07:29:20 -0700 (PDT) Message-ID: <7539aebb0608280729g7094affkeac9594c828f56d2@mail.gmail.com> Date: Mon, 28 Aug 2006 10:29:20 -0400 From: Sumeet To: pgsql-sql@postgresql.org Subject: Temporary Views or tables MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_233825_31928190.1156775360118" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.264 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_00_10, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200608/221 X-Sequence-Number: 26179 ------=_Part_233825_31928190.1156775360118 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, I'm trying to use temporary views in my application, before i proceed and go ahead for creating the temorary view i would like more abt it. 1) when is the temporary view automatically deleted. Is it after we close the connection or when the session ends....for.e.g my website doesnt use a persistant connection to my postgres server and it queries and then disconnects from the db server. In one of such connections...if i create a temporary view will this temp view be visible to me after multiple disconnects and connects ???? 2) Is the view approach faster then creating temporary tables??? (and the same question as abovew for temp. tables.) 3) If there are multiple users who connect to my website at the same time and create temporary views or tables with the same name would there be any overlapping or such??? -- Thanks, Sumeet. ------=_Part_233825_31928190.1156775360118 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all,

I'm trying to use temporary views in my application, before i proceed and go ahead for creating the temorary view i would like more abt it.
1) when is the temporary view automatically deleted. Is it after we close the connection or when the session ends....for.e.g  my website doesnt
  use a persistant connection to my postgres server and it queries and then disconnects from the db server. In one of such connections...if i create a temporary view
  will this temp view be visible to me after multiple disconnects and connects ????
2) Is the view approach faster then creating temporary tables??? (and the same question as abovew for temp. tables.)
3) If there are multiple users who connect to my website at the same time and create temporary views or tables with the same name would there be any overlapping or such???

--
Thanks,
Sumeet.
------=_Part_233825_31928190.1156775360118--