Allow FDW extensions to support MERGE command via CustomScan

From: Önder Kalacı <onderkalaci(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Allow FDW extensions to support MERGE command via CustomScan
Date: 2024-12-12 09:28:22
Message-ID: CACawEhXGVpBqt=UK0grzZK_Bsdy6q2-EoGR6x5yAUz5UwpCjiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

Currently, it is not possible for any fdw extension to support Merge
command, as that's prohibited in the parser.

In this proposal, we allow extensions to support Merge command via
`CustomScan` node by moving the Merge support check from parser to planner.

For existing fdw, they don't have to change anything. I changed
postgres_fdw mostly for documentation purposes.

See the attached patch.

Thanks,
Onder KALACI

Attachment Content-Type Size
0001-Allow-FDW-extensions-to-support-MERGE-command-via-Cu.patch application/octet-stream 7.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2024-12-12 09:52:46 single_copy not needed in GatherPath
Previous Message Jeff Davis 2024-12-12 09:00:15 Add CASEFOLD() function.