Excel add-in with updateable views

[drobert]

Postgres 9.6
Devart 2.2.283.0
MS Excel: Office 365 version 1912

Hello,

We're using the EXCEL add-in for postgres. Because of the complexity of the database, we have an updateable view to make it easy for user to edit. However, Devart is not working with this and giving the message “Table does not have columns that uniquely identify rows (primary key or non-nullable index columns)…”

There are columns that form a logic primary key, but a view cannot have an index in postgres. Is there a way I can tell Devart what the ‘unique index’ fields are?

Thanks in advance

[dm-m]

Hello,

Thank you for submitting a ticket with us.

We have replied to your email. Please check the inbox.