Hi,
In one of the latest Spacewalk-upgrades in the package of spacewalk-schema 2.10.17-1 the PostgreSQL-scripts are broken. In the file spacewalk-schema-2.10.16-to-spacewalk-schema-2.10.17/0001-modules-caches-performance.sql.postgresql there is a PostgreSQL-syntax-error that only works in Oracle. We changed it so it cleanly runs:
--ALTER TABLE RHNPACKAGEEVR
--ADD (MODULAR NUMBER DEFAULT 0 NOT NULL);
alter table rhnpackageevr add column modular int default 0 not null;
This is introduced with https://github.com/oracle/spacewalk/blob/6ed6fa792bb6032e84c4ba426a078096a975572a/schema/spacewalk/upgrade/spacewalk-schema-2.10.16-to-spacewalk-schema-2.10.17/0001-modules-caches-performance.sql.postgresql#L22
@laurence-rochfort-oracle can you have a look as you are mentioned in the commit?