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 1m4SHz-0008K2-Hy for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 18:10:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4SHy-0003kR-Gs for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 18:10:18 +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 1m4SHy-0003j6-4z for pgsql-hackers@lists.postgresql.org; Fri, 16 Jul 2021 18:10:18 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m4SHv-0005ac-J3 for pgsql-hackers@postgresql.org; Fri, 16 Jul 2021 18:10:17 +0000 Received: by mail-io1-xd35.google.com with SMTP id g22so11648464iom.1 for ; Fri, 16 Jul 2021 11:10:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=S4KP3Por5YpC3s8RWltHuKBnMOjVFhVRFfcUAO6/PrQ=; b=QKcf5EL1hROM0WQ6KV5884SLe5gNP0dHOYNAfh7kxdu1f9+75KAbi2SpRyMtiX918e gFqTo3/ozHdkzdUyH6gjQxctLPYsYaqaxqnneQrM50nq25xAllQIJqrFLfJOyOe8lTvu 94PvWSolKQiNvWkYGsI9Nsz4Z2VvnGq3c0pqzxLRShOj2CQgUU189efU70/vpivuhYyJ kpE7c7/5OmduvrtcpSoQdbz2LNaqtlvQTTOcSyEciELJisBrlPAqgbXqyyFfXvoQKZI3 hq5KlPOFX9/AyrSN7pQON+F+jDri2Ma8Re9D33vMNnVvBPYKQk5TDQEvGa/STrZbvjAj OS9Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=S4KP3Por5YpC3s8RWltHuKBnMOjVFhVRFfcUAO6/PrQ=; b=bCGw5+ySLGtOYo8nhGmkp3waajLLlOwvosf4hrGnIjNSh0W4qj3d2h1eNnPF1IYDeF W6T1XfxmGukhgROGWOaYjt4vU8Zh1L/8FshHECIDuNCu15Kzb5z3YVn8QFn49yO0OzW1 Wv23DlPVElFcKlaYsbD2jHKrEI6fnrGldrKrlVAvOOwRyWauxk8Vh8F5tZB5SYvWv5th QV6Ut115BOzsB3qEDLwp+g4QDUSkzyPf0Diu8xxU7+SuNxOF47X1vy5Q1YsutNnDp4Fk Kw35mIqUsA3ttpM/gNgOfIyd4JUWRWjxAf0RuuSuRWM79ALX8yMuOGbJDAGSoGwz8Vyr hGng== X-Gm-Message-State: AOAM533aHtBwMwd9Ru3EAzfsuLhQUQA8xvwvZ+TtfCqghT3OTaM+4tkP KEL4nGJjaNciwAFUE3yPsTeeQA== X-Google-Smtp-Source: ABdhPJzTa8RGG1won0UTtSi8Nf17xd80aTtIFX9TBSVDcicMFofTZYeqOiv205JlMw+pGx2YzyrnNg== X-Received: by 2002:a02:cc19:: with SMTP id n25mr10013769jap.140.1626459014519; Fri, 16 Jul 2021 11:10:14 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id z7sm5776117iox.4.2021.07.16.11.10.13 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 16 Jul 2021 11:10:13 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id EE92E800989; Fri, 16 Jul 2021 13:10:12 -0500 (CDT) Date: Fri, 16 Jul 2021 13:10:12 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Tom Lane , pgsql-hackers@postgresql.org, Amit Langote Subject: Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers Message-ID: <20210716181012.GR20208@telsasoft.com> References: <20201027174318.GM9241@telsasoft.com> <202107141802.5wzzuwqwodsx@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <202107141802.5wzzuwqwodsx@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thanks for handling this. I think there's still an issue that comments on child triggers aren't preserved, right ? -- Justin