Commita0a5e0f

committed

Fix information schema for catalogued not-null constraints

The column check_constraints.check_clause should be like col IS NOT NULLwithout a surrounding CHECK (...).Discussion:https://www.postgresql.org/message-id/09489196-0bc1-e796-c43e-63425f7c5910@eisentraut.org

1 parent9d17e5f commita0a5e0fCopy full SHA for a0a5e0f

File tree

-2

lines changed

src
- backend/catalog
  - information_schema.sql
- include/catalog
  - catversion.h

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -449,7 +449,7 @@ CREATE VIEW check_constraints AS`
`449`	`449`	`SELECT current_database()::information_schema.sql_identifierAS constraint_catalog,`
`450`	`450`	`rs.nspname::information_schema.sql_identifierAS constraint_schema,`
`451`	`451`	`con.conname::information_schema.sql_identifierAS constraint_name,`
`452`		`-pg_catalog.format('CHECK (%s IS NOT NULL)',at.attname)::information_schema.character_dataAS check_clause`
	`452`	`+pg_catalog.format('%s IS NOT NULL',at.attname)::information_schema.character_dataAS check_clause`
`453`	`453`	`FROM pg_constraint con`
`454`	`454`	`LEFT JOIN pg_namespace rsONrs.oid=con.connamespace`
`455`	`455`	`LEFT JOIN pg_class cONc.oid=con.conrelid`

Lines changed: 1 addition & 1 deletion

Comments

(0)