Skip to content

fix(security_label): Properly quote qualified column names in Postgre…#562

Open
elias-summermatter wants to merge 2 commits intocyrilgdn:mainfrom
elias-summermatter:security-label-fix-problem-for-table-name-in-column-id
Open

fix(security_label): Properly quote qualified column names in Postgre…#562
elias-summermatter wants to merge 2 commits intocyrilgdn:mainfrom
elias-summermatter:security-label-fix-problem-for-table-name-in-column-id

Conversation

@elias-summermatter
Copy link
Copy Markdown

@elias-summermatter elias-summermatter commented Jul 22, 2025

This resolves a bug where SECURITY LABEL statements on qualified column names (e.g. user.name) did not correctly escape each identifier part individually. Now, names like user.name are properly transformed into "user"."name" to avoid syntax errors with mixed or case-sensitive identifiers.

@elias-summermatter
Copy link
Copy Markdown
Author

@cyrilgdn Can you have a look? Otherwise, I can't use your provider for security_label, which is a very nice feature. Thanks for the implementation

@DavideAG
Copy link
Copy Markdown

DavideAG commented Oct 21, 2025

Thanks for this, I'm also in this case to handle column based security using PostgreSQL Anonymizer.. @cyrilgdn can you please have a look at this? Thanks a lot for your work

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants