From f0d11275954719fd5d0281d4135e5c78de46e099 Mon Sep 17 00:00:00 2001 From: David Rowley Date: Mon, 12 Aug 2024 15:42:16 +1200 Subject: Remove "parent" column from pg_backend_memory_contexts 32d3ed816 added the "path" column to pg_backend_memory_contexts to allow a stable method of obtaining the parent MemoryContext of a given row in the view. Using the "path" column is now the preferred method of obtaining the parent row. Previously, any queries which were self-joining to this view using the "name" and "parent" columns could get incorrect results due to the fact that names are not unique. Here we aim to explicitly break such queries so that they can be corrected and use the "path" column instead. It is possible that there are more innocent users of the parent column that just need an indication of the parent and having to write out a self-joining CTE may be an unnecessary hassle for those cases. Let's remove the column for now and see if anyone comes back with any complaints. This does seem like a good time to attempt to get rid of the column as we still have around 1 year to revert this if someone comes back with a valid complaint. Plus this view is new to v14 and is quite niche, so perhaps not many people will be affected. Author: Melih Mutlu Discussion: https://postgr.es/m/CAGPVpCT7NOe4fZXRL8XaoxHpSXYTu6GTpULT_3E-HT9hzjoFRA@mail.gmail.com --- doc/src/sgml/system-views.sgml | 9 --------- 1 file changed, 9 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/system-views.sgml b/doc/src/sgml/system-views.sgml index a0b692bf1e9..634a4c0fab4 100644 --- a/doc/src/sgml/system-views.sgml +++ b/doc/src/sgml/system-views.sgml @@ -481,15 +481,6 @@ - - - parent text - - - Name of the parent of this memory context - - - type text -- cgit v1.2.3