Dumping security labels for extension owned tables?
| От | Michel Pelletier |
|---|---|
| Тема | Dumping security labels for extension owned tables? |
| Дата | |
| Msg-id | CACxu=v+qpqE0V17QXyRRudEOb_zfKWL2_Mu461KvSwFOu61Dwg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Dumping security labels for extension owned tables?
|
| Список | 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
В списке pgsql-general по дате отправления: