| 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 |
| 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 |