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 1j9W88-0000AM-3r for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2020 15:40:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j9W86-0003V7-Lf for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2020 15:40:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j9W86-0003V0-5d for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2020 15:40:14 +0000 Received: from mail-pj1-x1044.google.com ([2607:f8b0:4864:20::1044]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j9W7y-0004Lf-W1 for pgsql-hackers@postgresql.org; Wed, 04 Mar 2020 15:40:12 +0000 Received: by mail-pj1-x1044.google.com with SMTP id nm6so1063034pjb.0 for ; Wed, 04 Mar 2020 07:40:06 -0800 (PST) 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=lDkEfEsZN84Egmz5RDE3TGG3CEWjkr8wt1w+6JK1PlA=; b=UsRZihgENTlZrN4Koz7gMVvjwyaBUop+5pyZRCoBMSVk88pxyazo3dyFs09vKynTem UVATZPw0pjcZsvKsyo8AB0zam+YcOu3N46O+NDJFuSO165lPUrdlpxERP68mkJTg3TrH NhPuJOIdoaceqHAxzsGkxXDLZFejPWK0DGoL5e83WjZGIqySjdHqNb7BgtOb7rwO3vjG Bqj1bA0x6JyuRBBKHkHs4MbRv4qn6rrX5zICt0knd+8vHi64hVmjdCBEO9R+75gc6X1c WYatH/u2zLbcQdpwddGrnfQ+i2B4e4gobsaXEcqf4dsxrYSPFe1vX+onNpTZI/vrAlyf zHtw== 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=lDkEfEsZN84Egmz5RDE3TGG3CEWjkr8wt1w+6JK1PlA=; b=qAZFGU9ecullMSQ7LGdyeVGf9V0kI0IXc1v1Ajl63XLz360D08SyOHZthnAwQH6OqP /R0R3OLbE5E4WZpyILEtkcQDizlKI5CsTX6Mi4GJknBxDMudzXoD3ybQ4SCuLXt6xEp+ YOnvCKpN4ZukDB9fNEYnAMzuaUpmudgfLXaiXPp1fVDfbnPwCO+7rwObHUNk0DG3E7jn gGY0M74iJmq1BHABAvCA7cF3sqRXQe5GXDGkmpmey7C5Lduce6OcFUibxpy5tR9QVNRt QjoXVJpc5Vw9y84mV6m+yj+HlZm7GSm6eVcd3zDoIAJYeE0SEM1SUvrnBMyBMdSJxnSO ItBQ== X-Gm-Message-State: ANhLgQ1lpJnR7ZMMw/cqhBIYfd+Di+YtUqlMAeo8QrSQ1FVRqAvTVeGF n+FNcRQt3wEWlvcD3wm+l52XeqFQgW/x1aPM2xrsU7/W504x/0Lyt3jNdM2KNLIW9htk5/ukHSS CNSOpJ5wD8sRC8XtygSDqmkqUwa5XZsX2lfog1X2+bJdxFyCoQFLdYD2EIQQNuG4+mPKdgUzA1q wca3D1g1rhER+6uSmFnKkfkpPnqls3Jg== X-Google-Smtp-Source: ADFU+vt+XAdLmGzG1Ot/F4JGSyapYMZi5HsySMjeIQItHYAPG3ShOxgQAATR4VR6+Q8zVgdWO/JyAw== X-Received: by 2002:a17:902:bd90:: with SMTP id q16mr3556491pls.109.1583336405648; Wed, 04 Mar 2020 07:40:05 -0800 (PST) Received: from localhost.localdomain ([114.143.109.178]) by smtp.gmail.com with ESMTPSA id m12sm3202417pjf.25.2020.03.04.07.40.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 04 Mar 2020 07:40:04 -0800 (PST) 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> <8BC7841E-3B32-4518-9586-D9ED571F4922@alibaba-inc.com> <35A2DF75-05A8-4F8D-9D43-A930E2ABDFDD@alibaba-inc.com> <82851B35-E2FB-4A5D-AF35-A2B5023DB9F2@alibaba-inc.com> <77320A29-DC39-4EFE-A5E2-0A00F6A316E8@alibaba-inc.com> From: tushar Message-ID: <7eb93026-0f35-325a-132f-ca183a5da3ac@enterprisedb.com> Date: Wed, 4 Mar 2020 21:09:57 +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: 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/3/20 2:10 PM, 曾文旌(义从) wrote: > I fixed in global_temporary_table_v16-pg13.patch. Thanks Wenjing. The reported  issue is fixed now  but  there is an another similar  scenario - if we enable 'on_commit_delete_rows' to true using alter command then getting same issue i.e rows are not removing after commit. x=# create global  temp table foo123(n int) with (on_commit_delete_rows='false'); CREATE TABLE x=# x=# alter table foo123 set ( on_commit_delete_rows='true'); ALTER TABLE x=# x=# insert into foo123 values (1); INSERT 0 1 x=# select * from foo123;   <- row should get removed.  n ---  1 (1 row) -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company