Setting primary key [May 03]

Discord-Discussions
21

:man_raising_hand: wkw replied

like this

22

:man_raising_hand: Shard replied

image0
image0398×512 13 KB

23

:man_raising_hand: 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

:man_raising_hand: wkw replied

yes it should be fine

25

:man_raising_hand: wkw replied

can u please create an issue

26

:man_raising_hand: wkw replied

seems something wrong with postgres only

27

:man_raising_hand: Shard replied

Yeah sure.

28

:man_raising_hand: Shard replied

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

29

:man_raising_hand: 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

:man_raising_hand: wkw replied

i see

31

:man_raising_hand: Shard replied

image0

32

:man_raising_hand: Shard replied

image0

33

:person_tipping_hand: o1lab replied

Did you do a schema sync?

34

:man_raising_hand: Shard replied

no, how do I do that?

35

:man_raising_hand: wkw replied

<@310157751395287040> schema sync wont show the changes

36

:person_tipping_hand: o1lab replied

Bottom left.. team and settings.. then metadata

37

:man_raising_hand: 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

:man_raising_hand: wkw replied

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