avamingli commented on issue #1556: URL: https://github.com/apache/cloudberry/issues/1556#issuecomment-3985206334
This is expected behavior in the current version. pg_dump -t matches only the exact table name — it does not automatically include child partitions. This is consistent with upstream PostgreSQL 14 behavior. As a workaround, explicitly include the child partitions: ```shell pg_dump -t table1 -t 'table1_*' --schema-only ``` Note that PostgreSQL 17 introduced **--table-and-children** to address exactly this use case. This could be something worth backporting to Cloudberry. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
