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
-
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