Adding a comment to addConstraint for a table in a schema fails

[osdiab]

This command:

  pgm.addConstraint({schema: "payroll_reports", name: "upload_headers"}, "chk_only_one_header_type", {
    check: [
      `(
      CASE WHEN paycode_type IS NOT NULL THEN 1 ELSE 0 END +
      CASE WHEN aggregate_paycode_type IS NOT NULL THEN 1 ELSE 0 END +
      CASE WHEN meta_field_type IS NOT NULL THEN 1 ELSE 0 END +
      CASE WHEN is_remark THEN 1 ELSE 0 END
     ) <= 1`,
    ],
    comment:
      "If no type present/truthy, it's ignored; cannot have more than one active at once",
  });

fails with this error:

Error executing:
ALTER TABLE "payroll_reports"."upload_headers"
  ADD CONSTRAINT "chk_only_one_header_type" CHECK ((       CASE WHEN paycode_type IS NOT NULL THEN 1 ELSE 0 END +       CASE WHEN aggregate_paycode_type IS NOT NULL THEN 1 ELSE 0 END +       CASE WHEN meta_field_type IS NOT NULL THEN 1 ELSE 0 END +       CASE WHEN is_remark THEN 1 ELSE 0 END      ) <= 1);
COMMENT ON CONSTRAINT "chk_only_one_header_type" ON "upload_headers" IS $pga$If no type present/truthy, it's ignored; cannot have more than one active at once$pga$;
error: relation "upload_headers" does not exist

> Rolling back attempted migration ...
error: relation "upload_headers" does not exist

This doesn't fail when you remove the comment field. Looks like it's failing to prepend the schema name when applying the comment.

[osdiab]

this probably is happenign because the relevant constraint function first strips out the name and then passes that directly to the makeComment() function:

node-pg-migrate/src/operations/tables.ts

Line 180 in 9331f6f

const tableName = typeof table === 'object' ? table.name : table