Show creating extension before using

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: him(at)nathanmlong(dot)com
Subject: Show creating extension before using
Date: 2022-12-05 17:05:20
Message-ID: 167025992034.1903.12704722974897092392@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/citext.html
Description:

On https://www.postgresql.org/docs/current/citext.html in "F.10.2. How to
Use It", it says "here's a simple example of usage" and begins by creating a
table with a `CITEXT` column.

For seasoned PostgreSQL users, it may be obvious that before running such an
example, one must `CREATE EXTENSION IF NOT EXISTS citext;`, but if a newer
user is told "use citext for this column" and given a link to this page,
nothing tells them how to enable it.

I suggest adding this instruction somewhere on this page, either in its own
section like "How to Enable It", or at the start of the "simple example", or
even at the end of the sentence near the top: "It can be installed by
non-superusers who have CREATE privilege on the current database by running
`CREATE EXTENSION IF NOT EXISTS citext;`."

Browse pgsql-docs by date

  From Date Subject
Next Message Jonathan Lemig 2022-12-05 17:47:52 Re: Views "missing" from information_schema.view_table_usage
Previous Message Laurenz Albe 2022-12-05 08:09:34 Re: wiki postgresql Window_function some todo items is done?