On 14.09.23 10:20, Peter Eisentraut wrote:
> On 06.09.23 19:52, Alvaro Herrera wrote:
>> + SELECT current_database()::information_schema.sql_identifier AS
>> constraint_catalog,
>> + rs.nspname::information_schema.sql_identifier AS
>> constraint_schema,
>> + con.conname::information_schema.sql_identifier AS
>> constraint_name,
>> + format('CHECK (%s IS NOT NULL)',
>> at.attname)::information_schema.character_data AS check_clause
>
> Small correction here: This should be
>
> pg_catalog.format('%s IS NOT NULL',
> at.attname)::information_schema.character_data AS check_clause
>
> That is, the word "CHECK" and the parentheses should not be part of the
> produced value.
I have committed this fix.