Postgres Pro
Downloads
Home   >   mailing lists

Re: Kill -9 Postmaster and Temporary Tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Kill -9 Postmaster and Temporary Tables
Date
Msg-id 11781.1063140901@sss.pgh.pa.us
Whole thread Raw
In response to Kill -9 Postmaster and Temporary Tables  (Daniel Schuchardt <daniel_schuchardt@web.de>)
List pgsql-general
Tree view 
Daniel Schuchardt <daniel_schuchardt@web.de> 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 the same temp schema).

            regards, tom lane

pgsql-general by date:

Previous
From: "Darko Prenosil"
Date:
Subject: Re: Picture with Postgres and Delphi
Next
From: Tom Lane
Date:
Subject: Re: any chance of "like ANY (array[])" like the "= ANY (array[])" syntax?