Horton

Fix information schema for catalogued not-null constraints

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: a0a5e0feb35c1209e340046dc4e40af3b0e79d59
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2023-09-18T06:10:51Z
Releases: 17.0 
Fix information schema for catalogued not-null constraints

The column check_constraints.check_clause should be like

    col IS NOT NULL

without a surrounding CHECK (...).

Discussion: https://www.postgresql.org/message-id/09489196-0bc1-e796-c43e-63425f7c5910@eisentraut.org

Files

PathChange+/−
src/backend/catalog/information_schema.sql modified +1 −1
src/include/catalog/catversion.h modified +1 −1

Discussion