Re: temporary tables ? - Mailing list pgsql-general

From Sean Davis
Subject Re: temporary tables ?
Date
Msg-id 1db9e473a952c72cf10425a9d980c227@mail.nih.gov
Whole thread Raw
In response to temporary tables ?  ("Zlatko Matic" <zlatko.matic1@sb.t-com.hr>)
Responses Re: temporary tables ?
List pgsql-general
On Jul 22, 2005, at 1:55 PM, Zlatko Matic wrote:

> Hello.
> I have some tables that are updated by several users in the same time
> and are used in queries for reports. Those tables have rows that are
> actualy copied from original  tables that are not to be altered. There
> is a procedure that inserts rows for every user when connects, along
> with his username, so different users can't interfere with each other
> because every user has his own copy of rows that he can update, and
> records are filtered by current_user.
> Well, it's my heritage from MS Access, before I moved to Postgres,
> because there is no such thing as temporary table in Access...
> Now, I'm wondering is there any true advantage to implement temporary
> tables for each user, insted of one table with inserted rows with
> username for every user ?

Temporary tables are not per-user, but per-connection.  A user can be
connected twice, but a temporary table created on one connection is not
visible from the other connection.  Also, temporary tables are
temporary--they disappear after the connection is closed.


pgsql-general by date:

Previous
From: "Zlatko Matic"
Date:
Subject: temporary tables ?
Next
From: Tony Caduto
Date:
Subject: Re: temporary tables ?