Setting primary key [May 03]

[NocoDB]

[dummy title body text appended to avoid empty title body]

[NocoDB]

wkw replied

are u saying if set the primary key when creating the column but it shows not PK after the creation?

[NocoDB]

Shard replied

I deleted the Id column and now my table has no PK and nocodb wont let me edit the table

[NocoDB]

Shard replied

Now I want to make another column into PK but apparently “Set as Primary value” doesn’t do it

[NocoDB]

wkw replied

u need to create a column with PK ticked

[NocoDB]

wkw replied

like i said before, primary value is different than primary key

[NocoDB]

wkw replied

see the screenshot i sent

[NocoDB]

Shard replied

I get an error when I try to create a new column with PK ticked: multiple primary keys for table "table_name" are not allowed

[NocoDB]

Shard replied

I dropped the existing PK with postgres query, but creating a new column with PK ticked still doesn’t work. Tells me: column "name" of relation "table_name" contains null values

[NocoDB]

wkw replied

did u hv records?

[NocoDB]

Shard replied

What do you mean?

[NocoDB]

wkw replied

i just tried it n it works fine

[NocoDB]

wkw replied

does your table contain some records before u create new PK

[NocoDB]

Shard replied

Yes it is an existing table

[NocoDB]

wkw replied

then u may feed the default value

[NocoDB]

wkw replied

try sth like this

[NocoDB]

wkw replied

tick NN to mark it not null

tick PK to make it Primary key

add default value to make existing records to hv a PK value

[NocoDB]

wkw replied

then u can change it afterwards

[NocoDB]

Shard replied

Getting this: ALTER TABLE "table_name" ADD "name" character varying NOT NULL DEFAULT placeholder;;alter TABLE "table_name" add constraint "table_name_pkey" PRIMARY KEY("name"); - cannot use column reference in DEFAULT expression

[NocoDB]

wkw replied

can u screencap your input like i did