temp tables ORACLE/PGSQL

Поиск
Список
Период
Сортировка
Искать
От
fisher73@gazeta.pl (NO-fisher-SPAM_PLEASE)
Тема
temp tables ORACLE/PGSQL
Дата
Msg-id
dfe1afd9.0504272146.6130aee@posting.google.com
Список
Дерево обсуждения
temp tables ORACLE/PGSQL fisher73@gazeta.pl (NO-fisher-SPAM_PLEASE)
Re: temp tables ORACLE/PGSQL Dennis Sacks <dennis@illusions.com>
Re: temp tables ORACLE/PGSQL Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: temp tables ORACLE/PGSQL Steve Atkins <steve@blighty.com>
Re: temp tables ORACLE/PGSQL Dennis Sacks <dennis@illusions.com>
Re: temp tables ORACLE/PGSQL Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: temp tables ORACLE/PGSQL Neil Conway <neilc@samurai.com>
Re: temp tables ORACLE/PGSQL Pavel Stehule <stehule@kix.fsv.cvut.cz>
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
В списке pgsql-general по дате отправления
От: Ron Mayer
Дата:
От: fritz-bayer@web.de (Fritz Bayer)
Дата:
FAQ