| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Autovaccuum vs temp tables crash |
| Date: | 2019-02-22 18:03:54 |
| Message-ID: | CA+TgmoYTv39xe_KG-XzqMV5XuAyjX23ZUWWifBzkSLDDOmvYJA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Feb 22, 2019 at 12:54 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> > On Fri, Feb 22, 2019 at 3:43 AM Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> >> We are certainly not supposed to go DROP SCHEMA on the temp namespaces, ...
>
> > Actually, I think that's supposed to work.
>
> If it's in active use by any session (including your own), that's not going
> to have nice consequences; the owning session will have the OID in
> static storage, and it will be unhappy when that OID becomes dangling.
Maybe that's something we should fix?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2019-02-22 18:10:25 | Re: Remove Deprecated Exclusive Backup Mode |
| Previous Message | Justin Pryzby | 2019-02-22 18:01:46 | Re: speeding up planning with partitions |