Clean up some mess in row-security patches.
Tom Lane <tgl@sss.pgh.pa.us>
Clean up some mess in row-security patches. Fix unsafe coding around PG_TRY in RelationBuildRowSecurity: can't change a variable inside PG_TRY and then use it in PG_CATCH without marking it "volatile". In this case though it seems saner to avoid that by doing a single assignment before entering the TRY block. I started out just intending to fix that, but the more I looked at the row-security code the more distressed I got. This patch also fixes incorrect construction of the RowSecurityPolicy cache entries (there was not sufficient care taken to copy pass-by-ref data into the cache memory context) and a whole bunch of sloppiness around the definition and use of pg_policy.polcmd. You can't use nulls in that column because initdb will mark it NOT NULL --- and I see no particular reason why a null entry would be a good idea anyway, so changing initdb's behavior is not the right answer. The internal value of '\0' wouldn't be suitable in a "char" column either, so after a bit of thought I settled on using '*' to represent ALL. Chasing those changes down also revealed that somebody wasn't paying attention to what the underlying values of ACL_UPDATE_CHR etc really were, and there was a great deal of lackadaiscalness in the catalogs.sgml documentation for pg_policy and pg_policies too. This doesn't pretend to be a complete code review for the row-security stuff, it just fixes the things that were in my face while dealing with the bugs in RelationBuildRowSecurity.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +115 −111 |
| src/backend/catalog/system_views.sql | modified | +6 −7 |
| src/backend/commands/policy.c | modified | +82 −73 |
| src/backend/rewrite/rowsecurity.c | modified | +9 −10 |
| src/backend/utils/cache/relcache.c | modified | +1 −1 |
| src/bin/pg_dump/pg_dump.c | modified | +12 −16 |
| src/bin/psql/describe.c | modified | +4 −3 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_policy.h | modified | +2 −2 |
| src/include/rewrite/rowsecurity.h | modified | +2 −2 |
| src/test/regress/expected/rules.out | modified | +7 −10 |