Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1exwDX-00015a-95 for pgsql-docs@arkaria.postgresql.org; Mon, 19 Mar 2018 14:56:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1exwDV-00033B-Do for pgsql-docs@arkaria.postgresql.org; Mon, 19 Mar 2018 14:56:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1exulb-0003tv-VV for pgsql-docs@lists.postgresql.org; Mon, 19 Mar 2018 13:24:00 +0000 Received: from mail-oi0-x241.google.com ([2607:f8b0:4003:c06::241]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1exulX-000682-Vh for pgsql-docs@postgresql.org; Mon, 19 Mar 2018 13:23:59 +0000 Received: by mail-oi0-x241.google.com with SMTP id t16so888568oih.3 for ; Mon, 19 Mar 2018 06:23:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=9ilX9OFL4Uh/ONielQzQhbhGIhYAV9GH7dISXHh0b4U=; b=mgcpxJ74VDP2XmJgE5Nj0H2hPDsit8vTvDVIqhtgYYqfKQMY1KnJjl/jKUeEQCoN3S tNHMdNz9whEpikOuF17sMp3J6hTlx8ZQuh3lf+rAAdgApC7LR8LmjLSJGMTUoecXhOnQ GSfHLzdTi1eOAdiQ/NpR4aqAlClGPhi8xFQso0h+IrUh9tl5h8UtUD77HXfzTqg+ieD0 sEXLDvrOgb2y5ZK6f/qOrHzbggnh/MgiVIu2itCppkxB5VwCeQkOWgJ3apoI8reHZUCf wnhRo2oSvC0Xm78FI9DG159+mpy/FiOis5nlDawfqBKGRqms9Wfs+3oFrq/geUVJyKUA h4Eg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=9ilX9OFL4Uh/ONielQzQhbhGIhYAV9GH7dISXHh0b4U=; b=GqOsY28HxAIJAXYaSn+PGlcgYT7VGNKk14499c/WRx4Z3KjDXA2unHcLhfjFXfV+jU /G9B1VyEaxNqMmuv1T0uW4sgxEGo0jBtb4g+Hh4wyonTSn1GSXZXzRRxSwB/70AkKNqM My/eWuMU0fYwu5Be2mhiJaTyLoyDrjlUGiybQ0z18UspdVfhSYdgwHr2GLdUKQgIavYT 17UWOn5sbJ8+o4cf6cGDTmSRGiXIZP1nNfhL1p0QbQTwaNQKUJw0bMrL9M+fU1hmDFPe 31ZbM/q1H6DmNNGHhi5o5yq91f6Zk+aTNgiNNsjbH8ptwQx4GtLwx8tN+XI49WcIkJ2r C9yw== X-Gm-Message-State: AElRT7GfU4qThw90XIGYoyudaX2oYROm1FCr8arAa2KtRXEf7jsZEQMP WD4E73HThbPgWd97naB7mvOqHlii5bcEn5XogETD30he X-Google-Smtp-Source: AG47ELuEDtQOhQJejSOa0qWXBxh8pTn7yET/3X1L0tPnBkXxHtzlC3Y71eD9r5lc2XSTD+CA6/Rzhd5u1OMbkAohQqE= X-Received: by 10.202.51.138 with SMTP id z132mr7437868oiz.67.1521465833277; Mon, 19 Mar 2018 06:23:53 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a9d:70d9:0:0:0:0:0 with HTTP; Mon, 19 Mar 2018 06:23:32 -0700 (PDT) From: Brian Faherty Date: Mon, 19 Mar 2018 09:23:32 -0400 Message-ID: Subject: create publication descendant tables To: pgsql-docs@postgresql.org Content-Type: multipart/alternative; boundary="001a113cdcd887cc3d0567c3de81" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --001a113cdcd887cc3d0567c3de81 Content-Type: text/plain; charset="UTF-8" I was looking at the `CREATE PUBLICATION FOR TABLE table *;` and I ended up with a few questions. 1.) Can '*' ever be used since it includes the parent table along with the child which then results in a error being thrown about parent tables not being able to be replicated? 2.) Will it only work on current descendants or will it also work on future descendants? For quick reference: https://www.postgresql.org/docs/10/static/sql-createpublication.html -- Brian Faherty --001a113cdcd887cc3d0567c3de81 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I was looking at the `CREATE PUBLICATION FOR TABLE ta= ble *;` and I ended up with a few questions.

1.) C= an '*' ever be used since it includes the parent table along with t= he child which then results in a error being thrown about parent tables not= being able to be replicated?
2.) Will it only work on current de= scendants or will it also work on future descendants?

<= div>For quick reference: https://www.postgresql.org/docs/10/static/sq= l-createpublication.html

--
Brian Faherty
--001a113cdcd887cc3d0567c3de81--