Hi there,
I faced the issue that database service with blank schema cause database query error:
SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """" LINE 1: set search_path to "" ^ (SQL: SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('information_schema','pg_catalog'))
In the setup page of the service on the config tab the schema is left blank. When I save the config, I get: Test connection failed, could just be a typo. Please check config credentials for Service Name: ...
I've left the schema blank based on the hint of the input:
Schema
Leave blank to work with all available schemas, type "default" to only work with the default schema for the given credentials, or type in a specific schema to use for this service.
I use DreamFactory Version 5.0.1 deployed in Docker
Hi there,
I faced the issue that database service with blank schema cause database query error:
SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """" LINE 1: set search_path to "" ^ (SQL: SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('information_schema','pg_catalog'))In the setup page of the service on the config tab the schema is left blank. When I save the config, I get: Test connection failed, could just be a typo. Please check config credentials for Service Name: ...
I've left the schema blank based on the hint of the input:
Schema
Leave blank to work with all available schemas, type "default" to only work with the default schema for the given credentials, or type in a specific schema to use for this service.
I use DreamFactory Version 5.0.1 deployed in Docker