Description of problem:
ll schema/satellite/upgrade/satellite-schema-5.7.0.27-to-satellite-schema-5.7.0.32/*postgres

-rw-rw-r--. 1 tkasparek tkasparek 24904 Oct 11 08:45 ../satellite-schema-5.7.0.27-to-satellite-schema-5.7.0.32/001-rhn_server-snapshot_server_deadlock.sql.postgres

001-rhn_server-snapshot_server_deadlock.sql.postgres file is not added to the upgrade script as it does not macth *postgresql (missing l at the end)

which causes following schema diff:
--- procedure_rhn_server_snapshot_server_server_id_in_numeric_reason_in_character_varying_returns_void.1        2017-10-11 08:23:12.682066002 +0200
+++ procedure_rhn_server_snapshot_server_server_id_in_numeric_reason_in_character_varying_returns_void.2        2017-10-11 08:23:12.682066002 +0200
@@ -22,6 +22,7 @@
                        and cf.id = lookup_first_matching_cf(scc.server_id, cfn.path);
        locked integer;
     begin
-        perform lock_counts(server_id_in);
        select nextval('rhn_snapshot_id_seq') into snapshot_id_v;
 
        insert into rhnSnapshot (id, org_id, server_id, reason) (


Version-Release number of selected component (if applicable):
satellite-schema-5.7.0.32-1.el6sat.noarch

How reproducible:
always

Steps to Reproduce:
1. upgrade 5.7 to satellite-schema-5.7.0.32
2. spacewalk-sql -i <<< '\df+ rhn_server.snapshot_server'

Actual results:
lock_counts call is missing in rhn_server.snapshot_server

Expected results:
it's there

Additional info:
oracle works fine