SEO

#1 (**permalink**) 04-12-2008, 03:48 AM

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.

Thanks

Moisés

-

#2 (**permalink**) 04-12-2008, 03:48 AM

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/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#3 (**permalink**) 04-12-2008, 03:49 AM

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Temporary Tables