Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pHFvo-0005KM-LV for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Jan 2023 03:13:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pHFvn-0002G8-Fj for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Jan 2023 03:13:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pHFvn-0002Fz-4j for pgsql-hackers@lists.postgresql.org; Mon, 16 Jan 2023 03:13:07 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pHFvk-0002XE-Ml for pgsql-hackers@lists.postgresql.org; Mon, 16 Jan 2023 03:13:06 +0000 Received: by mail-oi1-x235.google.com with SMTP id n8so22357401oih.0 for ; Sun, 15 Jan 2023 19:13:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; 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=QZsnEi/587z1K+qhmRToIvECOEeATrKOHVmV3Kgtj1E=; b=FE2/PVri+BlyucCAuOylNzYTnx6x2v7Zqnp90aD9/sLMmDCK3GBy1q1VViozvBxMEQ xd6kHnxGkikLhOjE20J3ADOVWoFW/tlKFcsHxGrrRgf1SH4H5iaX4DdEvl+h63cZTivS mtwvux4iMxXWpU+Uwyj0wkioVzKeedLKjjH2EXvvFF6xLd3/8uszMSOaO4byqFhQzr9Q GUMR5FLXFGNStaDWI5DRLJWQJOVVWnw4wYxa5vZn55sYF8IWV6Kniuzl/JoBiEbMcZTs qb6SnA8OkW/T0H8pWmwXru7T65DPPp7FbnobnnbdlAaEVgvVlIA0whrqdDUsArpYEJpX gvig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; 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=QZsnEi/587z1K+qhmRToIvECOEeATrKOHVmV3Kgtj1E=; b=7J9TXUQ9GTcAn9jLlKf6Z00rBjmOmlMGmG7M7FFfldD+aNMveNk6M5J1lfU5JJWy2v kZazA9EhD2LFHf/Yls1aSPsTABndRFSrhmuwAdhEFNW+O5f4Y8uPMu61cN8sgtnMxh+E 2Faf/LBjpFdjkCNtBkXjXeMDK457lp5tL2OP+TurBz3DZ2nD4N7IAWqRw75x3hOqai/a 4v+ugbC6niG4EFZr0rZEWtaMX5QPWBMy3NYIF9iUV7UOzK6ZpGcIBPNWItTFlv2YHO03 MzKv+IB0BFI/yG5o/Y7e4sYTxTtDRz8xXQdsrbwmO3QLCGsR2foH7L7xQsHNfEnCcRvU kC0Q== X-Gm-Message-State: AFqh2kqdarBvSoUOMuK6QVlXeoBSNc4rP6nQJDG0cf/PvX4TO/Dzkncc EXUoszKEGOEUTwt0jKX3r5CoFYITS0uRtTsYruw= X-Google-Smtp-Source: AMrXdXtGsnvUmuVGWhIEob8Z+Ns4teZV9aTGEtSmWk2wdVQB505TfeAixBQeu7Pcje0TFI6MhRTf7bfw3xzlxwlIptc= X-Received: by 2002:a05:6808:6245:b0:364:5ba9:9f77 with SMTP id dt5-20020a056808624500b003645ba99f77mr1352943oib.38.1673838783892; Sun, 15 Jan 2023 19:13:03 -0800 (PST) MIME-Version: 1.0 References: <20221006171601.6um4ey5idm4h62vf@alvherre.pgsql> In-Reply-To: From: vignesh C Date: Mon, 16 Jan 2023 08:42:52 +0530 Message-ID: Subject: Re: Support logical replication of DDLs To: Ajin Cherian Cc: Zheng Li , Peter Smith , li jie , Dilip Kumar , Alvaro Herrera , "houzj.fnst@fujitsu.com" , Amit Kapila , Masahiko Sawada , Japin Li , rajesh singarapu , PostgreSQL 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 Sun, 15 Jan 2023 at 09:39, Ajin Cherian wrote: > > On Fri, Jan 13, 2023 at 5:33 PM vignesh C wrote: > > Adding support for CREATE/ALTER/DROP Publication ddl deparsing. > > The attached v61 patch has the changes for the same. > > > > Hi Vignesh, > this doesn't seem to compile: > > gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointer-arith > -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels > -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing > -fwrapv -fexcess-precision=3Dstandard -g -ggdb -Og -g3 > -fno-omit-frame-pointer -I../../../src/include -D_GNU_SOURCE -c -o > ddl_deparse.o ddl_deparse.c > ddl_deparse.c: In function =E2=80=98deparse_PublicationObjects=E2=80=99: > ddl_deparse.c:8956:3: error: unknown type name =E2=80=98publication_rel= =E2=80=99 > publication_rel *pub_rel =3D (publication_rel *) lfirst(lc1); > ^ > ddl_deparse.c:8956:31: error: =E2=80=98publication_rel=E2=80=99 undeclare= d (first use > in this function) > publication_rel *pub_rel =3D (publication_rel *) lfirst(lc1); > ^ > ddl_deparse.c:8956:31: note: each undeclared identifier is reported > only once for each function it appears in > ddl_deparse.c:8956:48: error: expected expression before =E2=80=98)=E2=80= =99 token > publication_rel *pub_rel =3D (publication_rel *) lfirst(lc1); I was able to apply all the patches and compile successfully, also cfbot as in [1] has compiled successfully. One thing I noticed is that structure is available at 006 patch, if you did not apply all the patch it might fail, we will take care of structure movement in the next version. [1] - https://cirrus-ci.com/task/5231672585617408 Regards, Vignesh