| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages) |
| Date: | 2019-01-17 21:54:36 |
| Message-ID: | 15908.1547762076@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I wrote:
> I propose that we handle this case by adding a new DEPFLAG_IS_SUBOBJECT
> flag to the column object's flags, denoting that we know the whole table
> will be dropped later. The only effect of this flag is to suppress
> reporting of the column object in reportDependentObjects.
Here's a proposed patch for that bit. As expected, it seems to eliminate
the variation in number-of-cascaded-drops-reported under
ignore_system_indexes. I do not see any regression outputs change
otherwise.
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| dont-report-subobjects-duplicatively-1.patch | text/x-diff | 2.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikael Kjellström | 2019-01-17 22:12:43 | Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD |
| Previous Message | Mikael Kjellström | 2019-01-17 21:47:33 | Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD |