CODEWITHSUNDEEP
postgresqlcopypostgresql-9.3
user965586
user965586

Reputation: 583

PostgreSQL error logging options not recognised

As noted here I'm trying to use the PostgreSQL COPY ERROR_LOGGING, ERROR_LOGGING_SKIP_BAD_ROWS options.

My SQL looks like this:

COPY users FROM 'C:\Users\admin\osmosis_temp\users.txt'
    (ERROR_LOGGING, ERROR_LOGGING_SKIP_BAD_ROWS);

I get an SQL output of ERROR: option "error_logging" not recognized. Am I missing something that turns on the error logging in the first place?

PostgreSQL 9.3

Upvotes: 0

Views: 752

Answers (1)

vyegorov
vyegorov

Reputation: 22905

At the top of the wiki page you've linked to one reads:

Error logging in COPY was a proposed feature developed by Aster Data against the PostgreSQL 9.0 code base. It was submitted and reviewed (1) but not accepted into the core product for that or any other version so far.

So that was only a concept.

Upvotes: 2

Related Questions