I believe they are created when either a function / program creates a temporary table.
On Wed, May 19, 2004 at 08:32:06AM -0400, Jerry Sievers wrote: > Hello. > > I'm running postgres 7.4.1 and notice an accumulation of temp schemas > named pg_temp_1, pg_temp_2... etc. > > These schemas are empty and I have manually removed them from time to > time. > > What procedure is leaving these behind and is there a way for me to > have them cleaned up automatically after use? > > Thanks. > > -- > ------------------------------------------------------------------------------- > Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant > 305 321-1144 (mobile http://www.JerrySievers.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
