Postgres Pro
Downloads
Home   >   mailing lists

Thread: Temporary Tables

Temporary Tables

From
"moises"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">Hello,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Maybe this question is not logic, but for me is very important.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">I was tested some temporary tables and, of course are very fast, because they are in
memory.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial">But one table created by one connection, can´t be modified by others
connections?</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial">I want to know if exist some way to shared a temporary table between 2
connections.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Thanks</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Moisés</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">- </span></font></div>

Re: Temporary Tables

From
Peter Eisentraut
Date:
moises wrote:
> I want to know if exist some way to shared a temporary table between
> 2 connections.

No.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Temporary Tables

From
Andrew Dunstan
Date:
moises wrote:
>
> Hello,
>
> Maybe this question is not logic, but for me is very important.
>
>  
>
> I was tested some temporary tables and, of course are very fast, 
> because they are in memory.
>
> But one table created by one connection, can´t be modified by others 
> connections?
>
> I want to know if exist some way to shared a temporary table between 2 
> connections.
>
>  
>

By definition temp tables are per session. If you want them shared then 
you want something other than temp tables.

And they are not always in memory either - otherwise what would happen 
to a temp  table that was bigger than available memory?

Lastly, this is the wrong list for this question - this list is about 
postgres development. You should ask questions like this on pgsql-general.

cheers

andrew