@memberjunction/connector-path-lms@1.1.0
Minor Changes
-
fe75578: Fix the PostgreSQL seed migration so
mj app installsucceeds on PostgreSQL.The 1.0.0 PostgreSQL migration (
migrations-pg/*.pg.sql) was generated with a stale SS→PG converter (CLI 5.36, which predates the boolean SP-argument coercion shipped in 5.40.x). It emitted the integration-catalogspCreate*calls with integer_Clearflags (p_<col>_Clear := 1) againstBOOLEANparameters. Because PostgreSQL resolves function overloads by exact argument type and has no implicitinteger → booleancast for a named argument, every such call aborted on apply with:ERROR: function __mj.spCreateIntegrationObject(... p_<col>_clear => integer ...) does not existRegenerated each
.pg.sqlwith CLI 5.43.0, which emits native:= TRUE/:= FALSE. The same regeneration also corrects a second 5.36 defect: identifier-quoting (."Configuration") leaking into string literals inside seeded descriptions andConfigurationJSON.SQL Server migrations (
migrations/*.sql) are unchanged — this is a PostgreSQL-only fix.