Multiple pk error nocodb [May 28]

Discord-Discussions
1

:raising_hand_man: Canx asked

Hello! Newbie here, just discovered NocoDB and is great! I’m having problems doing a REST query with composite primary key (using “PK1___PK2” syntax in rowId parameter). My database is Postgres and column type is bigint. Response SQL says “invalid input syntax for type bigint”: https://www.youtube.com/watch?v=WYCkA5Kp0FI Any advice? Thanks!

2

:raising_hand_man: Canx replied

Still haven’t found solution for this… Somehow seems that nocodb does not detect that table has composite primary key. Just pasting SQL table definition if someone has any hint: "CREATE TABLE IF NOT EXISTS public.nc_u10l__sesiones

(

created_at timestamp without time zone DEFAULT now(),

updated_at timestamp without time zone DEFAULT now(),

fecha character varying COLLATE pg_catalog.“default”,

“diaSemana” character varying COLLATE pg_catalog.“default”,

“horaDesde” character varying COLLATE pg_catalog.“default”,

“horaHasta” character varying COLLATE pg_catalog.“default”,

“asignaturaNombre” character varying COLLATE pg_catalog.“default”,

nombre character varying COLLATE pg_catalog.“default”,

curso character varying COLLATE pg_catalog.“default”,

car character varying COLLATE pg_catalog.“default”,

“sessionId” bigint NOT NULL,

“horarioId” bigint NOT NULL,

CONSTRAINT nc_u10l__sesiones_pkey PRIMARY KEY (“sessionId”, “horarioId”)

)"

3

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs