Re: Leftover TEMPORARY tables?

I'm running 7.3.1 and I seem to get a fair number of these as well.  I have no 
problems removing them, possibly because the processes associated with them are 
really gone.

My best estimate as to when they appear is when I abort a transaction in 
PGAdminII by killing the corresponding process on the server ("kill -9 XXXX"), 
but that alone doesn't seem to account for all of them.  I DEFINITELY never 
have backend crashes - steady as a rock, and I love it for that :-).

This begs the question:  what is a more elegant way to kill a runaway PGAdminII 
transaction, when PGAdminII is running on Windows and I don't want to kill 
PGAdminII itself (because it's executing a complex query I don't want to re-
write from scratch)?

Thanks,

		Andrew

4/23/03 11:51:07 PM, Tom Lane  wrote:

>jboes@nexcerpt.com (Jeff Boes) writes:
>> I just noticed that there are a number of tables in our schema with
>> names fo the form pg_temp_*; these correspond to temporary tables
>> created by our application, but they shouldn't still exist. Under what
>> circumstances would a temporary table become permanent?
>
>In theory, never.  Do you have frequent backend crashes?  Is it possible
>that the backend sessions that created these tables are actually still
>running?
>
>If you're quite certain that the sessions that created those tables are
>dead, it is safe to issue DROPs against them.  I am not sure whether you
>have to jump through any hoops to do so though --- the protection
>checks against dropping system tables look for "pg_XXX" and so are
>likely to mutiny :-(.  You might need to run a standalone backend with
>the -O command-line switch to get around that protection check.
>
>PG 7.3 handles this scenario a little better, but I take it you haven't
>upgraded yet ...
>
>			regards, tom lane
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>