Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when run setup #204

Open
cladikzone opened this issue Jun 17, 2020 · 2 comments
Open

Error when run setup #204

cladikzone opened this issue Jun 17, 2020 · 2 comments

Comments

@cladikzone
Copy link

When I run $ yarn run setup. this error comes

query failed: SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "cnst"."conname" AS "constraint_name", "cnst"."consrc" AS "expression", CASE "cnst"."contype" WHEN 'p' THEN 'PRIMARY' WHEN 'u' THEN 'UNIQUE' WHEN 'c' THEN 'CHECK' END AS "constraint_type", "a"."attname" AS "column_name" FROM "pg_constraint" "cnst" INNER JOIN "pg_class" "t" ON "t"."oid" = "cnst"."conrelid" INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "cnst"."connamespace" INNER JOIN "pg_attribute" "a" ON "a"."attrelid" = "cnst"."conrelid" AND "a"."attnum" = ANY ("cnst"."conkey") WHERE "t"."relkind" = 'r' AND (("ns"."nspname" = 'public' AND "t"."relname" = 'pet')) error: { error: column cnst.consrc does not exist at Connection.parseE (/home/asus/Documents/projects/efilling/node_modules/pg/lib/connection.js:554:11) at Connection.parseMessage (/home/asus/Documents/projects/efilling/node_modules/pg/lib/connection.js:379:19) at Socket.<anonymous> (/home/asus/Documents/projects/efilling/node_modules/pg/lib/connection.js:119:22) at Socket.emit (events.js:198:13) at Socket.EventEmitter.emit (domain.js:448:20) at addChunk (_stream_readable.js:288:12) at readableAddChunk (_stream_readable.js:269:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) name: 'error', length: 196, severity: 'ERROR', code: '42703', detail: undefined, hint: 'Perhaps you meant to reference the column "cnst.conkey" or the column "cnst.conbin".', position: '112', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '3369', routine: 'errorMissingColumn' }
How can I solve this ?

@tongrow
Copy link

tongrow commented Jun 21, 2020

How can I solve this ?

Try downgrade postgresql to 11.8

@underscorekadji
Copy link

How can I solve this ?

Perhaps no longer relevant for you, but for other: update typeorm - typeorm/typeorm#4332 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants