vsbace opened a new issue, #1249:
URL: https://github.com/apache/cloudberry/issues/1249
### Apache Cloudberry version
1.6.0
### What happened
Hello,
I trying to test dump from Greenplum 7.2 RC1 to Cloudberry 1.6.0
And get some errors when foreign tables was created - "SQL Error [42704]:
ERROR: missing format, logerrors, encoding or iswritable options for relation
"db_files_segments"
ERROR: missing format, logerrors, encoding or iswritable options for
relation "db_files_segments"
"
But table was created and can not be deleted later.
### What you think should happen instead
I think when we are trying to create incorrect object we will catch error
and object can not be created.
### How to reproduce
1) create incorrect table
CREATE FOREIGN TABLE public.db_files_segments2 (
segment_id integer,
relfilenode text,
filename text,
size numeric,
last_timestamp_change timestamp without time zone
)
SERVER gp_exttable_server
OPTIONS (
command 'find $GP_SEG_DATADIR/base/`PGOPTIONS="-c
gp_session_role=utility" psql -p $GP_SEG_PORT template1 -At -c"select oid from
pg_database where datname=''NULL'';"` -type f -printf
"$GP_SEGMENT_ID|%f|%h/%f|%s|%TY-%Tm-%Td %TX
" 2> /dev/null || true',
--
execute_on 'ALL_SEGMENTS',
format 'text',
is_writable 'false',
log_errors 'disable',
"null" E'\\N'
);
2) When we are trying to drop this table we will catch the next error
drop FOREIGN TABLE public.db_files_segments2;
"SQL Error [42704]: ERROR: missing format, logerrors, encoding or iswritable
options for relation "db_files_segments2"
Error position:"
### Operating System
Debian 12
### Anything else
_No response_
### Are you willing to submit PR?
- [x] Yes, I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of
Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).
--
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]
