Postgres error with RR SGL designer
-
- Posts: 55
- Joined: Tue Oct 10, 2017 12:44 pm
Postgres error with RR SGL designer
Cannot connect to Postgres database. We are getting a schema error. Does RR have a fix for this?____Thanks..__Sergio
=> Postgres error with RR SGL designer
We do not have a fix. Are there any configuration settings in the driver that might help?____Kathleen__R&R Support
-
- Posts: 55
- Joined: Tue Oct 10, 2017 12:44 pm
==> Postgres error with RR SQL designer
Kathleen,____The exact error is:__DB access error: Schema "dcl-gti" does not exist____This error happens on new reports and existing reports if I add new relation table via join.____Weird thing is old reports all work if left as is.____I check all my options, and cannot see where a setting would work. the other weird thing I noticed on new report only is that the all the field names have this prefix which never was there before, something like:__<<"dcl-gti".tablename>>____I also tested sams ODBC with MS Access and everything worked as is, therefore the problem is with RR and not the ODBC driver.____Please help.__Ciao..__Sergio
===> RE: Postgres error with RR SQL
It would appear that R&R is using the user entry from the psql driver as the schema name, which is incorrect. Can anyone verify this?