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 1v9JBe-00FCeo-Sd for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Oct 2025 08:18:14 +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 1v9JBd-00AhDc-9M for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Oct 2025 08:18:12 +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 1v9JBc-00AhD8-VK for pgsql-hackers@lists.postgresql.org; Thu, 16 Oct 2025 08:18:12 +0000 Received: from mail-lf1-x12a.google.com ([2a00:1450:4864:20::12a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v9JBY-0023XF-2F for pgsql-hackers@postgresql.org; Thu, 16 Oct 2025 08:18:10 +0000 Received: by mail-lf1-x12a.google.com with SMTP id 2adb3069b0e04-57e36125e8aso446941e87.2 for ; Thu, 16 Oct 2025 01:18:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1760602685; x=1761207485; 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=eYlFQm+GgcAz/yiIuVPyS0GiqBHgM1KtnBJTPhiCB38=; b=XKGKueKdpttb8Dxx+Wf79xolSP0Qr7YCMkUW09NQeSVz5stx0vIhC2/CwXSE0NS2e5 krqGBwYdDN+8tBaodel78fFxDRDVMJIzZBIm+ksPwUOnywReSF6VMf6q5sXoBGVYP5Qc 2zyG+j1T43+fWv0ukl2HELUpklKgYqJLdLq0l6mq8lMMKlP38Psokk6uMBme/lc8FNNQ hp9N1REWMH39IKlLO/DOZduJFskWA1x/OhTgK1Gtf4cuRE/8sz3s2B/3NL/RUrjPm6gP dpsLPevgRy7bJACp80yVrykz1It9hL2E8ILnGihxAluem4Sup5B0uMKbDCqduMMcooK1 GTlQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760602685; x=1761207485; 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=eYlFQm+GgcAz/yiIuVPyS0GiqBHgM1KtnBJTPhiCB38=; b=Eus2AckuLHuhnGU/uYxXQflF7orKa+Y+ZmimprOA4QPc6O39EJIWqwhXflz1QGGdlj MqwP8dfMR9eUHf2ehUmS45LR+ycXur3axnlcu9zqm2Rc0qn0uncgYVslQgx7RW19brTu RNUluvk23ZmyXydHoyhfbNFCW9m86XZ3Ri6xIN51s3Tc90yMV2zlWDazACi2RVbzNuuo Od8qGy3DbcsL+M3Kt0Q3M9udQ/7B17k6CBWWxAVzfpGg4BY86q3SDGHIeiKPtV8gBoLV sGvWELRo/HKAo0TX5krVOkmL3gMnpNL2i5x6as1lIDxQ8fBKxMSo8MwPm5SvY1b+F+jw c2xg== X-Gm-Message-State: AOJu0YwWWKMcF3vcVLBGr9NU9tiVNzmIU+CKW9J5o6i89VWA8Aw9iCap 2G7jWWVWmkhN9m5lqu+O1+kzPp7ZLiX5sBXq9NAt4Z1GYQIFEexK1eNg4PRaEpj6UQJLznp58ps 1BkDVKRVRK7cgAk7Nl8ilw7oRd9GWEn2xbDr4KC9hFvMpI7s0Finx+i3o X-Gm-Gg: ASbGnctLvVB4iW7lqN0zOafJrPrSu28ckj9fyHvJt+Oh0tOMpz4/WsLuDS044wNZdtc hNIu4bh8XHUm5T0UIswXgefFB2mCQWn9nMsMzzfj+cdz2P1HaCQqPuNBu1NjR6swSo4YSTJplEk MFdd+93btJ8ctydF6EbMCLbmZnZz5mfI6JSvrbwlLa/OhxEtwGh/O8new3pCl3VfqeG9x66T4S/ +nbC6dhOjIzTO2mLJ5zOzWn/ihmPGNTZK90K98runraJzbAI0pZTnme3V0WMUoEg+Jfa/IGyg== X-Google-Smtp-Source: AGHT+IHw30+69PGFKBrKE0cjwQOMWpNJORwWm7WRI8OWVUhRePvkzPZDpXa/ymw8F4Gr7n1LIMtCzX2poypDKlHhe1Y= X-Received: by 2002:a05:6512:2251:b0:55f:4ac2:a595 with SMTP id 2adb3069b0e04-5906dc0e664mr9879767e87.16.1760602685099; Thu, 16 Oct 2025 01:18:05 -0700 (PDT) MIME-Version: 1.0 References: <202510151529.s3fpwsgben57@alvherre.pgsql> In-Reply-To: <202510151529.s3fpwsgben57@alvherre.pgsql> From: Akshay Joshi Date: Thu, 16 Oct 2025 13:47:53 +0530 X-Gm-Features: AS18NWBz0JI34LigJrORCwIeLYM6dRRSDfGwKMJF85fRuF2hBlD5PIv6Zcyuco0 Message-ID: Subject: Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000a2e2830641424187" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a2e2830641424187 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Oct 15, 2025 at 10:55=E2=80=AFPM =C3=81lvaro Herrera wrote: > Hello, > > I have reviewed this patch before and provided a number of comments that > have been addressed by Akshay (so I encourage you to list my name and > this address in a Reviewed-by trailer line in the commit message). One > thing I had not noticed is that while this function has a "pretty" flag, > it doesn't use it to pass anything to pg_get_expr_worker()'s prettyFlags > argument, and I think it should -- probably just > > prettyFlags =3D GET_PRETTY_FLAGS(pretty); > > same as pg_get_querydef() does. > Fixed and added 'Reviewed-by:' > > Thanks > > -- > =C3=81lvaro Herrera PostgreSQL Developer =E2=80=94 > https://www.EnterpriseDB.com/ > --000000000000a2e2830641424187 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Wed, Oct 15,= 2025 at 10:55=E2=80=AFPM =C3=81lvaro Herrera <alvherre@kurilemu.de> wrote:
Hello,

I have reviewed this patch before and provided a number of comments that have been addressed by Akshay (so I encourage you to list my name and
this address in a Reviewed-by trailer line in the commit message).=C2=A0 On= e
thing I had not noticed is that while this function has a "pretty"= ; flag,
it doesn't use it to pass anything to pg_get_expr_worker()'s pretty= Flags
argument, and I think it should -- probably just

=C2=A0 prettyFlags =3D GET_PRETTY_FLAGS(pretty);

same as pg_get_querydef() does.

=C2=A0 =C2=A0Fixed= and added 'Reviewed-by:'=C2=A0 =C2=A0

Thanks

--
=C3=81lvaro Herrera=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0PostgreSQL Developer= =C2=A0 =E2=80=94=C2=A0 https://www.EnterpriseDB.com/
--000000000000a2e2830641424187--