Deparser does not handle MergeWhenClause

import { parse, deparse } from 'pgsql-parser';

const sql = `MERGE INTO t AS target
  USING (SELECT 1 AS id) AS source ON target.id = source.id
  WHEN MATCHED THEN UPDATE SET name = 'x'
  WHEN NOT MATCHED THEN INSERT (id, name) VALUES (source.id, 'x')`;

const ast = parse(sql);   // succeeds
deparse(ast);              // throws: does not handle node type: MergeWhenClause

The parser handles MERGE (added in PostgreSQL 15) but the deparser has no visitor for MergeWhenClause. Tested on pgsql-deparser@17.18.2.

Merge pull request #352 from constructive-io/fix/deparser-issues-292-…

@ivanbulanov

thanks @ivanbulanov for reporting this! A fix is coming up

thanks again!

#352 (comment)

Successfully published:
 - @pgsql/cli@18.2.7
 - @pgsql/lint@18.2.7
 - @pgsql/scripts@18.4.7
 - @pgsql/semantics@18.1.8
 - @pgsql/transform@18.17.7
 - @pgsql/transform-ast@18.4.9
 - @pgsql/traverse@18.7.9
 - @pgsql/utils@18.2.9
 - pgsql-deparser@18.3.7
 - pgsql-parse@18.2.7
 - pgsql-parser@18.2.7
 - pgsql-types@18.2.9
 - plpgsql-deparser@18.2.9
 - plpgsql-parse@18.2.9
 - plpgsql-parser@18.5.9

Navigation Menu

Repository navigation

Deparser does not handle MergeWhenClause #292

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Deparser does not handle MergeWhenClause #292

Description

Activity

pyramation commented on Sep 17, 2026

pyramation commented on Sep 17, 2026

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions