Re: Another user complaint regarding visibility of pg_catalog data

2023-11-07 Thread David G. Johnston
On Tue, Nov 7, 2023 at 12:28 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > Is this something we just don't want to go into detail within our > documentation, or just no one has cared enough to write something up > (beyond my first draft back then) and form it into a patch? > I've

Another user complaint regarding visibility of pg_catalog data

2023-11-07 Thread David G. Johnston
Hey, This comes up every so often (including today on Discord) and I keep having trouble figuring out where to point people for our official assertion and explanation for why anyone with a login can view routine bodies, view specifications, and comments. Apparently I griped about this a while

Re: Example for Unique Partial Indexes

2023-11-07 Thread David G. Johnston
On Tue, Nov 7, 2023 at 10:08 AM Tom Lane wrote: > "David G. Johnston" writes: > > On Tue, Nov 7, 2023, 09:25 PG Doc comments form > > wrote: > >> Currently, the documentation does not provide information on how to > create > >> unique partial indexes. Unique partial indexes are valuable for >

Re: Example for Unique Partial Indexes

2023-11-07 Thread Tom Lane
"David G. Johnston" writes: > On Tue, Nov 7, 2023, 09:25 PG Doc comments form > wrote: >> Currently, the documentation does not provide information on how to create >> unique partial indexes. Unique partial indexes are valuable for enforcing >> uniqueness of a column's value over a subset of a

Re: Example for Unique Partial Indexes

2023-11-07 Thread David G. Johnston
On Tue, Nov 7, 2023, 09:25 PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/indexes-unique.html > Description: > > I would like to request an improvement to the PostgreSQL documentation, > specifically

Example for Unique Partial Indexes

2023-11-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/indexes-unique.html Description: I would like to request an improvement to the PostgreSQL documentation, specifically in the sections "11.6. Unique Indexes" and "11.8. Partial Indexes."

An inconsistency in the documentation about full text search

2023-11-07 Thread Erki Eessaar
Hello I write about the documentation of full-text search. Section 12.2.2. Creating Indexes https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX wrtites the following: "Another approach is to create a separate tsvector column to hold the output of