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 1uMxMI-008BEI-12 for pgsql-general@arkaria.postgresql.org; Wed, 04 Jun 2025 23:17:22 +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 1uMxMD-000iDy-LX for pgsql-general@arkaria.postgresql.org; Wed, 04 Jun 2025 23:17:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uMxMD-000iDq-98 for pgsql-general@lists.postgresql.org; Wed, 04 Jun 2025 23:17:17 +0000 Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uMxMB-000G2T-2y for pgsql-general@postgresql.org; Wed, 04 Jun 2025 23:17:17 +0000 Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-2da73158006so329735fac.0 for ; Wed, 04 Jun 2025 16:17:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749079033; x=1749683833; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=JsDbcXCI2ipjOFKKUP5Kprszod32Alv5oIqRUXW3Qxg=; b=LsKrDrdzfrWg+0fbYUMYZKj15caiaRMLs5MX+y/3g8mF5Ly/7+42yHGRRpARC4mO7h 6NbMtGjtSNu7o4H1tV1+YGVSBnjKIORW7Hm3E/a5Agxhk6sTN3JDaKhM5Iev7xuk4mfM 42BknXAV9HC4NZYJWnMnYNHP2bon/GeBNRo2L/ycrKHWQAxX4IkXLTavXsntcO0BCXdV n979IqjItMqEgdafK71J3NbYyxk7ESAAm77Jaze6NCRpOEatmOb5kqqlUMzkYBh4Odig skkDCkScLlMEHMFrlR/g72Lc3MO59JL9KykmXMBovKjOaB+/NB3IC2HKM7lVCsuSk8KI 3sLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749079033; x=1749683833; h=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=JsDbcXCI2ipjOFKKUP5Kprszod32Alv5oIqRUXW3Qxg=; b=cNETHTrTUTe5k+N0MPchpOaMzyiarB1dymLxdXXN0lOsov91wJWae/Hm/VGSEgRs5s 9iOnLJL/c86Rm2HRkyZk99GhYc+4NBdLZ6xPbSJO1qxscB46LXSuyYgpjov1OlE/Hf/r HT1Olu4O4SunR90NQROOuT0JDxhXaM5mYUVw1c7o0YwyMeaiuHSMqx/Pj5hNeDDBC7SX rjtXs8RbYq5llrM9S+vzgFSDsoOHK6DURIR5v0xOaFW7BINW8hZbxFRoYJAEbnPh/Y4R hDOsIdqjwhZxrE0GYr2ZaoWEZDa7Vbt6i69CWsUPZ0aOD5YqIaNitc7ImET23zW0ANmR EoQA== X-Forwarded-Encrypted: i=1; AJvYcCWNzS1OFlzawvEIrdR83w9FJjBY9LRNEb0Hq7EuH0oAMhd9sr0Te0e8jah3fKmqCoLhD+Uz5MD6ar0Bdx2/@postgresql.org X-Gm-Message-State: AOJu0YyPSH19nyLmpFvo1OUofjc0a1FnPykkvxZncovxcyY+0np8kHyy hx6JkxLRRPSzO3n5dabke+wmJsUI77rlyIGYUL2VpvAo6g04EtwvvnV/XO7P139AnK5QVQYK4wT jjd4xvWh6Jt3NA2Q0INuP8abz+UGIPww= X-Gm-Gg: ASbGncv45l06pwPCQUs127X0YODsaLgbTubsvoKdeOrkan/dyAIkq+VD0jexu+tCvbJ SNGdWFcMm3mUSoxNlfIii4LY0KVAv3DIY891wUSD4Iq/cBe3I4ME+P04OT8uNQ787tuLsxY6pSo cx9C40u7/1EkFoA19865YLhsM1Fl4FmHdCyeWGLm53USxv X-Google-Smtp-Source: AGHT+IGBcbDC1r2C4Mgp5Bo51qoTUSSAfRZbq1AGPmG+9oq6p0gMevNM6+0RZtb8DpMjY8uo2PGhv0zMUFChoDKIBzM= X-Received: by 2002:a05:6870:530d:b0:2d5:b914:fe2d with SMTP id 586e51a60fabf-2e9bf52fafbmr3516862fac.33.1749079033074; Wed, 04 Jun 2025 16:17:13 -0700 (PDT) MIME-Version: 1.0 References: <5ad6900d-dab4-4c90-a156-40237717902c@aklaver.com> <5ef7f055-61bd-45da-9483-2f95eca25b64@aklaver.com> In-Reply-To: <5ef7f055-61bd-45da-9483-2f95eca25b64@aklaver.com> From: Ron Johnson Date: Wed, 4 Jun 2025 19:17:02 -0400 X-Gm-Features: AX0GCFvrmW2dx4g8M3LQvJD8x58tiSpvwwbBdlCYpa0hc64RcVaTsYMBO7MNmDo Message-ID: Subject: Re: Yet more ROLE changes in v18 beta1??? To: Adrian Klaver Cc: Dominique Devienne , pgsql-general@postgresql.org, robertmhaas@gmail.com Content-Type: multipart/alternative; boundary="0000000000007359ad0636c73215" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007359ad0636c73215 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jun 4, 2025 at 1:53=E2=80=AFPM Adrian Klaver wrote: > > > On 6/4/25 9:39 AM, Dominique Devienne wrote: > > On Wed, Jun 4, 2025 at 5:29=E2=80=AFPM Adrian Klaver > wrote: > >>> $ ./myruntests.csh tests_pdgm_schemas -t "..." --pq-version > >>> Connected to ... (17.4, server 18.0) > >> > >> What is '(17.4, server 18.0)' referring to? > >> > >> What is the actual test being run below? > > > > 17.4 is the client-side version, i.e. the LibPQ used. > > server 18.0 is the server version we're connected to. > > What happens if you use the 18 version of libpq? > Shouldn't the client version only matter for the SQL generated by psql meta-commands? (Because what meta-commands drop roles?) --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000007359ad0636c73215 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jun 4, 2025 at 1:53=E2=80=AFPM Ad= rian Klaver <adrian.klaver@= aklaver.com> wrote:


On 6/4/25 9:39 AM, Dominique Devienne wrote:
> On Wed, Jun 4, 2025 at 5:29=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.com= > wrote:
>>> $ ./myruntests.csh tests_pdgm_schemas -t "..." --pq-= version
>>> Connected to ... (17.4, server 18.0)
>>
>> What is '(17.4, server 18.0)' referring to?
>>
>> What is the actual test being run below?
>
> 17.4 is the client-side version, i.e. the LibPQ used.
> server 18.0 is the server version we're connected to.

What happens if you use the 18 version of libpq?
=C2= =A0
Shouldn't the client version only matter for the SQL gene= rated by psql meta-commands?=C2=A0 (Because what meta-commands drop roles?)=

--
Death to &= lt;Redacted>, and butter sauce.
Don't boil me, I'm still ali= ve.
<Redacted> lobster!
--0000000000007359ad0636c73215--