You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "JamesRTaylor (via GitHub)" <gi...@apache.org> on 2024/06/12 00:13:06 UTC

[I] How to define sharding rules for a given schema? [shardingsphere]

JamesRTaylor opened a new issue, #31659:
URL: https://github.com/apache/shardingsphere/issues/31659

   ## Question
   
   I've seen your documentation [here](https://shardingsphere.apache.org/document/legacy/3.x/document/en/manual/sharding-proxy/configuration/) on how to define sharding rules for a schema, but I can't seem to find any example in your project that does this. What yaml file is `schemaName` allowed to be defined in? Is there a unit test or example that you can point me toward? I'm using 5.5.1-SNAPSHOT. Is the functionality described in your documentation still supported?
   
   Thanks for the help!


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] How to define sharding rules for a given schema? [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #31659:
URL: https://github.com/apache/shardingsphere/issues/31659#issuecomment-2226282034

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] How to define sharding rules for a given schema? [shardingsphere]

Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #31659:
URL: https://github.com/apache/shardingsphere/issues/31659#issuecomment-2161839963

   Hi @JamesRTaylor, the `schemaName` configuration has been adjusted to `databaseName` in version 5.x. If you want to use the PostgreSQL schema, you can directly use the CREATE SCHEMA statement and specify the schema prefix in SQL, for example: `SELECT * FROM schema.t_order`. In addition, please note that ShardingSphere currently does not support the `SET SEARCH_PATH` statement and can only be switched by specifying the schema in SQL.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] How to define sharding rules for a given schema? [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #31659: How to define sharding rules for a given schema?
URL: https://github.com/apache/shardingsphere/issues/31659


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org