Primary keys aren't unique [Mar 15]

Discord-Discussions
1

:raising_hand_man: Akshay asked

Primary keys aren’t unique.

I’ve set a particular column in my table as primary key and I am able to create multiple values with the same text in it. What am I missing?

2

:raising_hand_man: wkw replied

please create an issue on github n share the details

3

:raising_hand_man: Akshay replied

Thank you! Also is there a way we could add additional constraints to the table. For example make a column unique. I could do it directly via SQL but was wondering if there could be side-effects? What’s the recommended way to do this?

4

:raising_hand_man: wkw replied

Currently it’s not supported to do it in GUI. but it works fine if you set it via SQL.

5

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs