Elaborate on phrase "table metadata" in the Notes section of ALTER by specifying pg_attribute

agora inbox for pgsql-docs@postgresql.org  
help / color / mirror / Atom feed

From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: amin@gilani.me
Subject: Elaborate on phrase "table metadata" in the Notes section of ALTER by specifying pg_attribute
Date: Wed, 11 Sep 2024 20:12:19 +0000
Message-ID: <172608553929.1128079.5845807167540849323@wrigleys.postgresql.org> (raw)

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/sql-altertable.html
Description:

I am newish to Postgres, and the term "table metadata" was confusing to
me.

I am more than happy to submit a patch for this. I'm just unfamiliar with
the process. Please advise.

> When a column is added with ADD COLUMN and a non-volatile DEFAULT is
specified, the default is evaluated at the time of the statement and the
result stored in the table's metadata. That value will be used for the
column for all existing rows. If no DEFAULT is specified, NULL is used. In
neither case is a rewrite of the table required.

Specifically this sentence: "the result stored in the table's metadata"

Suggest adding specific language to correct it to "the result stored in the
table's metadata. See `pg_attribute` for more information."

Once again, I am more than happy to submit a patch for this.

Thank you

view thread (2+ messages)  latest in thread

Message-ID: <172608553929.1128079.5845807167540849323@wrigleys.postgresql.org>
Permalink:  ../172608553929.1128079.5845807167540849323@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/172608553929.1128079.5845807167540849323@wrigleys.postgresql.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, amin@gilani.me
  Subject: Re: Elaborate on phrase "table metadata" in the Notes section of ALTER by specifying pg_attribute
  In-Reply-To: <172608553929.1128079.5845807167540849323@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox