Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: temp tables problem


  • From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
  • To: sconeek(at)gmail(dot)com
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject: Re: temp tables problem
  • Date: Fri, 21 Apr 2006 15:23:03 -0500
  • Message-id: <20060421202303(dot)GR49405(at)pervasive(dot)com>

On Thu, Apr 20, 2006 at 09:21:27PM -0700, sconeek(at)gmail(dot)com wrote:
> just to add on that, there is only one user for the db. so both
> application accesses use the same db username and password. the web app
> automatically logs into the db in with the one username and password
> for both remote and local access.

Users don't matter at all for temp tables. Temp tables are per
*session*, so as soon as you come in from a different connection it's a
different set of temp tables.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group