pgsql: Doc: improve partitioning discussion in ddl.sgml.

2020-11-14 Thread Tom Lane
Doc: improve partitioning discussion in ddl.sgml. This started with the intent to explain that range upper bounds are exclusive, which previously you could only find out by reading the CREATE TABLE man page. But I soon found that section 5.11 really could stand a fair amount of editorial attentio

pgsql: Doc: improve partitioning discussion in ddl.sgml.

2020-11-14 Thread Tom Lane
Doc: improve partitioning discussion in ddl.sgml. This started with the intent to explain that range upper bounds are exclusive, which previously you could only find out by reading the CREATE TABLE man page. But I soon found that section 5.11 really could stand a fair amount of editorial attentio

pgsql: Doc: improve partitioning discussion in ddl.sgml.

2020-11-14 Thread Tom Lane
Doc: improve partitioning discussion in ddl.sgml. This started with the intent to explain that range upper bounds are exclusive, which previously you could only find out by reading the CREATE TABLE man page. But I soon found that section 5.11 really could stand a fair amount of editorial attentio

pgsql: Doc: improve partitioning discussion in ddl.sgml.

2020-11-14 Thread Tom Lane
Doc: improve partitioning discussion in ddl.sgml. This started with the intent to explain that range upper bounds are exclusive, which previously you could only find out by reading the CREATE TABLE man page. But I soon found that section 5.11 really could stand a fair amount of editorial attentio

pgsql: Provide the OR REPLACE option for CREATE TRIGGER.

2020-11-14 Thread Tom Lane
Provide the OR REPLACE option for CREATE TRIGGER. This is mostly straightforward. However, we disallow replacing constraint triggers or changing the is-constraint property; perhaps that can be added later, but the complexity versus benefit tradeoff doesn't look very good. Also, no special though

pgsql: Handle equality operator in contrib/pg_trgm

2020-11-14 Thread Alexander Korotkov
Handle equality operator in contrib/pg_trgm Obviously, in order to equality operator be satisfiable, target string must contain all the trigrams of the search string. On this base, we implement equality operator in GiST/GIN indexes with recheck. Discussion: https://postgr.es/m/CAOBaU_YWwtT7tdgg

pgsql: Fix alphabetic ordering in typedefs.list

2020-11-14 Thread Alexander Korotkov
Fix alphabetic ordering in typedefs.list Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/8afa3795a7a29f018769f16f6af936439847bd66 Modified Files -- src/tools/pgindent/typedefs.list | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)