No template native mode for postgresql 14+ #557
axellpadilla
started this conversation in
Show and tell
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Just reporting back on a way to configure on not using a template table or keeping it updated for added fields, index, etc. (if you don't use non-native features on the partitioned table, just not use it), following documentation property inheritance and answer from @keithf4 on issue #556 .
First try, just create_parent() again to update the template:
Result: Function tries to create the template again (instead of replace/update it) and a duplicate relation error is shown, will this works by just changing the code to replace it, use another existing partition as a source for non-native features update?.
Second try, just drop the template table:
Result: An error is shown by run_maintenance():
Third try, as suggested by @keithf4 on the issue #556 , use NULL on template table column of table part_config of partman.
Result: Worked perfectly, run_maintenance() created the new partitions, works also with the template table dropped. (Remember that you can't use non-native features on the partitioned tables.)
Happy to help!
Beta Was this translation helpful? Give feedback.
All reactions