robertmu opened a new pull request, #74: URL: https://github.com/apache/cloudberry-backup/pull/74
In GPDB 7.0+ and Cloudberry Database, external tables are implemented as foreign tables under the hood. When gpbackup exports metadata for an external table with a comment, using the traditional "TABLE" object type causes an error during gprestore because the database expects "FOREIGN TABLE" syntax for these objects. This change updates the GetMetadataEntry logic to correctly identify external tables as "FOREIGN TABLE" in newer database versions. SQL Comparison: Before (Fails on GPDB 7+ / Cloudberry): -------------------------------------------------- COMMENT ON TABLE public.my_ext_table IS 'this is an external table comment'; After (Executes successfully): -------------------------------------------------- COMMENT ON FOREIGN TABLE public.my_ext_table IS 'this is an external table comment'; -- 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]
