How to use `UsePostgreOnMergeSqlInsertOnConflictDoUpdate` correctly?

[ZzZombo]

I have these options:

{
	AutoMapOutputDirection                                         = true,
	IncludeGraph                                                             = true,
	IncludeGraphOperationBuilder                                 = <...>,
	InsertKeepIdentity                                                     = true,
	UsePostgreOnMergeSqlInsertOnConflictDoUpdate = true,
}

And I get the following error when trying to perform a bulk merge on my Postgres DB:

Oops! the ``UsePostgreOnMergeSqlInsertOnConflictDoUpdate`` option cannot be used when there is no column to insert or column values to output. I do not understand what does it want me to do. The docs only talk about what it does, and only show to set it to true to make it work.

[JonathanMagnan]

Hello @ZzZombo,

We are currently looking at the error message, as it is indeed very confusing.

The option UsePostgreOnMergeSqlInsertOnConflictDoUpdate is not compatible when there are column values to output, as no SQL syntax allows us to safely retrieve those inserted values.

Since you have AutoMapOutputDirection = true, this is most likely why it is not working in your case.

Let me know if that makes it clearer.

Best Regards,

Jon

[ZzZombo]

I removed that line already, but it still doesn't work.