Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

fix TCE trigger update regression and tests to cover it. #49

Merged
merged 1 commit into from
Nov 28, 2022

Conversation

michelp
Copy link
Owner

@michelp michelp commented Nov 28, 2022

No description provided.

@michelp michelp merged commit b6ede19 into main Nov 28, 2022
@ioguix
Copy link
Collaborator

ioguix commented Nov 28, 2022

Hi,

TCE triggers and generated masking views are still blurry to me as I hadn't time to investigate this part of the code yet.

Like, I'm still not sure what pgsodium_masks is supposed to be. Is it a forgotten artifact from an old version?

Also, unless I'm wrong, SECURITY LABEL FOR pgsodium ON {ROLE|TABLE} are not documented... So I'm still not sure how things are supposed to work around them.

I'm not even sure what this PR is supposed to fix :)

@michelp michelp deleted the fix/trigger-on-update-too branch November 28, 2022 21:30
@michelp
Copy link
Owner Author

michelp commented Nov 28, 2022

Hi,

TCE triggers and generated masking views are still blurry to me as I hadn't time to investigate this part of the code yet.

Like, I'm still not sure what pgsodium_masks is supposed to be. Is it a forgotten artifact from an old version?

It is, I'll push a fix to remove it, just hasn't been a priority.

Also, unless I'm wrong, SECURITY LABEL FOR pgsodium ON {ROLE|TABLE} are not documented... So I'm still not sure how things are supposed to work around them.

TCE is an optional feature that is still in progress that should be launched in a couple of weeks, there is some documentation that is progress that is not yet complete, so you can skip reviewing future changes until after release:

Here are the docs in progress:

https://github.com/michelp/pgsodium/blob/main/docs/Transparent_Column_Encryption.md

I'm not even sure what this PR is supposed to fix :)

The only non-test change was adding OR UPDATE to the trigger:

b6ede19#diff-8bce69e00501ddc80327de0ce32914dd249662d8eabc43b67c2487218c8995d5R124

@ioguix
Copy link
Collaborator

ioguix commented Nov 28, 2022

TCE is an optional feature that is still in progress that should be launched in a couple of weeks, there is some documentation that is progress that is not yet complete,

Oh, ok. I didn't realized TCE wasn't released yet. I was actually wondering why the 3.0 version hadn't been announced yet.

Here are the docs in progress:

https://github.com/michelp/pgsodium/blob/main/docs/Transparent_Column_Encryption.md

Thanks for the feedback and pointer

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