***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

  • 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.