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 1vBrUO-00668B-Az for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Oct 2025 09:20:07 +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 1vBrUL-007WXc-D0 for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Oct 2025 09:20:04 +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 1vBrUL-007WXT-2Z for pgsql-hackers@lists.postgresql.org; Thu, 23 Oct 2025 09:20:04 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vBrUH-003Jv0-2O for pgsql-hackers@postgresql.org; Thu, 23 Oct 2025 09:20:02 +0000 Received: by mail-lf1-x133.google.com with SMTP id 2adb3069b0e04-57a960fe78fso827958e87.2 for ; Thu, 23 Oct 2025 02:20:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1761211200; x=1761816000; 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=m5pnypa6Pde1WFQdi9cnGjHIGy8PXmkUGxGN/3CPYIc=; b=I1jK8wtFjqCfIo0uCLKl3VG8aLVc3c8b3fAbPmE4QUgijlmL5tFkCXN77W1EVS1Gvo w11FoaKQvEsxR22PtjDSILylw3m1nAzmhRtoTvQua1T1NG3c0rdOOAc1Rx6GKX8Pq4tP fAv+YpU1Hgz+E3dx1BCifM3r/+8bqeojMkKD557oUsEr8LRUwLUhXze2M0uEWs/neqd1 UYOlwt4VRR3ppDmnq3KL75yqzdX3KTp0QKLC77qJ2UyFzqv58qggLQJG9M3qwfuCkKD8 QGnlz4d9BaU+I3PSiwOLWxV96kNMZBnOT+L6VzUbQV/zD+0cC0+lXmEJsaMsLY6q3LDt zE+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761211200; x=1761816000; 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=m5pnypa6Pde1WFQdi9cnGjHIGy8PXmkUGxGN/3CPYIc=; b=FyXFtrwTeGJTp3uMs0D9IG3WfjaprA3v6ZSFfGe8f7MAdPd6hjh8bz5JtED4RYLYtZ n0ivLWitFWck6YAiGTG5EABxBkTbiYF12fvV0Mg7cK2aMJ6XcnrAB18rpzK9BmJXSicM VqgXuYOMbSIARQ4k5UqUwn1hb5Fzp3/XoFjIa/1kk+4HVEOAVoW7zpBhW/K/HWmcjAxX d9T9bIOYu+yPdy6cuLWBGrGPz2bCaE4/qVjBIMxx9Ptjj196/CffOWtYbhEHbALCctD8 5cGaalZmShLzsCT1S8AWRkkpgaE9oW50e5VKKfifCffn467VT5/tnuWWixdSjpVVsP49 26dg== X-Forwarded-Encrypted: i=1; AJvYcCUhLPqN7S8wRyxEEUocWVqneq12xFwtMKknx2NabqLmtt8IOlBVBz6HMO8Z6CpPwKJ3BwzIkX+CPgulNKWA@postgresql.org X-Gm-Message-State: AOJu0YwaXlWV3pqiDjQDBncYcWM5VutNMXVVLR8BI2KCu2Hf1Fy/ySdS YcmnRfMOQxqVpi9lZQNlHie5xG4lIF42DonI22VWpKfIQnHPekk0jECa2136dSAyrf5+UV4LSc2 aKvc/FB4sZ9nIaqehtKdWc7oFzmEJgwD3L/rDixoq X-Gm-Gg: ASbGncvAZdAXLWrU6oGcqK+SbEyHc1i0rPazWPjCHs9OCxMFDc0WPgEKK+rUss00L3V IOVziGRmkpO7U81s3S+HwSJtU1JMS4LTioowB3prTkZfB53ZCkHNr5H7Vtn+yFW8b60gdlqhWD/ e5spcp4J6EpgVCuT/FWW2GJ+42iWileMNuwmt13qIucEW1y86lfY+rkGWjvZ/FEIom4fNzTSye2 Acak2ddoub4LozFotsncxu9C5m9Oyzm0mh/s9m7UtoFdmelkTXWOUvcaWtAwTRMxmQPnXtR3n5G vWwElBonOjNipvsFQkBSvH68DVBr X-Google-Smtp-Source: AGHT+IEuCnm8yr32VZ4GMeWEqj5M1cYBAWmShgmHjjGKQnMFSuY8ph4ug4MnKNIyF7mE6xeTDplwifoT9jD7GBCxsRM= X-Received: by 2002:a05:6512:e8e:b0:591:c862:2b2e with SMTP id 2adb3069b0e04-591d85838bemr7773310e87.45.1761211199756; Thu, 23 Oct 2025 02:19:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Thu, 23 Oct 2025 14:49:48 +0530 X-Gm-Features: AWmQ_blM5053aIswbiRd-3pcZ7GWVzH_dyt5pFT7F_JrH7X1BzsUAbkkSDAhy2A Message-ID: Subject: Re: [PATCH] pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement To: Tim Waizenegger Cc: Chao Li , pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000efb78d0641cfefef" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000efb78d0641cfefef Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, 22 Oct, 2025, 17:30 Tim Waizenegger, < tim.waizenegger@enterprisedb.com> wrote: > On Wed, Oct 22, 2025 at 12:27=E2=80=AFPM Chao Li = wrote: > > > > Hi Tim, > > > > Thanks for working on this. I haven=E2=80=99t finished reviewing the en= tire > patch. But I got a quick question: > > > > While reviewing a similar patch of pg_get_policy_ddl(), it take the las= t > parameter as a pretty flag. I wonder why pg_get_domain_ddl() doesn=E2=80= =99t > support an argument for pretty? > > > > > > That's a good point; we'll add pretty printing support for consistency > with the other functions. I'll send a new patch in the coming days. > I've already implemented a generic function for pretty-formatted DDL in the ruleutils.c file as part of my pg_get_policy_ddl patch. I suggest reusing it once my patch is accepted and committed by the community. > > Best regards, > Florin Irion > Tim Waizenegger > EDB (EnterpriseDB) > > > --000000000000efb78d0641cfefef Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Wed, 22 Oct, 2025, 17:30 Tim = Waizenegger, <tim.wa= izenegger@enterprisedb.com> wrote:
On Wed, Oct 22, 2025 at 12:27=E2=80=AFPM Chao Li <li.evan.cha= o@gmail.com> wrote:
>
> Hi Tim,
>
> Thanks for working on this. I haven=E2=80=99t finished reviewing the e= ntire patch. But I got a quick question:
>
> While reviewing a similar patch of pg_get_policy_ddl(), it take the la= st parameter as a pretty flag. I wonder why pg_get_domain_ddl() doesn=E2=80= =99t support an argument for pretty?
>
>

That's a good point; we'll add pretty printing support for consiste= ncy
with the other functions. I'll send a new patch in the coming days.
=

I= 9;ve already implemented a generic function for pretty-formatted DDL in the= =C2=A0ruleutils.c file as part of my=C2=A0pg_get_policy_= ddl patch.=C2=A0I suggest reusing it once my patch is accepted and c= ommitted by the community.

Best regards,
Florin Irion
Tim Waizenegger
EDB (EnterpriseDB)


--000000000000efb78d0641cfefef--