Re: Typo in "27.2.8. Synchronous Replication"

2022-01-03 Thread Eric Mutta 
Hi Magnus, happy new year! Thanks for pushing the fix.

Coming from an SQL Server background where the docs are hosted on GitHub
and minor changes like this can be made by simply submitting a pull
request, I am wondering is there anything similar for the Postgres docs?

Going through a mailing list just to fix a typo feels like a lot of
overhead!

On Sun, Jan 2, 2022, 19:08 Magnus Hagander  wrote:

> On Mon, Dec 27, 2021 at 12:07 AM PG Doc comments form
>  wrote:
> >
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/14/warm-standby.html
> > Description:
> >
> > The following sentence:
> >
> > > The minimum wait time is the round-trip time **between primary to
> > standby.**
> >
> > Should either end with "...between primary AND standby" or end with
> "...FROM
> > primary to standby".
>
> That's indeed correct. Fix pushed. I went with "primary and standby"
> because that's the terminology used elsewhere in the same file.
>
> --
>  Magnus Hagander
>  Me: https://www.hagander.net/
>  Work: https://www.redpill-linpro.com/
>

vectorization is not helping with plural to singular matching

2022-01-03 Thread PG Doc comments form 
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/textsearch-intro.html
Description:

SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); 

This is giving false, even I tried for various other examples for plural to
singular matching but it fails. 

e.g. select to_tsvector('buildings') @@ plainto_tsquery('building')

This simple match is also coming as false, means vectorization is not
helping with plural to singular matching.

version used: 

PostgreSQL 13.4 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1
20180712 (Red Hat 7.3.1-6), 64-bit

Re: vectorization is not helping with plural to singular matching

2022-01-03 Thread Tom Lane 
PG Doc comments form  writes:
> SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); 

> This is giving false, even I tried for various other examples for plural to
> singular matching but it fails. 

The case works for me, but I have

=# show default_text_search_config;
 default_text_search_config 

 pg_catalog.english
(1 row)

I'm betting your default is set to some other language in which
stripping trailing "s" wouldn't make sense.

regards, tom lane