PGXC_COPY_ERROR_LOG
The PGXC_COPY_ERROR_LOG system catalog is used to capture error rows related to the COPY FROM procedure for future reference.
- If enableSeparationOfDuty is set to on, the user can be a common database user or an administrator. Before using this system catalog, you need to create pgxc_copy_error_log tables in their respective schemas. No authorization is required.
- If enableSeparationOfDuty is set to off, the user can be a common database user or an administrator. If the user is a common user, the administrator needs to grant permissions to the common user. The administrator account can be used directly.
Name |
Type |
Description |
---|---|---|
relname |
character varying |
Table name, in the form of Schema name.Table name. |
begintime |
timestamp with time zone |
Time when a data format error was reported. |
filename |
character varying |
Name of the source data file where a data format error occurs. |
lineno |
bigint |
Number of the row where a data format error occurs in a source data file. |
rawrecord |
text |
Raw record of a data format error in the source data file. |
detail |
text |
Error details. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot