Re: [GENERAL] Kill -9 Postmaster and Temporary Tables

2003-09-09 Thread Tom Lane
Daniel Schuchardt <[EMAIL PROTECTED]> writes: > I'v noticed if you kill -9 the Postmaster Temporary Tables (Shemas) will stay in the > DB. That is a bad thing to do in any case ;-) But yeah, they'll stay around. In 7.3 and later, they will get cleaned out eventually (whenever someone next uses

[GENERAL] Kill -9 Postmaster and Temporary Tables

2003-09-09 Thread Daniel Schuchardt
Hi @ all, I'v noticed if you kill -9 the Postmaster Temporary Tables (Shemas) will stay in the DB. Also a VACUUM FULL will not remove them after restart. If the server craches (no power) its the same (I'v noticed it here) Daniel. ---(end of broadcast)-