cobed95 commented on code in PR #4945:
URL: https://github.com/apache/polaris/pull/4945#discussion_r3627792378


##########
runtime/defaults/src/main/resources/application.properties:
##########
@@ -50,6 +50,12 @@ quarkus.otel.enabled=true
 #quarkus.mongodb.metrics.enabled=true
 #quarkus.mongodb.connection-string=mongodb://localhost:27017
 quarkus.datasource.db-kind=postgresql
+# The database schema holding the Polaris tables for the 'relational-jdbc' 
persistence type. The
+# schema is selected by the JDBC driver on each connection (the PostgreSQL 
driver's currentSchema
+# connection property, also used for CockroachDB). Override this property, or 
set currentSchema
+# directly in the JDBC URL (the URL takes precedence). The schema must exist 
before Polaris
+# connects; creating it is a DBA task requiring elevated privileges.
+quarkus.datasource.jdbc.additional-jdbc-properties.currentSchema=POLARIS_SCHEMA

Review Comment:
   Hi @flyrain, I've answered to your concern on the dev mailing list. Leaving 
a short answer here as well just for the record.
   I've verified empirically that `currentSchema` acts as a silent no-op when 
connecting with MySQL.
   However, I agree wholeheartedly that more community input is desirable!
   I'll wait for some more responses!



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to