PloadDelimitedSource does not log rejected data properly

Shyam_Katti

It looks like PloadDelimitedSource is not as good with logging as COPY command is. We are running into scenarios where when we run the command: copy {table} with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter E'\007' no escape direct; only the exception file is created, but there is no associated file which contains the actual rejected rows. when we run the command: copy {table} with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter E'\007' rejected data '/home/dbadmin/copyerrors/' no escape direct; the file with the actual rejected rows is generated, but does not have the associated *-copy-from-exceptions file. Is it possible to enforce PloadDelimitedSource utility to work like COPY command and generate both the files ?

Shyam_Katti

the first command should have just been: copy table with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter '\\007' no escape direct; How can I edit my post?

David_Chen

It seems that COPY's REJECTED DATA and EXCEPTIONS clauses only work with "COPY LOCAL".

However, for most users, all COPY'ing occurs locally, and we need a way to get at REJECTED DAT Aand their corresponding EXCEPTIONS, even if other methods of loading data are being used, such as pload (PloadDelimitedSource)