On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-01201 -- GAUSS-01300/ GAUSS-01201 -- GAUSS-01210

GAUSS-01201 -- GAUSS-01210

Updated on 2024-03-15 GMT+08:00

View PDF

GAUSS-01201: "can not specify EOL in BINARY mode"

SQLSTATE: 0A000

Description: The terminator fails to be specified in BINARY mode.

Solution: Use terminators in a mode other than BINARY.

GAUSS-01202: "FIX specification only available using COPY FROM or READ ONLY foreign table"

SQLSTATE: 42000

Description: The specified FIX is available only in COPY TO scenario or in foreign tables.

Solution: Use the specified FIX only in COPY TO scenario or in foreign tables.

GAUSS-01203: "FILEHEADER specification only available using HEAD"

SQLSTATE: 42601

Description: The file to read HEADER information from is specified, but whether this information is required is not specified.

Solution: Specify HEADER in the export statement or remove the name of the file to be read.

GAUSS-01204: "table '%s' does not have OIDs"

SQLSTATE: 42703

Description: The OID item is specified when data is imported, but there is no such OID column in the user table.

Solution: Ensure that the data to be imported has OIDs consistent with the user table definition. Delete the imported OID item or add an OID column to the user table.

GAUSS-01205: "COPY (SELECT) WITH OIDS is not supported"

SQLSTATE: 0A000

Description: COPY WITH OIDs is not supported.

Solution: Do not use COPY WITH OIDs.

GAUSS-01206: "unexpected rewrite result"

SQLSTATE: XX000

Description: Internal system error. The imported SQL statement is not rewritten as expected.

Solution: Runtime error. Contact technical support.

GAUSS-01207: "COPY (SELECT INTO) is not supported"

SQLSTATE: 0A000

Description: COPY SELECT INTO is not supported.

Solution: Do not use SELECT INTO in COPY.

GAUSS-01208: "FORCE QUOTE column '%s' not referenced by COPY"

SQLSTATE: 42P10

Description: In CSV COPY TO mode, quotation marks are not used for any non-null value in each specified column.

Description: In CSV COPY TO mode, use quotation marks for all non-null values in each specified column. Null values are not quoted.

GAUSS-01209: "FORCE NOT NULL column '%s' not referenced by COPY"

SQLSTATE: 42P10

Description: In CSV COPY FROM mode, the specified column cannot be empty.

Solution: In CSV COPY FROM mode, enter a value for the specified column.

GAUSS-01210: "could not close file '%s': %m"

SQLSTATE: XX000

Description: Failed to close the specified file.

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

Parent topic: GAUSS-01201 -- GAUSS-01300

Previous topic: GAUSS-01201 -- GAUSS-01300

Next topic: GAUSS-01211 -- GAUSS-01220

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel