Show creating extension before using

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Show creating extension before using
Дата
Msg-id 167025992034.1903.12704722974897092392@wrigleys.postgresql.org
обсуждение исходный текст
Список 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;`."

В списке pgsql-docs по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: wiki postgresql Window_function some todo items is done?
Следующее
От: Jonathan Lemig
Дата:
Сообщение: Fwd: Views "missing" from information_schema.view_table_usage