PostgreSQL "Maybe not supported" in status report

Created on 19 October 2022, almost 3 years ago
Updated 20 January 2023, over 2 years ago

Problem/Motivation

This module adds a warning to the Drupal status report page (/admin/reports/status) if the site is running on PostgreSQL:

JSON Field database compatibility
Maybe not supported.
Verify if your database supports the JSON data type so the json_field module can work properly.

This has been observed on PostgreSQL 11.

The expectation is that this message will not appear on PostgreSQL version 9.2 or greater: https://git.drupalcode.org/project/json_field/-/blob/56224dc60ef544138ab...

It seems that the problem is an expectation that SELECT VERSION() will return a simple numeric value. But in PostgreSQL more information is included:

=> SELECT VERSION();                                                                                          
                                                     version                                                      
------------------------------------------------------------------------------------------------------------------
 PostgreSQL 11.17 (Debian 11.17-0+deb10u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
(1 row)

Steps to reproduce

  1. Install the module on a Drupal instance running on a PostgreSQL database.
  2. Look at the Drupal Status Report, observe the warning.

Proposed resolution

TBD...

Remaining tasks

TBD...

User interface changes

Remove warning from Drupal Status Report on PostgreSQL installations greater than version 9.2.

API changes

None.

Data model changes

None.

πŸ› Bug report
Status

Fixed

Version

1.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States m.stenta

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

No activities found.

Production build 0.71.5 2024