From: Tom Lane <tgl@sss.pgh.pa.us>
To: Cabe Steele <cabesteele@gmail.com>
cc: pgsql-novice@postgresql.org
Subject: Re: Regclass what does reg mean
In-reply-to: <22AB959D-AF98-4872-8FB7-7059EF27111E@gmail.com>
References: <22AB959D-AF98-4872-8FB7-7059EF27111E@gmail.com>
Comments: In-reply-to Cabe Steele <cabesteele@gmail.com>
	message dated "Fri, 12 Nov 2021 14:41:38 -0600"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1851779.1636750482.1@sss.pgh.pa.us>
Date: Fri, 12 Nov 2021 15:54:42 -0500
Message-ID: <1851780.1636750482@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1851780.1636750482%40sss.pgh.pa.us>
Precedence: bulk

Cabe Steele <cabesteele@gmail.com> 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                    *
	...

			regards, tom lane