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 1sHAO9-0048m3-EB for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jun 2024 22:54:50 +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 1sHAO8-00B1sM-1J for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jun 2024 22:54:48 +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 1sHAO7-00B1sA-NP for pgsql-hackers@lists.postgresql.org; Tue, 11 Jun 2024 22:54:48 +0000 Received: from mail-pj1-x1031.google.com ([2607:f8b0:4864:20::1031]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sHAO6-000raX-0s for pgsql-hackers@postgresql.org; Tue, 11 Jun 2024 22:54:47 +0000 Received: by mail-pj1-x1031.google.com with SMTP id 98e67ed59e1d1-2c2f4e868ceso1487024a91.1 for ; Tue, 11 Jun 2024 15:54:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgguru-net.20230601.gappssmtp.com; s=20230601; t=1718146485; x=1718751285; 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=BA0O4pFtV5O1BSMlNfeFNDCZ3CTkC0hL0hm4huhI6bo=; b=Knfv5kPCjDDo62jKhHkSjOTNUKpPtzqVMzyRCcVODlGOBVy9nrXIMRzGqTGCSy5WYK 6l31jiPgnqE0JbOkjKo4ZeuFI3sJWzlqsR0xRE4RpmPG7obTE4odL1TrPL3pgEHBTymL /6KSnSlFWZgpMBCv9+gkVceQSbLOsGuKR9o6AS/89S41nbMsJw0G/Fyd/zO7yiWaANXJ f7akhMPruaKj2f/unUjfW0l0BMrmUq1p+G0s28jD7gkMf6Ngqi8itO7Rn0QkUwnG0yND 65shU0AEaRK16su/KyoJGH76tlZVoTgTuNY0p285OkkzvTi7lZufQ5IvQpil0UeGQ/s7 Gnhw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718146485; x=1718751285; 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=BA0O4pFtV5O1BSMlNfeFNDCZ3CTkC0hL0hm4huhI6bo=; b=hljsutDnLDL1jnmK9pYqcBcoyBGSZUqG73K/1sBBk7RhgUht5q57KwNPmMeBcOXUOB K1Gd8NCCPWwQIgVjoPyJtp30w2oGJIEorlNOfjnvWahUmnq2juDs5okMA3R9jFxKbiwL 9/APspehrgyiYZ2DzVSvZMM6XXmUgtiH8gYAQVeb5WczCE3d7GzhF52iFe7p4FUrnDdy CyBM5a6EjrCsb7bvmWwguej6mICo3yVShOEOfllxUTHny99nqX1aL15TQHLQ9/j7hoLa qiQo4vNAUfMSqdOFp8vJL3aNrSp4mysFBP15VvXPZSgz2lZPLXfLVKAjvsjgoOhxEQEp 9v+g== X-Forwarded-Encrypted: i=1; AJvYcCUiIAI7cYBBBHuqpHcLSKwgWZSRCPeUYm2ftlg6YGQN0DqumAK3Z4vr5gbXTS4Pqa1x4WDSfccn/lgOCKpGQvSVC/lhZ0sBxisMkKz+ X-Gm-Message-State: AOJu0YyPH4V4R7MivuGcZ0BmHmjd+sGdE5cCHWsWZXJcd78ZSnIYTuDy BnNvS6caBKtrIrj+eFtv9LBnersgidp5BNnh7YQ0AQEruAfqLnqY2EUjB0ee1olP7MaSWzWarGI 8WB19kAE/d2r4+x2dfBjaoAXgEeHW1Xw0k3efNw== X-Google-Smtp-Source: AGHT+IEgNm9wA1FuxsCmBKKye2nl4+vCNjaZlI9phYjt7xIxV8d7Pf3vebtqkLwCHTPcPhyw/A6fTvu75rO1SWOSxOU= X-Received: by 2002:a17:90a:eb8a:b0:2c2:f47a:97c9 with SMTP id 98e67ed59e1d1-2c4a7606e01mr315135a91.7.1718146484913; Tue, 11 Jun 2024 15:54:44 -0700 (PDT) MIME-Version: 1.0 References: <8c9b9b7d-0868-46d4-963c-8b1906bd7a1b@eisentraut.org> <72f6995a-75a6-4579-9e93-45a80f6bd956@eisentraut.org> In-Reply-To: From: David Christensen Date: Tue, 11 Jun 2024 17:54:34 -0500 Message-ID: Subject: Re: Adding comments to help understand psql hidden queries To: Peter Eisentraut Cc: 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 Thu, Apr 4, 2024 at 11:12=E2=80=AFAM David Christensen wrote: > > On Thu, Apr 4, 2024 at 9:32=E2=80=AFAM Peter Eisentraut wrote: > > > > On 03.04.24 19:16, David Christensen wrote: > > > I removed _() in the output of the query/stars since there'd be no > > > sensible existing translations for the constructed string, which > > > included the query string itself. If we need it for the "QUERY" > > > string, this could be added fairly easily, but the existing piece > > > would have been nonsensical and never used in practice. > > > > "QUERY" is currently translated. Your patch loses that. > > I see; enclosed is v5 which fixes this. > > The effective diff from the last one is: > > - char *label =3D "QUERY"; > + char *label =3D _("QUERY"); > > and > > - label =3D psprintf("QUERY (\\%s)", curcmd); > + label =3D psprintf(_("QUERY (\\%s)"), curcmd); Any further concerns/issues with this patch that I can address to help move it forward? David