Re: Another user complaint regarding visibility of pg_catalog data

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 go

Another user complaint regarding visibility of pg_catalog data

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 ago

Re: Example for Unique Partial Indexes

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 > e

Re: Example for Unique Partial Indexes

"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 ta

Re: Example for Unique Partial Indexes

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 i

Example for Unique Partial Indexes

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." C

An inconsistency in the documentation about full text search

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 to_tsvector.