***Resolved**** Unable to Connect to specified Schema using the Connection

Prashant Gade

In Settings.lgx file we are trying to establish Database Connection using the below. Even though we specified the Custom Schema it is connecting to Public schema by default.

How would we have a Connection connecting to a specified Schema. Even we tried with PostgresSQLSchema and CurrentSchema.

<Connection
   CommandTimeOut="600"
   ID="sessionDB"
   PostgreSQLDatabase="<SESSIONS_DB_NAME>"
   PostgreSQLPassword="<SESSIONS_DB_PW>"
   PostgreSQLServer="<SESSIONS_DB_HOST>"
   PostgreSQLUser="<SESSIONS_DB_USER>"
   Schema="<SESSIONS_DB_SCHEMA>"
   Type="PostgreSQL"
/>
0

Comments

1 comment

Date Votes
  • Comment author
    Prashant Gade

    Were able to get the fix working for connecting to Custom Schema in _Settings.lgx file.
    The updated connection:

    <Connection
       CommandTimeOut="600"
       ID="sessionDB"
       PostgreSQLDatabase="<DB_NAME>?currentSchema=<DB_SCHEMA>"
       PostgreSQLPassword="<DB_PW>"
       PostgreSQLServer="<DB_HOST>"
       PostgreSQLUser="<DB_USER>"
       Type="PostgreSQL"
    />
    0

Please sign in to leave a comment.