v5.0.2

Shards

• pg0001 - [error] wrong volatility marking for json_strip_nulls and jsonb_strip_nulls
• pg0002 - [error] PUBLIC has CREATE on public schema (PG>=15)

v5.0.1

New checks

• pg0001 - [error] wrong volatility marking for json_strip_nulls and jsonb_strip_nulls
• pg0002 - [error] PUBLIC has CREATE on public schema (PG>=15)

v4.3.0

Added testing on PostgreSQL 18.

v4.2.2

Update Readme.

v4.2.1

New checks with shards and tests

• n1025 - [warning] confusion in name of constraint
• n1026 - [notice] unwanted characters in constraint name
• n1040 - [warning] schema name reserved keyword

Update check

• r1002 - [warning] relation without columns

v4.1.0

New checks with shards and tests

• n1030 - [warning] constraint name reserved keyword
• n1032 - [warning] index name reserved keyword
• n1034 - [warning] relation name reserved keyword
• n1036 - [warning] sequence name reserved keyword
• n1038 - [warning] attribute name reserved keyword

Shards and tests

• fk1010 - [warning] similar FK
• fk1011 - [warning] FK have common attributes
• s1010 - [critical] less 5% unused sequence values
• s1011 - [error] less 10% unused sequence values
• s1012 - [warning] less 20% unused sequence values

v4.0.1

Add version for checks.
Shards and tests

• fk1001 - [error] fk uses mismatched types
• fk1002 - [warning] fk uses nullable columns
• fk1007 - [notice] not involved in foreign keys
• r1001 - [warning] unlogged table
• s1001 - [warning] unlogged sequence

v3.3.4

Update check_sm0001, test for check sm0001.
Update Readme.

v3.3.2

Enabled GitHub actions for testing db_verifier.sql in PostgreSQL versions 12–17.
Added shards directory, in which checks are divided into separate files (file name corresponds to check code)

v3.3.0

conf_language_code = 'en'

Check list

• r1002 - [warning] relation without columns