In my 2019R3 development environment I have a database profile setup to an ODBC connection defined for a postgres database. The schema for the tables in this database is in postgres instead of public.
The connection works, but I get a message saying, "Catalog tables could not be created and are not available for use." I resolve that by going into the System tab of the profile and setting the owner to postgres. At this point if I expand the profile view to list the tables, none of the tables are prepended by a schema. If i try to expand a table I get the message, "Table "NAME" has no columns; possible invalid table format."
If I try to preview data in a datawindow, using this connection, I get an error saying:
"Select Error: SQLSTATE = 42P01
ERROR: relation "NAME" does not exist;
Error while preparing parameters"
I think I had previously resolved such an issue by specifying a parameter in the "Connect Settings" on the ODBC connection that told it which schema to use, but I am unable to get it figured out again.
Could someone please assist me in getting this working?
Thanks
Thanks!