Search Results for: WAITING FOR POSTGRESQL 10

Waiting for PostgreSQL 16 – Add grantable MAINTAIN privilege and pg_maintain role.

On 14th of December 2022, Jeff Davis committed patch: Add grantable MAINTAIN privilege and pg_maintain role.   Allows VACUUM, ANALYZE, REINDEX, REFRESH MATERIALIZED VIEW, CLUSTER, and LOCK TABLE.   Effectively reverts 4441fc704d. Instead of creating separate privileges for VACUUM, ANALYZE, and other maintenance commands, group them together under a single MAINTAIN privilege.   Author: Nathan … Continue reading “Waiting for PostgreSQL 16 – Add grantable MAINTAIN privilege and pg_maintain role.”

Waiting for PostgreSQL 16 – Add test scaffolding for soft error reporting from input functions.

Title: On 9th of December 2022, Tom Lane committed patch: Add test scaffolding for soft error reporting from input functions.   pg_input_is_valid() returns boolean, while pg_input_error_message() returns the primary error message if the input is bad, or NULL if the input is OK. The main reason for having two functions is so that we can … Continue reading “Waiting for PostgreSQL 16 – Add test scaffolding for soft error reporting from input functions.”

Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conf

On 24th of October 2022, Michael Paquier committed patch: Add support for regexps on database and user entries in pg_hba.conf   As of this commit, any database or user entry beginning with a slash (/) is considered as a regular expression. This is particularly useful for users, as now there is no clean way to … Continue reading “Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conf”

Waiting for PostgreSQL 15 – JSON_TABLE

On 4th of April 2022, Andrew Dunstan committed patch: JSON_TABLE   This feature allows jsonb data to be treated as a table and thus used in a FROM clause like other tabular data. Data can be selected from the jsonb using jsonpath expressions, and hoisted out of nested structures in the jsonb to form multiple … Continue reading “Waiting for PostgreSQL 15 – JSON_TABLE”

Waiting for PostgreSQL 15 – Add support for MERGE SQL command

On 28th of March 2022, Alvaro Herrera committed patch: Add support for MERGE SQL command   MERGE performs actions that modify rows in the target table using a source table or query. MERGE provides a single SQL statement that can conditionally INSERT/UPDATE/DELETE rows — a task that would otherwise require multiple PL statements. For example, … Continue reading “Waiting for PostgreSQL 15 – Add support for MERGE SQL command”

Waiting for PostgreSQL 15 – Add support for security invoker views.

On 22nd of March 2022, Dean Rasheed committed patch: Add support for security invoker views.   A security invoker view checks permissions for accessing its underlying base relations using the privileges of the user of the view, rather than the privileges of the view owner. Additionally, if any of the base relations are tables with … Continue reading “Waiting for PostgreSQL 15 – Add support for security invoker views.”

Waiting for PostgreSQL 15 – Allow archiving via loadable modules.

On 3rd of February 2022, Robert Haas committed patch: Allow archiving via loadable modules.   Running a shell command for each file to be archived has a lot of overhead and may not offer as much error checking as you want, or the exact semantics that you want. So, offer the option to call a … Continue reading “Waiting for PostgreSQL 15 – Allow archiving via loadable modules.”

Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog

On 17th of January 2022, Michael Paquier committed patch: Introduce log_destination=jsonlog   "jsonlog" is a new value that can be added to log_destination to provide logs in the JSON format, with its output written to a file, making it the third type of destination of this kind, after "stderr" and "csvlog". The format is convenient … Continue reading “Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog”

Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.

On 3rd of August 2021, Tom Lane committed patch: Add assorted new regexp_xxx SQL functions.   This patch adds new functions regexp_count(), regexp_instr(), regexp_like(), and regexp_substr(), and extends regexp_replace() with some new optional arguments. All these functions follow the definitions used in Oracle, although there are small differences in the regexp language due to using … Continue reading “Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.”

Waiting for PostgreSQL 15 – Allow publishing the tables of schema.

On 27th of October 2021, Amit Kapila committed patch: Allow publishing the tables of schema.   A new option "FOR ALL TABLES IN SCHEMA" in Create/Alter Publication allows one or more schemas to be specified, whose tables are selected by the publisher for sending the data to the subscriber.   The new syntax allows specifying … Continue reading “Waiting for PostgreSQL 15 – Allow publishing the tables of schema.”