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 1mldb5-0007rT-Kf for pgsql-novice@arkaria.postgresql.org; Fri, 12 Nov 2021 20:56:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mldb3-0007gH-Ot for pgsql-novice@arkaria.postgresql.org; Fri, 12 Nov 2021 20:56:29 +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 1mldb3-0007g8-Gt for pgsql-novice@lists.postgresql.org; Fri, 12 Nov 2021 20:56:29 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mldb1-0006jV-D3 for pgsql-novice@postgresql.org; Fri, 12 Nov 2021 20:56:28 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1mldaz-0002E1-5E; Fri, 12 Nov 2021 15:56:25 -0500 Date: Fri, 12 Nov 2021 15:56:25 -0500 From: Bruce Momjian To: Tom Lane Cc: Cabe Steele , pgsql-novice@postgresql.org Subject: Re: Regclass what does reg mean Message-ID: <20211112205625.GA1956@momjian.us> References: <22AB959D-AF98-4872-8FB7-7059EF27111E@gmail.com> <1851780.1636750482@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1851780.1636750482@sss.pgh.pa.us> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Nov 12, 2021 at 03:54:42PM -0500, Tom Lane wrote: > Cabe Steele writes: > > What does reg mean? Regclass regtype, regoper, etc > > The origin is lost in the mists of time --- regproc dates back to > Berkeley times, and the rest of those were named on its precedent. > I've always supposed that it meant "registered", as in "entered in > the system catalogs", but I wasn't there when regproc was invented. > > I wonder if there's any evidence for that ... [ digs ] ... ah-hah, > ref.cat in the Postgres v4r2 tarball, dated 03/13/94, says > > POSTGRES Type Meaning Required > ... > regproc registered procedure * > ... Wow, nice sleuth work! -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.