Excel add-in with updateable views
Posted: Sun 19 Jan 2020 23:39
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
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