Linked server and promotion of distributed transaction

Background - Main server is Microsoft SQL Server 2019 and linked server is PostgreSQL 15. Main reason for the linking is the duplication of records. All other DML operations are good from SQL Server to Postgres. Enable Promotion of Distributed Transaction is **False**. (EXEC master.dbo.sp_serveroption @server=..., @optname=N'remote proc transaction promotion', @optvalue=N'false') But all operations in SQL Server **trigger** throw error: >OLE DB provider "MSDASQL" for linked server "POSTGRESQL" was unable to begin a distributed transaction ...although promotion is set to *false*. Why does SQL Server continue to promote this transaction despite the option?