From: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Dumping security labels for extension owned tables? |
Date: | 2022-12-14 18:01:45 |
Message-ID: | CACxu=v+qpqE0V17QXyRRudEOb_zfKWL2_Mu461KvSwFOu61Dwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have an issue I've run into that is puzzling me, I have an extension
pgsodium that uses SECURITY LABEL to trigger the creation of encrypting
triggers and a decrypting view. When a table not associated with an
extension is dumped, the label gets dumped as well, and that's fine.
But if I have an extension that creates a table (and is "owned" by it) and
I apply a label, the table gets dumped (when I use
pg_extension_config_dump), but the label does not get dumped. If I run
`ALTER EXTENSION <extension_name> DROP TABEL <table_name>` the label does
get correctly dumped.
Is there a reason why extension associated tables do not have their label's
dumped, or is this a bug in pg_dump where it's dumping the table but not
the label? Hoping someone might have a suggestion for me before I go
digging into it too much further.
Thanks!
-Michel
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2022-12-14 19:29:34 | Re: Dumping security labels for extension owned tables? |
Previous Message | Tom Lane | 2022-12-14 17:38:24 | Re: tcp keepalives not sent during long query |