Re: Temporary tables and miscellaneous schemas

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: btober(at)seaworthysys(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Temporary tables and miscellaneous schemas
Date: 2003-10-13 19:34:35
Message-ID: 20031013193435.GC72842@perrin.nxad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
patch text/plain 670 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-10-13 19:50:19 Re: Temporary tables and miscellaneous schemas
Previous Message Sean Chittenden 2003-10-13 19:10:23 Re: go for a script! / ex: PostgreSQL vs. MySQL