Devart Forums

I am having the same problem with PostgreSQL.

OS: Windows 10 Pro 21H1 19043.1526
DB: PostgreSQL 14
Excel: Excel for Microsoft 365 MSO (version 2201 Build 16.0.14827.20186) 64 bit
Devart Excel Add-in: Version 2.6.791.0 (.NET 4.7)

In PostgreSQL there is no way I know of to create a unique identifiers in views.
Only tables can have unique indexes or primary keys.

I created a table with a column named "id" that is type integer and is a primary key. I created a view of that table.
I use Devart Excel Add-in to link the database view to an excel spreadsheet. When I enter into edit mode I get:

"Table does not have columns that uniquely identify rows (primary key or non-nullable unique index columns). Data modifications may be applied incorrectly or may be not applied."

How can I specify that the column "id" is a primary key to Devart Excel Add-In ?

Thank you,

-Mark