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 1q7yUl-00065J-Ls for pgsql-hackers@arkaria.postgresql.org; Sat, 10 Jun 2023 13:19:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q7yUk-0007Tz-7p for pgsql-hackers@arkaria.postgresql.org; Sat, 10 Jun 2023 13:19:06 +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 1q7yUj-0007Th-St for pgsql-hackers@lists.postgresql.org; Sat, 10 Jun 2023 13:19:05 +0000 Received: from mail-pl1-x62b.google.com ([2607:f8b0:4864:20::62b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q7yUg-001GB6-EP for pgsql-hackers@postgresql.org; Sat, 10 Jun 2023 13:19:03 +0000 Received: by mail-pl1-x62b.google.com with SMTP id d9443c01a7336-1b3afd2f9bdso1168465ad.0 for ; Sat, 10 Jun 2023 06:19:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1686403141; x=1688995141; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=t6O2LDWQgmB9yVGsuMwXOEpFWAsHzsFwLXx7kK9sOL4=; b=ApKab0t5gpwg42xOf4otmsPiGAqwML5+Ae2wMOnlxL6OGCvNJXbiWfzzxpNL7XW1ZF ljsSVCR3GfKL5QxW4WPoC9zOqGujKdQKeStVFLqEQUVQLFj/GpkaTvpWQ9w+bwDtrcgH jhX9fmSehXBlFzr3WWHOAdEUtb/pJWqaotGlZa92HHmrZeo3OQyuXZ59wbbVqD65u0Ht bvh8CZznhLUUqpt8FFTfT3F7QeOrpc8cWkSvvZnEM5wJq4WgJDA4qumWIdvK0bjCAV1L GkCBODECmeAMggTDdUjcf7cQOouoogGJISxTKbcxcrUM9gE8VkyL4vmsWQoLyXZeQ8Il S4bg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686403141; x=1688995141; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=t6O2LDWQgmB9yVGsuMwXOEpFWAsHzsFwLXx7kK9sOL4=; b=HGrOeW3pWekEvwuQg/B/jniTqbzmCK4jz06s+z3xJmucuIZX9xMKCZbjqVGMT9iLIH kwTl9FbxKP3xsYfye3WY82vTCZmwluPg5Qh/E3ixi4vGwaxCZglUqU3fseb+ZfI3frlk qyz3b8o4OLc4a22Sf1huR5VncXhMYldXR8YDznKH3Z4LUDNxCKR6H2sGhj0/k8M7uynS 2tkAk/v7J3IPq4D7aNG92X7sJNOUohR4huUSr+B8MdMK/Fh8Ir6VCbk2gYj0ejwyCxZC VJcYtf8Yh5+YhpzhpLZy4pn62UnOwcNeEpNc/c7BnPhqshXKgJ4QQ8KCyzLm7fH5foP1 bWNg== X-Gm-Message-State: AC+VfDy7eNb/pfj0JP9MUEMJj+mZTLAtsrs2ZIHaq0T79HIrlY2J8CBl Xebh1N6tnZM46wD6lTQ7tNk= X-Google-Smtp-Source: ACHHUZ7VeQXB+1pmEor+YhOGONrS7o8ylGV56OBUKdJLwZMqYA58DmXLdLsVbwG/EngEoJ3rv9xdGQ== X-Received: by 2002:a17:902:c3c1:b0:1b3:b073:4d00 with SMTP id j1-20020a170902c3c100b001b3b0734d00mr663038plj.56.1686403141288; Sat, 10 Jun 2023 06:19:01 -0700 (PDT) Received: from jrouhaud (2001-b011-1005-d86b-4cc8-c696-56b6-bf0b.dynamic-ip6.hinet.net. [2001:b011:1005:d86b:4cc8:c696:56b6:bf0b]) by smtp.gmail.com with ESMTPSA id jk14-20020a170903330e00b001b050df0a93sm4967885plb.93.2023.06.10.06.18.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 10 Jun 2023 06:19:00 -0700 (PDT) Date: Sat, 10 Jun 2023 21:18:57 +0800 From: Julien Rouhaud To: Tom Lane Cc: David Steele , Amit Langote , Pg Hackers Subject: Re: Views no longer in rangeTabls? Message-ID: <20230610131857.cqrsm6pwq3k47yuv@jrouhaud> References: <3953179e-9540-e5d1-a743-4bef368785b0@pgmasters.net> <462cd5de-3ade-989b-0798-7e1cab562991@pgmasters.net> <470644.1686327286@sss.pgh.pa.us> <625519.1686401807@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <625519.1686401807@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Jun 10, 2023 at 08:56:47AM -0400, Tom Lane wrote: > > Well, if we're gonna do it we should do it for v16, rather than > change the data structure twice. It wouldn't be hard exactly: > > /* > * Clear fields that should not be set in a subquery RTE. Note that we > * leave the relid, rellockmode, and perminfoindex fields set, so that the > * view relation can be appropriately locked before execution and its > * permissions checked. > */ > - rte->relkind = 0; > rte->tablesample = NULL; > rte->inh = false; /* must not be set for a subquery */ > > plus adjustment of that comment and probably also the comment > for struct RangeTblEntry. and also handle that field in (read|out)funcs.c