Re: Temp tables

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