Mark the hint table as the configuration table.

ossc-db / pg_hint_plan

Extension adding support for optimizer hints in PostgreSQL

Other

720 stars 103 forks source link

Mark the hint table as the configuration table. #56

Closed egashira-yusuke closed 4 years ago

egashira-yusuke commented 4 years ago

The hint table (hint_plan.hints) is not dumped by pg_dump because it is not marked as Extension Configuration Tables. Is there a reason why not mark it as the configuration table?

The pg_extension_config_dump('hint_plan.hints', '') should be added to extension's script. This makes it eisier to migrate the database instance that contains the data of hint_plan.hints by using pg_dump/pg_restore.

horiguti commented 4 years ago

Thanks for pointing out. It has been just forgotten to be done. Applied back to 9.6.