In this commit, fix gpdirtable can not specify file name. We can specify file name using two match mode, full match and regex match. Full match using for download one file while regex match using for downloading files in directory. What's more, we add new guc allow_dml_directory_table, which allow us to do dml on directory table's schema table. Lastly, we support a new grammar for drop directory table. We don't remove directory table's directory by default, while we can remove it by using 'with content' keywords in drop directory table grammar, for example:
DROP DIRECTORY TABLE dir_table WITH CONTENT;
Authored-by: Zhang Wenchao zwcpostgres@gmail.com
fix #ISSUE_Number
Change logs
Describe your change clearly, including what problem is being solved or what feature is being added.
If it has some breaking backward or forward compatibility, please clary.
Why are the changes needed?
Describe why the changes are necessary.
Does this PR introduce any user-facing change?
If yes, please clarify the previous behavior and the change this PR proposes.
How was this patch tested?
Please detail how the changes were tested, including manual tests and any relevant unit or integration tests.
Contributor's Checklist
Here are some reminders and checklists before/when submitting your pull request, please check them:
[ ] Make sure your Pull Request has a clear title and commit message. You can take git-commit template as a reference.
[ ] Sign the Contributor License Agreement as prompted for your first-time contribution(One-time setup).
In this commit, fix gpdirtable can not specify file name. We can specify file name using two match mode, full match and regex match. Full match using for download one file while regex match using for downloading files in directory. What's more, we add new guc allow_dml_directory_table, which allow us to do dml on directory table's schema table. Lastly, we support a new grammar for drop directory table. We don't remove directory table's directory by default, while we can remove it by using 'with content' keywords in drop directory table grammar, for example:
DROP DIRECTORY TABLE dir_table WITH CONTENT;
Authored-by: Zhang Wenchao zwcpostgres@gmail.com
fix #ISSUE_Number
Change logs
Describe your change clearly, including what problem is being solved or what feature is being added.
If it has some breaking backward or forward compatibility, please clary.
Why are the changes needed?
Describe why the changes are necessary.
Does this PR introduce any user-facing change?
If yes, please clarify the previous behavior and the change this PR proposes.
How was this patch tested?
Please detail how the changes were tested, including manual tests and any relevant unit or integration tests.
Contributor's Checklist
Here are some reminders and checklists before/when submitting your pull request, please check them:
make installcheckmake -C src/test installcheck-cbdb-parallelcloudberrydb/devteam for review and approval when your PR is ready🥳