Thread: Regclass what does reg mean

What does reg mean? Regclass regtype, regoper, etc


Thanks,

Cabe

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

On Fri, Nov 12, 2021 at 03:54:42PM -0500, Tom Lane wrote:
> 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                    *
>     ...

Wow, nice sleuth work!

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.