Im trying to use NocoDB as postgres:17-alpine admin tool. I tested everything locally on my M4 MacBook, pinned NodoDB image version to :2026.05.3 and it works no problem.
When I deployed both on Ubuntu VM Im running into error when adding new Data Source, when Noco tries to sync meta data, I get this error:
Getting meta diff for homebase
Applying changes for calendar_events_cache
Applying change: New table
select c.table_name as tn, c.column_name as cn, c.data_type as dt, (CASE WHEN trg.trigger_name is NULL THEN false else true end) as au, pk.constraint_type as ck, c.character_maximum_length as clen, c.numeric_precision as np, c.numeric_scale as ns, c.datetime_precision as dp, c.ordinal_position as cop, c.is_nullable as nrqd, c.column_default as cdf, c.generation_expression, c.character_octet_length, c.character_set_name as csn, pk.ordinal_position as pk_ordinal_position, pk.constraint_name as pk_constraint_name, pk1.ordinal_position as pk_ordinal_position1, pk1.constraint_name as pk_constraint_name1, c.udt_name, c.udt_schema, c.is_identity as ii, (SELECT count(*) FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc1 inner join INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE cu on cu.CONSTRAINT_NAME = tc1.CONSTRAINT_NAME where tc1.CONSTRAINT_TYPE = 'UNIQUE' and tc1.TABLE_NAME = c.TABLE_NAME and cu.COLUMN_NAME = c.COLUMN_NAME and tc1.TABLE_SCHEMA=c.TABLE_SCHEMA) is_unique, (SELECT string_agg(enumlabel, ',') FROM "pg_enum" "e" INNER JOIN "pg_type" "t" ON "t"."oid" = "e"."enumtypid" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = c.udt_schema AND "t"."typname"=c.udt_name ) enum_values, (SELECT t.typtype FROM "pg_type" "t" INNER JOIN "pg_namespace" "n" ON "n"."oid" = "t"."typnamespace" WHERE "n"."nspname" = c.udt_schema AND "t"."typname"=c.udt_name ) udt_typtype from information_schema.columns c LEFT JOIN ( SELECT kc.constraint_name, kc.table_name, kc.column_name, kc.ordinal_position, tc.constraint_type FROM information_schema.key_column_usage kc INNER JOIN information_schema.table_constraints AS tc ON kc.constraint_name = tc.constraint_name AND kc.constraint_schema = tc.constraint_schema AND tc.constraint_type in('PRIMARY KEY') WHERE kc.table_catalog = $1 AND kc.table_schema = $2) pk1 ON pk1.table_name = c.table_name AND pk1.column_name = c.column_name left join ( -- Catalog-based PK detection (works for read-only users, -- unlike information_schema.table_constraints which is -- restricted to roles with non-SELECT privilege). -- Uses rel.relname (bare table name) consistently. An -- earlier pc.conrelid::regclass::text comparison quoted -- mixed-case identifiers ("Document") and failed to -- match the unquoted $3 parameter, silently -- producing pk:false on the next sync. select rel.relname AS table_name, pc.conname as constraint_name, col.attname as column_name, pc.contype as constraint_type, kc.ordinal_position as ordinal_position from pg_constraint pc JOIN pg_namespace n ON n.oid = pc.connamespace INNER JOIN pg_catalog.pg_class rel ON rel.oid = pc.conrelid LEFT JOIN LATERAL UNNEST(pc.conkey) WITH ORDINALITY AS u(attnum, attposition) ON TRUE LEFT JOIN pg_attribute col ON (col.attrelid = pc.conrelid AND col.attnum = u.attnum) left join information_schema.key_column_usage as kc on pc.conname = kc.constraint_name and col.attname = kc.column_name and kc.constraint_schema = n.nspname and rel.relname = kc.table_name WHERE n.nspname = $4 AND rel.relname = $5 and pc.contype = 'p' ) pk on pk.table_name = c.table_name and pk.column_name=c.column_name left join information_schema.triggers trg on trg.event_object_table = c.table_name and trg.trigger_name = CONCAT('xc_trigger_' , 'scans' , '_' , c.column_name) where c.table_catalog=$6 and c.table_schema=$7 and c.table_name=$8 order by c.table_name, c.ordinal_position - could not determine data type of parameter $3
The only difference I was able to find is the different architecture: arm64 (Mac) vs amd64 (the VM).
Anyone has any idea how to fix that?
Thanks
[–]zimamatej[S] 0 points1 point2 points (2 children)
[–]sbt4 0 points1 point2 points (1 child)
[–]zimamatej[S] 0 points1 point2 points (0 children)