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

GAUSS-01191 -- GAUSS-01200

GAUSS-01191: "COPY force quote available only in CSV mode"

SQLSTATE: 0A000

Description: The force quote in COPY is not in CSV mode.

Solution: Ensure that the force quote is in CSV mode.

GAUSS-01192: "COPY force quote only available using COPY TO"

SQLSTATE: 0A000

Description: The force quote in COPY supports only the copy to operation.

Solution: Ensure that the force quote character is in the copy to statement.

GAUSS-01193: "COPY force not null available only in CSV mode"

SQLSTATE: 0A000

Description: The force Not-Null character in COPY is not in CSV mode.

Solution: Ensure that the force Not-Null character is in CSV mode.

GAUSS-01194: "COPY force not null only available using COPY FROM"

SQLSTATE: 0A000

Description: The force Not-Null character supports only COPY FROM.

Solution: Ensure that the force Not-Null character is in COPY FROM.

GAUSS-01195: "COPY delimiter must not appear in the NULL specification"

SQLSTATE: 0A000

Description: The delimiter in COPY exists in the null specification.

Solution: Use a value not in the null specification as the delimiter.

GAUSS-01196: "without escaping available only in TEXT mode"

SQLSTATE: 0A000

Description: Escape characters are used in TEXT mode.

Solution: Do not use escape character in TEXT mode.

GAUSS-01197: "CSV quote character must not appear in the NULL specification"

SQLSTATE: 0A000

Description: The CSV quote character in COPY exists in the null specification.

Solution: Use a value not in the null specification as the delimiter.

GAUSS-01198: "SHARED mode can not be used with CSV format"

SQLSTATE: 0A000

Description: The shared mode is used with the CSV format.

Solution: Do not use the shared mode with the CSV format.

GAUSS-01199: "HEADER FILE only available using COPY TO or WRITE ONLY foreign table"

SQLSTATE: 0A000

Description: The header file is used in other scenarios besides the copy to and foreign table scenarios.

Solution: Use the header file only in the copy to and foreign table scenarios.

GAUSS-01200: "EOL specification only available using COPY TO or WRITE ONLY foreign table"

SQLSTATE: 0A000

Description: The EOL specification is used in other scenarios besides the copy to and write only foreign table scenarios.

Solution: Use the EOL specification only in the copy to and write only foreign table scenarios.