Excel add-in with updateable views

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
drobert
Posts: 1
Joined: Sun 19 Jan 2020 23:22

Excel add-in with updateable views

Post by drobert » 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

dm-m
Devart Team
Posts: 9
Joined: Tue 06 Aug 2019 07:43

Re: Excel add-in with updateable views

Post by dm-m » Tue 21 Jan 2020 13:16

Hello,

Thank you for submitting a ticket with us.

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

Post Reply