Skip to content

Instantly share code, notes, and snippets.

@sebastianbachmann
Created August 17, 2022 10:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sebastianbachmann/5f957baae2a8f76741be104a30a4d0b5 to your computer and use it in GitHub Desktop.
Save sebastianbachmann/5f957baae2a8f76741be104a30a4d0b5 to your computer and use it in GitHub Desktop.
npx directus start error message
12:22:57 ⚠️ PUBLIC_URL should be a full URL
error: WITH geometries as (
select * from geometry_columns
union
select * from geography_columns
)
SELECT f_table_name as table_name
, f_geometry_column as column_name
, type as data_type
FROM geometries g
JOIN information_schema.tables t
ON g.f_table_name = t.table_name
AND t.table_type = 'BASE TABLE'
WHERE f_table_schema in ($1)
- relation "geometry_columns" does not exist
at Parser.parseErrorMessage (/Users/sjm/Code/directus-projects/feerd/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/Users/sjm/Code/directus-projects/feerd/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/Users/sjm/Code/directus-projects/feerd/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.<anonymous> (/Users/sjm/Code/directus-projects/feerd/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:527:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
length: 115,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '41',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1381',
routine: 'parserOpenTable'
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment