Query failed : {
durationMs: 206.6232370000016,
error: PostgresError: function ll_to_earth_public(double precision, double precision) does not exist
at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:524:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
severity_local: 'ERROR',
severity: 'ERROR',
code: '42883',
hint: 'No function matches the given name and argument types. You might need to add explicit type casts.',
position: '154',
file: 'parse_func.c',
line: '629',
routine: 'ParseFuncOrColumn'
},
sql: '\n' +
' CREATE INDEX IDX_geodata_gist_earthcoord_dfd40ce2_6b91_48f2_bc76_98e86fedfbfa\n' +
' ON geodata_places_tmp\n' +
' USING gist (ll_to_earth_public(latitude, longitude))\n' +
' WITH (fillfactor = 100)\n' +
' ',
params: []
}
Query failed : {
durationMs: 206.6232370000016,
error: PostgresError: function ll_to_earth_public(double precision, double precision) does not exist
at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:524:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
severity_local: 'ERROR',
severity: 'ERROR',
code: '42883',
hint: 'No function matches the given name and argument types. You might need to add explicit type casts.',
position: '154',
file: 'parse_func.c',
line: '629',
routine: 'ParseFuncOrColumn'
},
sql: '\n' +
' CREATE INDEX IDX_geodata_gist_earthcoord_dfd40ce2_6b91_48f2_bc76_98e86fedfbfa\n' +
' ON geodata_places_tmp\n' +
' USING gist (ll_to_earth_public(latitude, longitude))\n' +
' WITH (fillfactor = 100)\n' +
' ',
params: []
}