Postgres and temporary tables

Question

I have a stored procedure that use temp table and explicitly drops it when done.

What happed when same procedure is run at same time by 2 different sessions? Sessions are run as single user (webapp).

Will one session interfere with temp table, and data inside it, of other session?

I'm using Postgres 9.0.

leonbloy · Accepted Answer · 2012-01-03 17:16:17Z

3

In postgresql temporary tables are unique for each session, so no problem.

answered Jan 3, 2012 at 17:16

leonbloy

76.5k22 gold badges149 silver badges198 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

boto · Accepted Answer · 2012-01-03 17:11:48Z

1

If I am not totally wrong, the result would be one temp table per query in your procedure which generates the temp table, so the two temp tables would not disturb eachother.

answered Jan 3, 2012 at 17:11

boto

4552 silver badges13 bronze badges

Collectives™ on Stack Overflow

Postgres and temporary tables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related