Setting primary key [May 03]

Discord-Discussions
21

:raising_hand_man: wkw replied

like this

22

:raising_hand_man: Shard replied

image0
image0398×512 13 KB

23

:raising_hand_man: Shard replied

can I use a db query to directly make an existing column into a PK? I mean will nocodb recognize the action if it is not done through it?

24

:raising_hand_man: wkw replied

yes it should be fine

25

:raising_hand_man: wkw replied

can u please create an issue

26

:raising_hand_man: wkw replied

seems something wrong with postgres only

27

:raising_hand_man: Shard replied

Yeah sure.

28

:raising_hand_man: Shard replied

nocodb doesn’t seem to recognize the PK set by query

29

:raising_hand_man: Shard replied

ALTER TABLE table_name ADD CONSTRAINT table_name_pkey PRIMARY KEY (name); adds the PK indicator in postgres, but nocodb doesn’t see any changes

30

:raising_hand_man: wkw replied

i see

31

:raising_hand_man: Shard replied

image0

32

:raising_hand_man: Shard replied

image0

33

:person_tipping_hand: o1lab replied

Did you do a schema sync?

34

:raising_hand_man: Shard replied

no, how do I do that?

35

:raising_hand_man: wkw replied

<@310157751395287040> schema sync wont show the changes

36

:person_tipping_hand: o1lab replied

Bottom left… team and settings… then metadata

37

:raising_hand_man: wkw replied

i just tried that

38

:person_tipping_hand: o1lab replied

Ahok, let’s have an issue with detay

39

:person_tipping_hand: o1lab replied

*details

40

:raising_hand_man: wkw replied

<@236180348386541570> please create two separate issues - we’ll take a look at them