In PostgreSQL 9.6 added the functionality of IF NOT EXISTS to the ADD COLUMN option of ALTER TABLE. Versions prior to 9.6 will fail the syntax check in addUserMgmtCore.sql because of the use of IF NOT EXISTS on the ALTER TABLE statements.
All uses of ADD COLUMN IF NOT EXISTS should be guarded prior to PostgreSQL version 9.6.
ADD COLUMN IF NOT EXISTS is presently only being used in addUserMgmtCore.sql.
In PostgreSQL 9.6 added the functionality of
IF NOT EXISTSto theADD COLUMNoption ofALTER TABLE. Versions prior to 9.6 will fail the syntax check inaddUserMgmtCore.sqlbecause of the use ofIF NOT EXISTSon theALTER TABLEstatements.All uses of
ADD COLUMN IF NOT EXISTSshould be guarded prior to PostgreSQL version 9.6.ADD COLUMN IF NOT EXISTSis presently only being used inaddUserMgmtCore.sql.