From: | fisher73(at)gazeta(dot)pl (NO-fisher-SPAM_PLEASE) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | temp tables ORACLE/PGSQL |
Date: | 2005-04-28 05:46:24 |
Message-ID: | dfe1afd9.0504272146.6130aee@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I used to work with Oracle and now tryin' PostgreSQL I'm a bit
confused.
I found that creating temp table in one session does not make it
available for other sessions for the same user? Is this intended??
I was tryin to use because of lack of session and package variables in
PGSQL (thats what I know). But I'm not sure if I have to create a
temp table at the beginning of each session? Or just like in Oracle
create temp table definition and all whats temporar is data.
If creating a temp table for each connection is a must then maybe You
can tell me if there is any triger /event that is being called during
connecting to db. I guess that would be the best place to create temp
tables and feed it up with session parameters.
Regards
fisher
From | Date | Subject | |
---|---|---|---|
Next Message | Typing80wpm | 2005-04-28 06:28:25 | Thanks for insights into internal design |
Previous Message | Tony Caduto | 2005-04-28 03:45:47 | Re: Visual Query Builder |