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 1nrrKJ-00008E-7h for pgsql-hackers@arkaria.postgresql.org; Fri, 20 May 2022 01:21:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nrrKG-0002Df-Ic for pgsql-hackers@arkaria.postgresql.org; Fri, 20 May 2022 01:21:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nrrKG-0002Cm-6m for pgsql-hackers@lists.postgresql.org; Fri, 20 May 2022 01:21:08 +0000 Received: from mail-qk1-x733.google.com ([2607:f8b0:4864:20::733]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nrrKD-0007rI-6B for pgsql-hackers@lists.postgresql.org; Fri, 20 May 2022 01:21:07 +0000 Received: by mail-qk1-x733.google.com with SMTP id v11so6030182qkf.1 for ; Thu, 19 May 2022 18:21:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=OnA5iSgRu81qXln9UJ6OWsDbtI+Lheb31sQAh7Q5xXE=; b=QyoJKndVS8KcwJjpR80YrGGexHiSVVqENU8BX7zJl5g1OnMT3H46nqYRzXjN27Ro8M 2L4NhKmsD1CW4OY87fUnYU4Gt/7fpLZ0/GufAwL6EOjVbHmz908nlZhYidE+p9p6S45P Uf1DVGCiIYnuo0PWC+dN+9YMXgmMdNd5sr4Bw9QtbFP9kNQVQslk1vgqmcB77c5fzrdu nJ2jhKVoGBaYXuKV5qqONDBPuMVNERx27Dz0HVtysgYlXTd39GMuSjQpLmctgDBSStnV z5L1X32NWIqOVMAbfi5HgxUe890338U46Ru0NWxpjtXz9GJ1gGNL6QRnWBfcpkpsyINb KNDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=OnA5iSgRu81qXln9UJ6OWsDbtI+Lheb31sQAh7Q5xXE=; b=MCYOkRppH+Alw5K0q6TEc6McI2z03gzTHJQH1cOYIJg3ZuF2EEqzKoybnqi6dP9OUr bhCozXVDtR+I2zoLheZpCF9fM4o11fxJS183VVqWD04tdZhmitx5tgZXJPRjhTQus9h7 DUf8ViYTg3eMV2+gVT1SFjL3wbr2V/kBQMmwNvl/MCAGbrTqVv0H2yy3EUuAPH1bulbD R5sebmzeb72dQj7m8Yipeiw9nq4Z22VgrcZ3SrBAlys+UigUBVM1CiswsZFri0hV4gbq wsm8FxaEs0CG26JLyCjyUWN9scS+0Y/cHNi7Z44YApmm9iVwWvS1l3jcacWAviWfQXDI F7nA== X-Gm-Message-State: AOAM5305Rz4QEf0ypGxuyVTejVvQv0yuwVNTVFdq0Ag8luPI9YGHn4ZU l90dRhi7o/yINJNtmObvDnbYd3WqPL9G01nqBQc= X-Google-Smtp-Source: ABdhPJxRAFQOQOQ/3Tfy87Im8F7yVHq/dGZbYLiI6GKW302e8TpV1Gz16s4Z3Iw5rQQWT3i5roPcupwd3i2A9wTV/Jk= X-Received: by 2002:a05:620a:84b:b0:6a3:4895:d272 with SMTP id u11-20020a05620a084b00b006a34895d272mr2042333qku.338.1653009663226; Thu, 19 May 2022 18:21:03 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Peter Smith Date: Fri, 20 May 2022 11:20:47 +1000 Message-ID: Subject: Re: Skipping schema changes in publication To: vignesh C Cc: "osumi.takamichi@fujitsu.com" , Amit Kapila , Bharath Rupireddy , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, May 20, 2022 at 10:19 AM Peter Smith wrote: > > FYI, although the v6-0002 patch applied cleanly, I found that the SGML > was malformed and so the pg docs build fails. > > ~~~ > e.g. > > [postgres@CentOS7-x64 sgml]$ make STYLE=website html > { \ > echo ""; \ > echo ""; \ > } > version.sgml > '/usr/bin/perl' ./mk_feature_tables.pl YES > ../../../src/backend/catalog/sql_feature_packages.txt > ../../../src/backend/catalog/sql_features.txt > > features-supported.sgml > '/usr/bin/perl' ./mk_feature_tables.pl NO > ../../../src/backend/catalog/sql_feature_packages.txt > ../../../src/backend/catalog/sql_features.txt > > features-unsupported.sgml > '/usr/bin/perl' ./generate-errcodes-table.pl > ../../../src/backend/utils/errcodes.txt > errcodes-table.sgml > '/usr/bin/perl' ./generate-keywords-table.pl . > keywords-table.sgml > /usr/bin/xmllint --path . --noout --valid postgres.sgml > ref/create_publication.sgml:171: parser error : Opening and ending tag > mismatch: varlistentry line 166 and listitem > > ^ > ref/create_publication.sgml:172: parser error : Opening and ending tag > mismatch: variablelist line 60 and varlistentry > > ^ > ref/create_publication.sgml:226: parser error : Opening and ending tag > mismatch: refsect1 line 57 and variablelist > > ^ > ... > > I will work around it locally, but for future patches please check the > SGML builds ok before posting. FYI, I rewrote the bad SGML fragment like this: EXCEPT TABLE This clause specifies a list of tables to exclude from the publication. It can only be used with FOR ALL TABLES. ------ Kind Regards, Peter Smith. Fujitsu Australia