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 1pG1ZQ-0003RB-U1 for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jan 2023 17:40:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pG1ZP-0001xL-Lr for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jan 2023 17:40:55 +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 1pG1ZP-0001xC-B2 for pgsql-hackers@lists.postgresql.org; Thu, 12 Jan 2023 17:40:55 +0000 Received: from mail-pf1-x42e.google.com ([2607:f8b0:4864:20::42e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pG1ZM-0003EQ-Vy for pgsql-hackers@postgresql.org; Thu, 12 Jan 2023 17:40:54 +0000 Received: by mail-pf1-x42e.google.com with SMTP id c85so11049038pfc.8 for ; Thu, 12 Jan 2023 09:40:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; 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=vPb3lafqdvXfqPBpSBx8yboBiGuai6fzdWZQYtW3LDs=; b=P+zBGMSEGxdfQKqnI7GcQ/rEts0r4UYYzS6gdIRvgpWgD+OzW7X8ldpRy/IQbOv6un xuEQgdjJZXB+gye4f7a4o0l7Vc0bPOoRMBZKteGAQ+uT0szgc8XqKGMYIi5sX99S52+7 +f19S2ydobU0kch9+r/GCUG+fmocD4aghW7uXsj/sOJR9PgG4y1LrIH4YpIC1Pac7Y1E BzBeImQ2Mf8A8Is9VrNGWEikX8jECsui9HZjDHTOjTZjVivkN1z8YITOslkP0AODkEdU 1URvcWb21Lf7Z8EP1DAVsdn7SA2s+99OZ99NUphHnIGvd0jQ9ufsspGM0kp61nw+I1T3 gACQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; 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=vPb3lafqdvXfqPBpSBx8yboBiGuai6fzdWZQYtW3LDs=; b=IfBLE7ZIrhP4Xn0coCwc4CwF8NaI+7AE9t847HMsA8ritR0YFPGu+87IAyii3v5AQS lax58FsIxapJybCqOK8rVn1iRo6aZFfrWa5scuGjJxeHIdtSBDSBMZvuoUbFtYromPkY ia6eBD5XWecBOwlY+ssVj/LIi0gxhMg16R00pbLOidhgtFh96kJi1sFtqQ/9Oup2uoG2 dHUt9xn59W2Rkdkkge46isJYWlIqX3dxGXh3IkxbeiY2iwI7pXGgbHeSJF44vengEasf kAMKjnarbtjNbUEDLKSobsrPLGANXebVnvxuoNjtF7xT73i/hI4GDOiWHh7VpGbSITO9 MSKw== X-Gm-Message-State: AFqh2kpNs/Qi69PSibCer03I+8BWapf5Fimf/2jMsUqAKNOJ/cDwbxNF khzT34Nu1fQC83Be0Zi3S0g= X-Google-Smtp-Source: AMrXdXtkqb8xiiFERIfiS9mDrN2Hu+4BrN7WpSk6WlipoIOsXXi8Q2ECUEJ/uh8QF7FWyFEhnfepYQ== X-Received: by 2002:a62:1a09:0:b0:58b:46c9:a6b1 with SMTP id a9-20020a621a09000000b0058b46c9a6b1mr9767984pfa.33.1673545251887; Thu, 12 Jan 2023 09:40:51 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id 4-20020a620404000000b00576ee69c130sm12082501pfe.4.2023.01.12.09.40.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Jan 2023 09:40:51 -0800 (PST) Date: Thu, 12 Jan 2023 09:40:49 -0800 From: Nathan Bossart To: Tom Lane Cc: Peter Eisentraut , pgsql-hackers Subject: Re: Refactor recordExtObjInitPriv() Message-ID: <20230112174049.GA2047702@nathanxps13> References: <504bc485-6bd6-dd1b-fe10-e7351aeb310d@enterprisedb.com> <20230112000437.GA2032194@nathanxps13> <54b13402-b8ab-406a-d9a6-3542124ad6cf@enterprisedb.com> <1136333.1673544050@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1136333.1673544050@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jan 12, 2023 at 12:20:50PM -0500, Tom Lane wrote: > Peter Eisentraut writes: >> On 12.01.23 01:04, Nathan Bossart wrote: >> - classoid == AggregateRelationId || >>> I noticed that AggregateRelationId isn't listed in the ObjectProperty >>> array, so I think recordExtObjInitPriv() will begin erroring for that >>> classoid instead of ignoring it like we do today. > >> Hmm, we do have some extensions in contrib that add aggregates (citext, >> intagg). I suspect that the aggregate function is actually registered >> into the extension via its pg_proc entry, so this wouldn't actually >> matter. But maybe the commenting should be clearer? > > Yeah, I don't believe that AggregateRelationId is used in object > addresses; we just refer to pg_proc for any kind of function including > aggregates. Note that there is no "oid" column in pg_aggregate. Got it, thanks for clarifying. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com