Updated on 2023-12-22 GMT+08:00

GAUSS-01211 -- GAUSS-01220

GAUSS-01211: "cannot copy from view '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from views.

Solution: Do not copy data from views.

GAUSS-01212: "cannot copy from foreign table '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from foreign tables.

Solution: Do not copy data from foreign tables.

GAUSS-01213: "cannot copy from sequence '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from sequences.

Solution: Do not copy data from sequences.

GAUSS-01214: "cannot copy from non-table relation '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from non-table relation.

Solution: Do not copy data from non-table relation.

GAUSS-01215: "relative path not allowed for COPY to file"

SQLSTATE: 42602

Description: The path format of the target file to be copied cannot be a relative path.

Solution: Use an absolute path as a target file path during the copy.

GAUSS-01216: "could not open file '%s' for writing: %m"

SQLSTATE: XX000

Description: The specified file cannot be opened.

Solution: Ensure that the specified file is not damaged and the permission is sufficient.

GAUSS-01217: "'%s' is a directory"

SQLSTATE: 42809

Description: The specified parameter is a directory name but not a file name.

Solution: Specify a file name rather than a directory name for COPY.

GAUSS-01218: "could not chmod file '%s' : %m"

SQLSTATE: XX000

Description: The permission of the file fails to be changed.

Solution: Ensure that the permission and user group of the file are correct.

GAUSS-01219: "Invalid file format"

SQLSTATE: XX000

Description: The file format is not supported.

Solution: Use a TXT, binary, or CSV format that is supported during copy.

GAUSS-01220: "null value in column '%s' violates not-null constraint"

SQLSTATE: 23502

Description: A null value is entered in a column having the Not-Null constraint.

Solution: Enter valid values in columns having the Not-Null constraint.