Re: Temporary tables and miscellaneous schemas - Mailing list pgsql-general

From Sean Chittenden
Subject Re: Temporary tables and miscellaneous schemas
Date
Msg-id 20031013193435.GC72842@perrin.nxad.com
Whole thread Raw
In response to Re: Temporary tables and miscellaneous schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Temporary tables and miscellaneous schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > To follow-up then, if the temp schemas do not disappear, then over
> > time what happens (as temp tables are instantiated during normal
> > application usage), does the database end up with an
> > ever-increasing number of these temp schemas?
>
> No, you will never have more than max_connections of them.

This implementation detail really annoys me when using psql.  The
attached patch fixes \dn to not show pg_temp_*.  Any chance someone
could apply this?  -sc

--
Sean Chittenden

Attachment

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: "slicing" records
Next
From: Tom Lane
Date:
Subject: Re: Temporary tables and miscellaneous schemas