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.96) (envelope-from ) id 1wbMkM-002UKt-3D for pgsql-bugs@arkaria.postgresql.org; Sun, 21 Jun 2026 18:18:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbMjM-003fdn-21 for pgsql-bugs@arkaria.postgresql.org; Sun, 21 Jun 2026 18:17:16 +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.96) (envelope-from ) id 1wbMjM-003fdZ-1A for pgsql-bugs@lists.postgresql.org; Sun, 21 Jun 2026 18:17:16 +0000 Received: from mail-yx1-xb12f.google.com ([2607:f8b0:4864:20::b12f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wbMjL-00000001TUV-0Ree for pgsql-bugs@lists.postgresql.org; Sun, 21 Jun 2026 18:17:15 +0000 Received: by mail-yx1-xb12f.google.com with SMTP id 956f58d0204a3-662e7fed068so1607419d50.0 for ; Sun, 21 Jun 2026 11:17:14 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782065834; cv=none; d=google.com; s=arc-20240605; b=g6TKVkoFuB7M8kiIEAQfeaU3RWos2KLpvDgzKpL1ZIlt5G33GtAnq1WxwQ2fzQd7tq W1zsR6isClrKGk3jHhXNcyYcMRYlLFNvMzN1UbyNrHsaWmZ3pL4hbru73fqvQZpF/MYn T0hJeS18EcxxYIaw3RgNtuoU0KfyTY5OF3TXX6gLVWihEj4Y6HGohr6MMjy6Wz/7BHh6 Ww2oxhQKT3gkoiBPYHBuNOf9AtD25S6xhcNXBTpR0CTMkaSsFtZ2BzbgHcvdjPTyqTCc DkW1fn4aLk3LhtKiD31LpfzEp5Ck1q7wvSIJi1KEFSactVzPMkEUeF+Taea1DXPihYzs gO/g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=YtMah/JcTSdnq8K9Rhlme492AGhJh4vA2aMM+Kg8M3A=; fh=4YNXcBON4GlYW9pondfHI3AMMX01WlRiga3bjsc76o0=; b=JY3FUhOPSa610C2lZVJMRD7dcpoYpSpTtIJKBv+afDVOC2zhYL86cM10jcRSZ1QHbZ 8ZhWheY/6r+mKnv1BAyLwvcle41Nubouyk0tMgP1sCiAKS1y+FiAKwag6Up/Lu36X0Xc 9r6itEy0i5wuGH8/oHgguHDWkPBpZgTH51wVXyUj7+xLwEpPcXoyxc0dyuUvdBV95Wd6 HMshRm6V6e5+RKZ7S9XhxDXxXPjuege/BQfWOZQgF6UDxedeev8q/nNtBCTkfOCqpJOU BG6HvzSbMZELJSaoGGb8d3F0F2lOqxZJBQOZMlL/JC70vAEO2zFAG8Jh97jLgiYg3DEI 9c0Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782065834; x=1782670634; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=YtMah/JcTSdnq8K9Rhlme492AGhJh4vA2aMM+Kg8M3A=; b=mjdBgNqclZmjtoKLKfrANpgBuYyv2qvm/o8czJbyOiXZ4dcgEHV8s946No8dmj/si7 GOoNQ2s09yGZcvzRPERjYT2FhsTtAaJLj8s9XQvnSIx91uAwFNEmgncOnwMyrzQHlVfK XkPGv6mz+p95w3XvqoUtqwZ/h8AqNc42ogTC/KMcyYxImY/wtKpgGeL31dIyuGZkdBjC KpwC/HDRaeLn+SjPbpvxLfVv06SXBYTlbrj6+xM/rcBrLrHJdDA0nnbWQHDCIwTR3ma/ K2tyKmKI3okGEQfr8eRHspMO6sXmjvrI547EzKr9LMFXKf8uz+XyPURnYZDqkMuWfIzr gesA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782065834; x=1782670634; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=YtMah/JcTSdnq8K9Rhlme492AGhJh4vA2aMM+Kg8M3A=; b=SlujXiqNimMkDkIFkwwpf1TEY9djLAVaKwPwVd90QfQPDPg2b+9QSrvmd748QKZBay CPKSLW6W0nNyYEs6k7MRGmjEeDgSEU6clm7TAcE3w1u+3VIu9t0oRUmCJU72vLqulHSN ScLNd5Ry5w1hwaqJdgPj6zMJW0diJAtL5qxcvWEBLdVQ3irRKfenLXM4pxcxTYOsF899 0BLUCWOiKL9rqVaSU242Boh7J88+UMfec/6z9PRWhc1TT05dFO1DYnakCNu8gzBr8xtK 33fRkH/AYF+OH39SbuHe+eMwQDaxtYcS+uA+K0nVfnjtNUra4DrYkBYwhMOryysMgth3 zMfA== X-Gm-Message-State: AOJu0Yxe0STM2dBrby0hZg18eS1O7OjDHmPxGlpQS86nSywUovQ/bdfV w2nqhmKgkwc9W+yPEi7NaN2B+U9DX5r4h3DMVxl/37y8EKATBpr7pW4LrGHQY6LOMq24MXSbrip WFKBysdv4uOKlJ3paK8xSz/BlqI8urTI= X-Gm-Gg: AfdE7cnUJX09BJYGB/JybNU8bRGHYX/0Tkan2Rky8cAn7HCmnSU13jmQfb4Jn/A5lPx kpHIGoADfxP4ACyrgWiIczrw76CFIM1kOJZscBpD20CkHzROwMQw+6qYcS+IVhRDohYJKCnwL/u staM/mP23GSIy+plLoemm4zmwOJ42SSvc1eZbngpzpbGHoVneDJnXBzsfBouhSNxVrCLs3ySTIf WzTKfgs8KTuAzlXxNBNlC8oILkmr1s9x5B3BxRqw47osh5uFohJf6Rvnc9xWMRoL3hlALgruP+n oZcir/Z7XJa3eWToIi2Jqa2IoLoZ X-Received: by 2002:a05:690e:1916:b0:662:db62:14da with SMTP id 956f58d0204a3-6630308b6b6mr8789553d50.17.1782065833984; Sun, 21 Jun 2026 11:17:13 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:7010:9c99:b0:52d:fc31:d5ac with HTTP; Sun, 21 Jun 2026 11:17:13 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Sun, 21 Jun 2026 11:17:13 -0700 X-Gm-Features: AVVi8CcI7VPHOy_RBMvWX99bY0spKBH5l8eioSlOTJ4PmWlWOIeCI1f3gM9wg18 Message-ID: Subject: Re: psql variable substitution in plpgsql loop To: carl clemens Cc: "pgsql-bugs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000044e10654c78908" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000044e10654c78908 Content-Type: text/plain; charset="UTF-8" On Sunday, June 21, 2026, carl clemens wrote: > > psql fails to populate a table in variable substitution. > the variable being within a plpgsql "goto" loop looks suspicious > psql will not modify string literals when performing variable substitution. David J. --0000000000000044e10654c78908 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sunday, June 21, 2026, carl clemens <cclemens968@gmail.com> wrote:
psql fails to populate a table in variable s= ubstitution.
the variable being within a plpgsql "goto" loop l= ooks=C2=A0suspicious=C2=A0

psql will not modify string literals when performing variable substitutio= n.

David J.

--0000000000000044e10654c78908--