terrymanu commented on issue #24055:
URL:
https://github.com/apache/shardingsphere/issues/24055#issuecomment-3661064726
## Understanding
When using PostgreSQL Row Level Security (RLS) via ShardingSphere Proxy,
the SET LOCAL tenant variable doesn’t take effect, and inserts hit the tenant
column NOT NULL constraint.
## Root Cause
ShardingSphere focuses on cross-database traffic routing and governance,
and does not plan to cover database-specific permission features like
PostgreSQL RLS. Session-level GUC propagation and consistency across multiple
connections/shards are not implemented.
## Analysis
The RLS session variable may not be applied to the actual physical
connection executing the INSERT, so current_setting returns no value and the
NOT NULL constraint is triggered. This is a missing feature rather than a SQL
usage issue.
## Conclusion
ShardingSphere currently does not plan to support PostgreSQL RLS.
--
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]
