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 1jBJXe-0005Tk-UK for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2020 14:38:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jBJXd-0005EY-L2 for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Mar 2020 14:38:01 +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 1jBJXd-0005EQ-3n for pgsql-hackers@lists.postgresql.org; Mon, 09 Mar 2020 14:38:01 +0000 Received: from mail-pg1-x544.google.com ([2607:f8b0:4864:20::544]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jBJXZ-0002Fj-Ob for pgsql-hackers@postgresql.org; Mon, 09 Mar 2020 14:37:59 +0000 Received: by mail-pg1-x544.google.com with SMTP id y30so4774433pga.13 for ; Mon, 09 Mar 2020 07:37:57 -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=3+jcaV8xAeVbx4DoOvI/eaGVaOm6DPqvvw0bW/t+Wo0=; b=nut1StHoZptyah8PXV3CnuqJuxQ9rrt4JhYqcNJdtXFTTGihSnj5QOq8wP5uVQnZ0a H0Pe6IFIUYVdfwE5P+YiS9vM8QbELfmUA7wczCVZXUrC24nZUPlN2GlQVrvAgQwWSX3U +0VKy+NVWnaiDGt5FeXdZ8Tr/+IeJes8QvLdk/EBm+Ic4/xNcl1kiqRpgUKHm3Fj8hcL QqEcEB3hARctnsdLmljLvmUatxmuOH7qFzdLglogNtm1oTrWGYVard6zdPnTv4vrU4We VYODXFFHlH3Z0487V4XCPbPX61kygNgo/vYT6vhjfBB8NGczDXLyHXCvcSqG7ILGUXRh DwBQ== 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=3+jcaV8xAeVbx4DoOvI/eaGVaOm6DPqvvw0bW/t+Wo0=; b=fioWSTpt3Vx7eAMUyeCHBVpjTBP7bNBTEqvhkFZOFq7/uRRD5M/Ha1vTWdz2utsy+F B9SQIxL+qLvY+zupBW+S/8riyquKkMhu+FA4iahALhHz3fYe9YQ+D//qncHpShfX1Iq9 5DpXBkVmeNG+0UivldZp+8Z0EZQ7tTIYBvB1Vd92LYA2r1vQo7wSyicNRFrAniJxNUiM 1f+CGb/U8Q2HefsuZdlQq5qOz1XZX7l8HTXJIPnIXg9wJf0V5Xh3CQjCojKyRkJf1fnd hrT9TQCju5AOI+efYwW6beq6GE1UyQe6ybpg8xMvV8BqpzLhIq4KLyDO8GYKC/MIOkrS JS8A== X-Gm-Message-State: ANhLgQ3ESoQmZVWlOI7GYRAdUfufDEcmiCbZ0pQgtdcGHr0AdiuS3ahG k1D9YWXmywQ1hcE0jbB93lulsItcYNhHAk2ee5luRFEJ0IdNzVz/TfuCEIXQDEXISMwn4uhqlxE 1+xR7vAG7EjpUzYFZ9+C/sVcaDFiH2FRmF1l8Oa0KGviSk5dh/DhGZVj7naHKb1rUAk4ck31zA2 NDzXRBVbmL/MCuqJcTZC6DKtEKPkNdhg== X-Google-Smtp-Source: ADFU+vt/qUTJ/AEb9QcZ2tyummQl3Pr4B7W0nuvw7NhdX8K+DANLzJecpulqhh9Zxzy0w9rdXH6JRQ== X-Received: by 2002:a63:5561:: with SMTP id f33mr5808983pgm.20.1583764676268; Mon, 09 Mar 2020 07:37:56 -0700 (PDT) Received: from localhost.localdomain ([114.143.109.178]) by smtp.gmail.com with ESMTPSA id u41sm45300678pgn.8.2020.03.09.07.37.51 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 09 Mar 2020 07:37:55 -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: <087bd809-e1d7-ee44-da1f-25996abad442@enterprisedb.com> Date: Mon, 9 Mar 2020 20:07:45 +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 I observed that , we do support 'global temp' keyword with views postgres=# create or replace  global temp view v1 as select 5; CREATE VIEW but if we take the dump( using pg_dumpall) then it only display 'create view' look like we are skipping it ? -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company