[Bug]: postgres comments failures

[jaredchurch]

Overview

I am unable to successfully build dbt_artifacts in my environment (dbt fusion with postgresql).

How to reproduce

• Initialise new project
• update dbt_packages.yml
• run dbt deps
• run dbt run --models dbt_artifacts

I have tracked this down to ';' character used in dbt_packages/dbt_artifacts/models/docs.md
There are two cases where the ';' character is used. If I remove the ';' then it is working as expected, i.e. build with no error.

(feature/dbt-fusion) $ grep ';' dbt_packages/dbt_artifacts/models/docs.md
Exposure type; one of dashboard, notebook, analysis, ml, application (used to organize on docs site)
Exposure maturity; one of high, medium, low.

Expected behaviour

successful build.

Screenshots

> dbt run --models dbt_artifacts

  Failed to prepare query: ERROR:  unterminated dollar-quoted string at or near "$dbt_comment_literal_block$Exposure type"
  LINE 6: ...h_test_dbt_artifacts_sources"."exposures".type is $dbt_comme...
                                                               ^
  
  Query was:/* {"app": "dbt", "dbt_version": "2.0.0", "invocation_id": "019e2b2e-6190-76e3-8441-7886440bb64b", "node_id": "model.dbt_artifacts.exposures", "profile_name": "default", "target_name": "dev"} */
  
    
      
      
      comment on column "dev"."dwh_test_dbt_artifacts_sources"."exposures".type is $dbt_comment_literal_block$Exposure type
  (in compiled/dbt_artifacts/dbt_packages/dbt_artifacts/models/sources/exposures.sql:1:4)

Environment

Results of running dbt --version:

dbt-fusion 2.0.0-preview.175

Please paste the contents of your packages.yml file here:

packages:
  - package: dbt-labs/dbt_utils
    version: 1.3.3
  - package: brooklyn-data/dbt_artifacts

### End of File

[jaredchurch]

I have upgraded to latest postgres version and confirm that same error occurs:

PostgreSQL 18.4 (Debian 18.4-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit