Updated on 2025-05-29 GMT+08:00

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.
Table 1 pgxc_copy_error_log columns

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.