Should I import the metadata ? after sync [Apr 05]

Discord-Discussions
1

:raising_hand_man: Kratos asked

Hey everyone

I’m using a Heroku PostgreSQL database for nocoDB and I have added around 5 tables. the tables work fine but I forgot to keep primary key for one table so then I connected to Heroku PostgreSQL on my pc and ran some sql commands to make one of the columns a primary key(i.e. alter table table_name … ). I can confirm that the column is a primary key(checked the table multiple times) but it does not update in nocoDB as a primary key.

I made only one of them as a primary key. The table had records before I kept it in nocoDB. I want to make it a primary key so I can edit/update the rows when im in nocoDB.

Metadata is synced and I also refreshed the tables and it has been 6 hours since I made it a primary key, should I import the metadata then? need help…

2

:person_tipping_hand: o1lab replied

not necessary

3

:person_tipping_hand: o1lab replied

if its all synced

4

:raising_hand_man: Kratos replied

No what im trying to say is that its not synced because in nocoDB the said column is not a primary key and I cant edit the table.

In reality the column is a primary key which I checked.

5

:person_tipping_hand: o1lab replied

ok, like all tables created in nocodb have a primary key - how was that missed ?

6

:person_tipping_hand: o1lab replied

may be you can take a screenshot and paste it here

7

:person_tipping_hand: o1lab replied

of what you are seeing in a db client and nocodb

8

:person_tipping_hand: o1lab replied

+ primary keys are not shown by default

you would have to hover on fields and click ‘show system fields’

9

:raising_hand_man: Kratos replied

image0
image01360×85 11.9 KB

10

:raising_hand_man: Kratos replied

I can screen share if you want

11

:raising_hand_man: Kratos replied

image0

12

:raising_hand_man: Kratos replied

you see how token is a primary key but on nocoDB it does not show it as a primary key

13

:raising_hand_man: Kratos replied

this is one of the other tables that has memberId as a primary key

image0

14

:raising_hand_man: Kratos replied

Okay I fixed this issue

15

:raising_hand_man: Kratos replied

You need to clear the metadata at the project list in the dashboard page and then open the project.

16

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs