Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tdbZH-008Qe4-Bu for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Jan 2025 20:55:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tdbZF-00DFms-3H for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Jan 2025 20:55:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tdbZE-00DFmk-6M for pgsql-hackers@lists.postgresql.org; Thu, 30 Jan 2025 20:55:16 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tdbZA-002LpU-0U for pgsql-hackers@postgresql.org; Thu, 30 Jan 2025 20:55:14 +0000 Received: by mail-pl1-x62a.google.com with SMTP id d9443c01a7336-2165448243fso11386035ad.1 for ; Thu, 30 Jan 2025 12:55:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgguru-net.20230601.gappssmtp.com; s=20230601; t=1738270511; x=1738875311; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=0+jyjfwu6BHvWvax15RXqMhr0GMSIE2qKMyiS/plMjU=; b=UaKk6E7gbEWZQ26DWH8XdMDf+5wLO8cyMvc+i14pxetmeBG3IhIQi4TULZsirnMLjb Ob6+Hzbbbk7lnF+5hFrC6w/XKmadxgBbKQ1uudElt5IkVNAIXCkQa6y4hl6XWbXEbECG Nj99Q9RfUTYI+BaVwfPbnmtmGqsf5LtZmMgHpe6uBMry276+GLlDQ2p4pwgrEcnRrGlP rs4PuUumMEZqPv8YKjZoK3GWVolgbuVeIawdn9hswiUltLHsPYnFuVOlZ9Tc4qhEH4IL teapMnPVcscLIjKNqa18Mx/cBphDvEWnnaKybYUOs1gvVIRNO0eoeUTPxQ2DGgkifNqL 81fA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738270511; x=1738875311; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=0+jyjfwu6BHvWvax15RXqMhr0GMSIE2qKMyiS/plMjU=; b=aoqgWXS7H96scLHCybSo4jEE6F3sy1XwhUSrxWnl8KOuUya72LGwyWxVhCORfeOxBL NqNSA5NnlQaVZ8uFoyPbjKAuTkCLRTKoRComfVHMHZGsGgR1pqdE5++esZN/HqpAACX/ jZwEJyvxV1G9PFcWc5wn2/z5UdYvOLonIg8SR65uLTPmdwI7QL5JbT4sbciymYPfw91D eFSkcCJAFoNCLkKozMdCNpL+jZiqAyReD3giINQJfXZJnqwthiEcWN/g8YBCLW3VExQA +HVXl3RqqEVziB1Zv/EMFsS3kkGOfj4D/t4pJlzi7Qp5B1IJKhlM2NeaojoQUjUTASPm fFlQ== X-Forwarded-Encrypted: i=1; AJvYcCUBREKWFvuu/cgdgXIMm2ilOZh0G4ndBM77YwQ2U+3CSyKi5GPhzEwSlE4/6K/ZyuWqznXEWpkVHgKygwJg@postgresql.org X-Gm-Message-State: AOJu0YyteQVPR0vl9RcWT2rSyMk4ySGisgzfi9hBHhOInUuNa8l62YnX w9lbd7hmNmzV/xdeEZsHLBBnHCPfhMnsm66LKT5acXSD5OvnIqELEeos1SsyZRhAO8efNUbHNur NM5wC6SNWKyKo6jdG8VTX/qLAOcuQj8JCP4Bb+A== X-Gm-Gg: ASbGncv5cbcKzupdYfUwwmpbESJ3vBF0piOMkkWL9sbHfVaY+rciLGHkwHr7sO8xH7d 9H1aQM42jijyGJr9uErhN38YXbzVn1y6/uRSo4mTpEioZIkrvfcAKuxhG7kyirQLApx0CX+no05 Mqn86cN8WXVQaTSxd3EOHQYg92huGpTA== X-Google-Smtp-Source: AGHT+IEgWgRIHGcP9Vfe/S1+Yh+zXMf5yhAK397LraQn8C20V5f6yisnwpaPvhzQ2vpUe46Vw6ulzN9LxK61aZFp97U= X-Received: by 2002:a05:6a20:d527:b0:1ed:75f4:d290 with SMTP id adf61e73a8af0-1ed7a5d54d8mr15655685637.29.1738270511593; Thu, 30 Jan 2025 12:55:11 -0800 (PST) MIME-Version: 1.0 References: <8c9b9b7d-0868-46d4-963c-8b1906bd7a1b@eisentraut.org> <72f6995a-75a6-4579-9e93-45a80f6bd956@eisentraut.org> <2597072.1737232674@sss.pgh.pa.us> In-Reply-To: <2597072.1737232674@sss.pgh.pa.us> From: David Christensen Date: Thu, 30 Jan 2025 14:55:00 -0600 X-Gm-Features: AWEUYZmIZOwAl5BibU_x-vjEQ2uxeFF_uj3joqIxyjh2Cg1JVGkKarRaN6GAKqQ Message-ID: Subject: Re: Adding comments to help understand psql hidden queries To: Tom Lane Cc: Peter Eisentraut , Greg Sabino Mullane , Jim Jones , pgsql-hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Jan 18, 2025 at 2:37=E2=80=AFPM Tom Lane wrote: > > David Christensen writes: > > Any further concerns/issues with this patch that I can address to help > > move it forward? > > I got around to looking at this finally --- sorry that it's been on > the back burner for so long. I think this is basically a good idea > but it still requires a lot of sanding-down of rough edges. Hi Tom, thanks for the detailed feedback. I'll take your v6 and see about adding the additional changes; I agree with what you've pointed out at the high level, and will respond with additional questions of my own if things seem ambiguous in terms of approach. Thanks, David