Обсуждение: Temporary Tables
<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>
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/
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