On 05/23/2013 12:24 AM, Pascal Tufenkji wrote:
Hi,
To enhance the performance of the queries, I use temp tables in my website reports.
It seems that a temp table has not been dropped automatically in a certain session, and now the report is giving an error since the temp table already exists ?!
When I type the following, the database gives me an error:
dragon=# CREATE TEMP TABLE _parcours (id int);
ERROR: type "_parcours" already exists
1. How can I identify the session in which the temp table is still locked, so I can drop it manually
2. Why does those cases happen and the temp tables don’t drop automatically
Two questions:
1. Is that the exact message you are getting. I would expect *relation* "_parcours" already exists not *type*.
2. Are you using persistent connections or connection pooling?
It feels a bit like there is something leftover from a previous process that was using the same connection.
Cheers,
Steve