NikolayS / postgres_dba

The missing set of useful tools for Postgres DBAs and all engineers
BSD 3-Clause "New" or "Revised" License
1.1k stars 113 forks source link

CircleCI tests refactoring. Support Postgres 12 #44

Closed NikolayS closed 4 years ago

NikolayS commented 4 years ago

Issue: https://github.com/NikolayS/postgres_dba/issues/43

PostgreSQL 12 errors fixed

Two errors fixed, in b1 and in p1:

psql:/var/lib/pgsql/postgres_dba/sql/b1_table_estimation.sql:99: ERROR:  column tbl.relhasoids does not exist
LINE 19:       + case when tbl.relhasoids then 4 else 0 end as tpl_hd...

psql:/root/postgres_dba/sql/p1_alignment_padding.sql:197: ERROR:  recursive query "analyze_alignment" column 13 has collation "default" in non-recursive term but collation "C" overall
LINE 68:     null::text as prev_column_name,
             ^
HINT:  Use the COLLATE clause to set the collation of the non-recursive term.