Amy Detwiler
Postgres database configuration issues
While I have your attention: is there a reason why I would get a 500 error for my internal api calls?
Listening on http://[::]:8080
error: select distinct on ("f"."ticker") "fd".*, "f"."ticker", "f"."name", "f"."company", "f"."site", "f"."distribution_frequency", "f"."underlying",
(
) AS avg_all_time from "fund_distributions" as "fd" inner join "funds" as "f" on "fd"."fund_id" = "f"."id" where fd.next_declaration_date_on = (SELECT MAX(next_declaration_date_on) FROM fund_distributions WHERE fund_id = fd.fund_id) - relation "fund_distributions" does not exist
at Parser.parseErrorMessage (/app/.output/server/node_modules/pg-protocol/dist/parser.js:283:98)
at Parser.handlePacket (/app/.output/server/node_modules/pg-protocol/dist/parser.js:122:29)
at Parser.parse (/app/.output/server/node_modules/pg-protocol/dist/parser.js:35:38)
at Socket.<anonymous> (/app/.output/server/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:517:28)
at addChunk (node:internal/streams/readable:368:12)
at readableAddChunk (node:internal/streams/readable:341:9)
at Readable.push (node:internal/streams/readable:278:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
length: 119,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '2478',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1449',
routine: 'parserOpenTable'
}
14 replies