Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jBIYX-0001KB-3o for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2020 13:34:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jBIYV-0005cK-KT for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2020 13:34:51 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1jBIYV-0005cD-6v for pgsql-hackers@lists.postgresql.org; Mon, 09 Mar 2020 13:34:51 +0000 Received: from mail-pl1-x643.google.com ([2607:f8b0:4864:20::643]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jBIYR-0003Nh-IQ for pgsql-hackers@postgresql.org; Mon, 09 Mar 2020 13:34:50 +0000 Received: by mail-pl1-x643.google.com with SMTP id ay11so3998528plb.0 for ; Mon, 09 Mar 2020 06:34:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=0fI6060BZ0oLBnRe4vqn4N6vZhYgXSMZpv31dpRRoAM=; b=0zFAk9uEhbyweczUhCh5XHH57voan9+krUgPjkzuI6k9/kAFkE4SrpFgOpJNt2ZL/v +4x7wWjs8dIEqob+mai3rynAmLpR24Vo8DozmhqYmlEECQh1aRF+1Kg18cPk/OJLzQTw 9egQPdZf3EN5zZWn3wcm4RnLcF6DR0vzAyODApv2aAmPJJbrAiDayugQD8h6v88/CTuw b6UUdESRdIuy8hH2MCGmGTxSiC9vNidYS720NCEoupAG/ovf78ZqA+A0m/du1oJmeLdX uFS3p/zhTgXdXsvXVl3CAiHRj2XlJWU5Zg0iEJAZqJdQ4aEy5RN2HozqCRB3qXWRdIQo LY5g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=0fI6060BZ0oLBnRe4vqn4N6vZhYgXSMZpv31dpRRoAM=; b=kqllQ+eJZ5ANL7lo4lfbAoGRi4vKujuYXdgh1uvjEaLY6Gs6TeJqT0KNSbNSh/BP9l Z2CBjSHd2vgfSVNWBEriYs7+QKUtW5yFDO+ONg1AxVBzmOJg1H8iRJKqA+PkD5v4hJJD WZ86n9FtQc2A8BOrULIk/W+X/A7wfCRP+XtGdiwfCq1GPVT6bCGlevbVMHCeMpwje32A RlKDeN46vdofFxAFeTj0h1FfZssgqIzX4c5ejgG2q2JBSGFGzjOrhRHabKHajnm9tp0+ DxiLy0tjy10HsD82HODAbalDYsKZZTZpYxK2pAJ9XIbTii/Aqs+jtDHqwNr81Z+f/kVy VyKQ== X-Gm-Message-State: ANhLgQ0ztbyKoyUG7ySMqckzdPl/RciZok3j1c79fnBg8v6Srx7Ayngi t46xaZgbZKQYpqS14evZ4iRk+eaVpCBQZLwbJk/oN4sbtx5fWY91azjt49CND+u9J2mpAg3drKq nHYBdULjA3Ccx5bPJQ7RDtHATKvc5ObGxXr3VFLdlNggXc0fH30a9Tb3EzNd4pEms0MtD/iedMx h7NUGGczueicr4WqTGYan5SFVhLVnzqw== X-Google-Smtp-Source: ADFU+vvzjOTWKp/ZB0LcC9iWOuz5CrQOzy0VHisEYeXq0t02djZiKcVdN2Te7mrnXBBGEJgAt8JRdw== X-Received: by 2002:a17:902:b090:: with SMTP id p16mr3793764plr.274.1583760885127; Mon, 09 Mar 2020 06:34:45 -0700 (PDT) Received: from localhost.localdomain ([114.143.109.178]) by smtp.gmail.com with ESMTPSA id 127sm25611702pfb.130.2020.03.09.06.34.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 09 Mar 2020 06:34:44 -0700 (PDT) Subject: Re: [Proposal] Global temporary tables To: =?UTF-8?B?5pu+5paH5peMKOS5ieS7jik=?= Cc: Prabhat Sahu , Pavel Stehule , Robert Haas , Tomas Vondra , Konstantin Knizhnik , PostgreSQL Hackers , =?UTF-8?B?6JSh5p2+6Zyy?= =?UTF-8?B?KOWtkOWYiSk=?= , "Cai, Le" , =?UTF-8?B?6JCn5bCR6IGqKOmTgeW6tSk=?= References: <24099f4e-742c-e92b-729c-77bac1ca80d4@postgrespro.ru> <35A2DF75-05A8-4F8D-9D43-A930E2ABDFDD@alibaba-inc.com> <82851B35-E2FB-4A5D-AF35-A2B5023DB9F2@alibaba-inc.com> <77320A29-DC39-4EFE-A5E2-0A00F6A316E8@alibaba-inc.com> <7eb93026-0f35-325a-132f-ca183a5da3ac@enterprisedb.com> <7CCE7DE5-5E85-4155-9010-5EDEAE762194@alibaba-inc.com> From: tushar Message-ID: Date: Mon, 9 Mar 2020 19:04:39 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0 MIME-Version: 1.0 In-Reply-To: <7CCE7DE5-5E85-4155-9010-5EDEAE762194@alibaba-inc.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-CLOUD-SEC-AV-Info: edb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/6/20 12:35 PM, 曾文旌(义从) wrote: > Fixed in global_temporary_table_v17-pg13.patch Thanks Wenjing. Please refer this scenario , where i am able to set 'on_commit_delete_rows=true'  on regular table using 'alter' Syntax  which is not allowed using 'Create' Syntax --Expected - postgres=# CREATE TABLE foo () WITH (on_commit_delete_rows='true'); ERROR:  The parameter on_commit_delete_rows is exclusive to the global temp table, which cannot be specified by a regular table --But user can do this with 'alter' command - postgres=# create table foo(); CREATE TABLE postgres=# alter table foo set (on_commit_delete_rows='true'); ALTER TABLE postgres=# -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company