public inbox for [email protected]
help / color / mirror / Atom feedFrom: Daniel Gustafsson <[email protected]>
To: David Rowley <[email protected]>
Cc: [email protected]
Cc: Magnus Hagander <[email protected]>
Subject: Re: Typos in the featurematrix
Date: Wed, 15 Oct 2025 15:22:47 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAApHDvpOXAOPEhXRnWimyWmuRf+gN=yx22AoP_WM3aZ0M=n6Vw@mail.gmail.com>
References: <[email protected]>
<CAApHDvpOXAOPEhXRnWimyWmuRf+gN=yx22AoP_WM3aZ0M=n6Vw@mail.gmail.com>
> On 15 Oct 2025, at 13:00, David Rowley <[email protected]> wrote:
>
> On Tue, 14 Oct 2025 at 20:46, Daniel Gustafsson <[email protected]> wrote:
>> While working on something else I noticed that the featurematrix has a few
>> typos, unless there are objections I'll go ahead with the attached.
>
> Patch looks good.
>
> I had a read and found a few more:
Thanks, I have incorporated all of these in the v2 attached.
When doing that I noticed that the capitilization of PL/pgSQL and other PL's
was quite varied. 0002 in the attached corrects that to ensure consistency
across the items in the featurematrix with corresponding names in the docs.
Since I don't have a local version of the site running I am adding Magnus to
cc: hoping he can validate that the patched file works.
--
Daniel Gustafsson
Attachments:
[application/octet-stream] v2-0002-Standardize-capitalization-of-procedural-language.patch (8.3K, 2-v2-0002-Standardize-capitalization-of-procedural-language.patch)
download | inline diff:
From eee4238ca768c9861abad4facd521d08f038fcb1 Mon Sep 17 00:00:00 2001
From: Daniel Gustafsson <[email protected]>
Date: Wed, 15 Oct 2025 15:16:31 +0200
Subject: [PATCH v2 2/2] Standardize capitalization of procedural languages in
featurematrix
Constistently use PL/pgSQL, PL/Python and PL/Perl throughout the
featurematrix.
Author: Daniel Gustafsson <[email protected]>
Discussion: https://postgr.es/m/[email protected]
---
data/featurematrix.yaml | 66 ++++++++++++++++++++---------------------
1 file changed, 33 insertions(+), 33 deletions(-)
diff --git a/data/featurematrix.yaml b/data/featurematrix.yaml
index 2a069b37..e0a20466 100644
--- a/data/featurematrix.yaml
+++ b/data/featurematrix.yaml
@@ -1563,7 +1563,7 @@ featurematrix:
description: adds support for a boolean expression to be checked if a trigger
should be fired or not
Procedural Languages:
- - name: CASE in pl/pgsql
+ - name: CASE in PL/pgSQL
versions:
'8.4': 'Yes'
description: allows the use of CASE as a conditional expression in addition to
@@ -1576,51 +1576,51 @@ featurematrix:
versions:
'9.5': 'Yes'
url: https://www.postgresql.org/docs/9.5/static/sql-createtransform.html
- - name: DO statement for pl/perl
+ - name: DO statement for PL/Perl
versions:
'9.0': 'Yes'
- description: allows the execution of anonymous code blocks in pl/perl
- - name: DO statement for pl/pgsql
+ description: allows the execution of anonymous code blocks in PL/Perl
+ - name: DO statement for PL/pgSQL
versions:
'9.0': 'Yes'
- description: allows the execution of anonymous code blocks in pl/pgsql
+ description: allows the execution of anonymous code blocks in PL/pgSQL
- name: EXCEPTION support in PL/pgSQL
versions:
'8.1': 'Yes'
- description: full exception handling support in pl/pgsql
+ description: full exception handling support in PL/pgSQL
- name: EXECUTE USING in PL/pgSQL
versions:
'8.4': 'Yes'
description: ''
- - name: FOREACH IN ARRAY in pl/pgsql
+ - name: FOREACH IN ARRAY in PL/pgSQL
versions:
'9.1': 'Yes'
description: This is more efficient and readable than previous methods of iterating
through the elements of an array value.
- - name: IN/OUT/INOUT parameters for pl/pgsql and PL/SQL
+ - name: IN/OUT/INOUT parameters for PL/pgSQL and PL/SQL
versions:
'8.1': 'Yes'
description: ''
- name: Named parameters
versions:
'8.1': 'Yes'
- description: allows the use of named parameters in pl/pgsql
+ description: allows the use of named parameters in PL/pgSQL
- name: Non-superuser language creation
versions:
'8.3': 'Yes'
description: database owners can now create trusted languages
- - name: pl/pgsql installed by default
+ - name: PL/pgSQL installed by default
versions:
'9.0': 'Yes'
- description: pl/pgsql is now installed by default in all newly created database
+ description: PL/pgSQL is now installed by default in all newly created database
- name: Polymorphic functions
versions:
'8.1': 'Yes'
description: ''
- - name: Python 3 support for pl/python
+ - name: Python 3 support for PL/Python
versions:
'9.0': 'Yes'
- description: support for Python 3 in pl/python
+ description: support for Python 3 in PL/Python
- name: 'Qualified function parameters '
versions:
'8.3': 'Yes'
@@ -1630,25 +1630,25 @@ featurematrix:
'14': 'Yes'
description: The `RETURN QUERY` directive in PL/pgSQL supports executing queries
with parallelism.
- - name: RETURN QUERY in pl/pgsql
+ - name: RETURN QUERY in PL/pgSQL
versions:
'8.3': 'Yes'
- description: simply way to return the result of an arbitrary query in pl/pgsql
+ description: simple way to return the result of an arbitrary query in PL/pgSQL
- name: ROWS and COST specification for functions
versions:
'8.3': 'Yes'
description: CPU costs and the number of expected rows can now be specified for
procedural functions to give better hints to the planner
- - name: Scrollable and updatable cursor support for pl/pgsql
+ - name: Scrollable and updatable cursor support for PL/pgSQL
versions:
'8.3': 'Yes'
- description: support for scroll- and updatable cursors in pl/pgsql functions
- - name: SQLERRM/SQLSTATE for pl/pgsql
+ description: support for scroll- and updatable cursors in PL/pgSQL functions
+ - name: SQLERRM/SQLSTATE for PL/pgSQL
versions:
'8.1': 'Yes'
description: allows simple access to the SQL error state and the associated error
text if an exception happened
- - name: Unicode object support in PL/python
+ - name: Unicode object support in PL/Python
versions:
'9.0': 'Yes'
description: ''
@@ -1656,10 +1656,10 @@ featurematrix:
versions:
'8.4': 'Yes'
description: allows to generate user defined exceptions through RAISE
- - name: Validator function for pl/perl
+ - name: Validator function for PL/Perl
versions:
'8.1': 'Yes'
- description: compile time validation of pl/pgsql code
+ description: compile time validation of PL/pgSQL code
Extensions:
- name: CREATE EXTENSION .. CASCADE
versions:
@@ -2016,9 +2016,9 @@ legacymap: # This maps old id based URLs to the new titles and will generate re
4: Heap Only Tuples (HOT)
8: Asynchronous Commit
11: Distributed checkpointing
- 13: Scrollable and updatable cursor support for pl/pgsql
+ 13: Scrollable and updatable cursor support for PL/pgSQL
14: ROWS and COST specification for functions
- 15: SQLERRM/SQLSTATE for pl/pgsql
+ 15: SQLERRM/SQLSTATE for PL/pgSQL
19: EUC_JIS_2004/ SHIFT_JIS_2004 support
20: Per function GUC settings
24: Partial sort capability (top-n sorting)
@@ -2044,10 +2044,10 @@ legacymap: # This maps old id based URLs to the new titles and will generate re
67: IPv6 Support
68: Inlining of SQL-functions
73: Statement level triggers
- 78: RETURN QUERY in pl/pgsql
+ 78: RETURN QUERY in PL/pgSQL
79: 'Qualified function parameters '
- 80: IN/OUT/INOUT parameters for pl/pgsql and PL/SQL
- 82: Validator function for pl/perl
+ 80: IN/OUT/INOUT parameters for PL/pgSQL and PL/SQL
+ 82: Validator function for PL/Perl
83: Named parameters
84: EXCEPTION support in PL/pgSQL
85: Polymorphic functions
@@ -2064,7 +2064,7 @@ legacymap: # This maps old id based URLs to the new titles and will generate re
127: tsearch2 compatibility wrapper
128: Statement level TRUNCATE triggers
129: EXECUTE USING in PL/pgSQL
- 130: CASE in pl/pgsql
+ 130: CASE in PL/pgSQL
133: Database level Collation
135: Hashing support for DISTINCT/UNION/INTERSECT/EXCEPT
136: RETURNS TABLE
@@ -2088,10 +2088,10 @@ legacymap: # This maps old id based URLs to the new titles and will generate re
163: Deferrable unique constraints
165: XML, JSON and YAML output for EXPLAIN
166: Default permissions
- 167: DO statement for pl/pgsql
+ 167: DO statement for PL/pgSQL
168: GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS
170: Per user/database server configuration settings
- 171: Unicode object support in PL/python
+ 171: Unicode object support in PL/Python
175: dblink asynchronous notification support
176: Spinlock support for the SuperH hardware platform
178: WHEN clause for CREATE TRIGGER
@@ -2100,9 +2100,9 @@ legacymap: # This maps old id based URLs to the new titles and will generate re
181: EXPLAIN (BUFFERS) support
183: Large object access controls
184: Search+bind mode operation for LDAP authentication
- 185: pl/pgsql installed by default
- 186: DO statement for pl/perl
- 187: Python 3 support for pl/python
+ 185: PL/pgSQL installed by default
+ 186: DO statement for PL/Perl
+ 187: Python 3 support for PL/Python
188: Hot Standby
189: Typed tables
190: Payload support for LISTEN/NOTIFY
@@ -2125,7 +2125,7 @@ legacymap: # This maps old id based URLs to the new titles and will generate re
213: ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX
214: Foreign keys marked as NOT VALID
215: Triggers on views
- 216: FOREACH IN ARRAY in pl/pgsql
+ 216: FOREACH IN ARRAY in PL/pgSQL
217: Index-only scans
218: Multi-core scalability for read-only workloads
219: Cascading streaming replication
--
2.39.3 (Apple Git-146)
[application/octet-stream] v2-0001-Fix-typos-in-feature-matrix.patch (6.9K, 3-v2-0001-Fix-typos-in-feature-matrix.patch)
download | inline diff:
From eb8534464ac77e0caa3357cd38c3f1e009b7b3d4 Mon Sep 17 00:00:00 2001
From: Daniel Gustafsson <[email protected]>
Date: Tue, 14 Oct 2025 09:40:24 +0200
Subject: [PATCH v2 1/2] Fix typos in feature matrix
Author: Daniel Gustafsson <[email protected]>
Reviewed-by: David Rowley <[email protected]>
Discussion: https://postgr.es/m/[email protected]
---
data/featurematrix.yaml | 32 ++++++++++++++++----------------
1 file changed, 16 insertions(+), 16 deletions(-)
diff --git a/data/featurematrix.yaml b/data/featurematrix.yaml
index 3e471943..2a069b37 100644
--- a/data/featurematrix.yaml
+++ b/data/featurematrix.yaml
@@ -21,7 +21,7 @@ featurematrix:
versions:
'8.4': 'Yes'
description: replaces the shared memory fixed size free space map with an on-disk
- implemenation
+ implementation
- name: Dynamic Background Workers
versions:
'9.4': 'Yes'
@@ -347,7 +347,7 @@ featurematrix:
'15': 'Yes'
description: "- `regexp_count`: counts the number of places that match the regular\
\ expression in a string\r\n- `regexp_instr `: returns the starting of the Nth\
- \ match of a regular expression in a sting\r\n- `regexp_like`: returns true\
+ \ match of a regular expression in a string\r\n- `regexp_like`: returns true\
\ if a regular expression has a match in a string.\r\n\r\n[https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP](https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP)"
- name: Return OLD and NEW values from modified rows
versions:
@@ -415,7 +415,7 @@ featurematrix:
versions:
'9.1': 'Yes'
description: Allows INSERT/UPDATE/DELETE in WITH clauses which can be used in
- conjunction with a RETURNING clause to to pass data up to the containing query.
+ conjunction with a RETURNING clause to pass data up to the containing query.
Data Definition Language (DDL):
- name: ALTER object IF EXISTS
versions:
@@ -506,7 +506,7 @@ featurematrix:
- name: Automatic plan invalidation
versions:
'8.3': 'Yes'
- description: automatic invalidation of cached exceutions plans
+ description: automatic invalidation of cached executions plans
- name: Background Checkpointer
versions:
'9.2': 'Yes'
@@ -537,8 +537,8 @@ featurematrix:
- name: CREATE STATISTICS - "OR" and "IN/ANY" statistics
versions:
'13': 'Yes'
- description: Extend statistics can help the query planner provided better plans
- for queries that have "OR".clauses as well as "IN/ANY" lookups over lists. For
+ description: Extended statistics can help the query planner generate better plans
+ for queries that have "OR" clauses as well as "IN/ANY" lookups over lists. For
more information, please see https://www.postgresql.org/docs/13/planner-stats.html#PLANNER-STATS-EXTENDED
- name: Cross datatype hashing support
versions:
@@ -657,7 +657,7 @@ featurematrix:
- name: Parallel FULL and RIGHT joins
versions:
'16': 'Yes'
- description: Ability to execute in parallell `FULL` and `RIGHT OUTER` joins.
+ description: Ability to execute in parallel `FULL` and `RIGHT OUTER` joins.
- name: Parallel full table scans (sequential scans)
versions:
'9.6': 'Yes'
@@ -755,7 +755,7 @@ featurematrix:
versions:
'9.3': 'Yes'
description: New operators and functions to extract values from JSON data strings,
- JSON data strings can now to be converted into records and new functions to
+ JSON data strings can now to be converted into records and new functions
convert values, records, and hstore data to JSON.
- name: JSONB data type
versions:
@@ -884,7 +884,7 @@ featurematrix:
'9.4': 'Yes'
description: Auto-updatable views can now specify whether an INSERT or UPDATE
would change the state of the row so that it would no longer be visible in the
- view. Using WITH CHECK OPTION will prevent any such changes from occuring.
+ view. Using WITH CHECK OPTION will prevent any such changes from occurring.
Replication:
- name: ALTER SUBSCRIPTION ... SKIP
versions:
@@ -973,7 +973,7 @@ featurematrix:
- name: Logical replication write conflict logging
versions:
'18': 'Yes'
- description: "Write conflicts that occur during ogical replication are\
+ description: "Write conflicts that occur during logical replication are\
\ reported both in logs and in the\
\ [`pg_stat_subscription_stats`](https://www.postgresql.org/docs/18/monitoring-stats.html#MONITORING-PG-STAT-SUBSCRIPTION-STATS)\
\ view."
@@ -992,7 +992,7 @@ featurematrix:
versions:
'9.3': 'Yes'
description: Cascading replication previously required that an xlog archive be
- available in order for a standbys of the new primary to correctly switch to
+ available in order for standbys of the new primary to correctly switch to
the new timeline. This change removes this dependency.
- name: Streaming Replication
versions:
@@ -1043,7 +1043,7 @@ featurematrix:
- name: Multiple synchronous standbys
versions:
'9.6': 'Yes'
- description: Ability to require synch messages from multiple prioritized standbys
+ description: Ability to require sync messages from multiple prioritized standbys
when committing a synchronous transaction.
- name: Named restore points
versions:
@@ -1265,7 +1265,7 @@ featurematrix:
- name: Native RADIUS authentication
versions:
'9.0': 'Yes'
- description: adds support for authentictaing against a RADIUS server
+ description: adds support for authenticating against a RADIUS server
- name: OAuth Authentication / Authorization
versions:
'18': 'Yes'
@@ -1288,7 +1288,7 @@ featurematrix:
- name: ROLES
versions:
'8.1': 'Yes'
- description: replaces user and group concept by a more generalizes role based
+ description: replaces user and group concept with a more generalized role based
concept
- name: Row-Level Security
versions:
@@ -1849,7 +1849,7 @@ featurematrix:
versions:
'8.1': 'Yes'
url: https://www.postgresql.org/docs/current/static/dblink.html
- - name: dblink asyncronous notification support
+ - name: dblink asynchronous notification support
versions:
'9.0': 'Yes'
description: Add the ability to retrieve asynchronous notifications using dblink
@@ -2092,7 +2092,7 @@ legacymap: # This maps old id based URLs to the new titles and will generate re
168: GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS
170: Per user/database server configuration settings
171: Unicode object support in PL/python
- 175: dblink asyncronous notification support
+ 175: dblink asynchronous notification support
176: Spinlock support for the SuperH hardware platform
178: WHEN clause for CREATE TRIGGER
179: Exclusion constraints
--
2.39.3 (Apple Git-146)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Typos in the featurematrix
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox