Re: Documenting more pitfalls of non-default collations?

2024-06-11 Thread Will Mortensen
Hi Jeff, Unicode case folding would be great! I wonder if there might still be situations where multiple collations are applied within the same expression/statement and this produces a surprising result. So far I'm mostly coming up with examples that seem more contrived or less surprising, but ma

Re: Documenting more pitfalls of non-default collations?

2024-06-11 Thread Jeff Davis
On Mon, 2024-06-10 at 23:55 -0700, Will Mortensen wrote: > I mentioned to Jeremy at pgConf.dev that using non-default collations > in some SQL idioms can produce undesired results, and he asked me to > send an email. An example idiom is the way Django implements > case-insensitive comparisons using

Bibliography reference redirects to a Forbiden page.

2024-06-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/biblio.html Description: "Serializable Snapshot Isolation in PostgreSQL" by D. Ports, in the bibliography leads to a forbidden page. I've managed to find the paper here: https://drkp.net/

Re: Ambiguous description on new columns

2024-06-11 Thread Amit Kapila
On Fri, Jun 7, 2024 at 3:23 PM Koen De Groote wrote: > > Yes, this change is clear to me that the "columns added" applies to the table > on the publisher. > Thanks for the confirmation. I have pushed and backpatched the fix. -- With Regards, Amit Kapila.