On Fri, Oct 14, 2022 at 10:59 AM bt22nakamorit < bt22nakamo...@oss.nttdata.com> wrote:
> Hi, > > MERGE command does not accept foreign tables as targets. > When a foreign table is specified as a target, it shows error messages > like this: > > -- ERROR: cannot execute MERGE on relation "child1" > -- DETAIL: This operation is not supported for foreign tables. > > However, when a partitioned table includes foreign tables as partitions > and MERGE is executed on the partitioned table, following error message > shows. > > -- ERROR: unexpected operation: 5 > > The latter error message is unclear, and should be the same as the > former one. > The attached patch adds the code to display error the former error > messages in the latter case. > Any thoughts? +1. The new message is an improvement to the default one. I wonder if we can provide more details in the error message, such as foreign table name. Thanks Richard
