Redshift's REMOVE DUPLICATES not available on MERGE INTO

[xmariachi]

Using pyscopg 2.9.5.
Redshift introduced the MERGE syntax just recently (April 2023).
Question - Is it supported at all ?

It has two optional clauses:

• WHEN MATCHED ... WHEN NOT MATCHED
• REMOVE DUPLICATES

I am able to use the former sql syntax, but the latter does not seem to be supported:

psycopg2.errors.SyntaxError: syntax error at or near "REMOVE"

The tables are identical.
Query run:

 MERGE INTO a
  USING b
  ON a.id = b.id
  REMOVE DUPLICATES;

Thanks.

[dvarrazzo]

The error comes from the server. Psycopg just send the commands to the server, it doesn't give them any meaning. So you have a genuine error in your sql.

[xmariachi]

Hmmm I see.... I will review, thank you