Postgres Pro
Downloads
Home   >   mailing lists

Re: Conflict handling for COPY FROM - Mailing list pgsql-hackers

From Surafel Temesgen
Subject Re: Conflict handling for COPY FROM
Date
Msg-id CALAY4q8vD-FY--nWDVv509-95NgTEbL6UGY-MEY0+-J540fSpA@mail.gmail.com
Whole thread Raw
In response to Re: Conflict handling for COPY FROM  (Andres Freund <andres@anarazel.de>)
Responses Re: Conflict handling for COPY FROM  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view


On Sat, Feb 16, 2019 at 8:24 AM Andres Freund <andres@anarazel.de> wrote:
Hi,

On 2018-08-23 17:11:04 +0300, Surafel Temesgen wrote:
> COPY ... WITH ON CONFLICT LOG maximum_error, LOG FILE NAME '…';

This doesn't seem to address Robert's point that a log file requires to
be super user only, which seems to restrict the feature more than
necessary?

- Andres


I think having write permission on specified directory is enough.
we use out put file name in COPY TO similarly.

regards
Surafel

pgsql-hackers by date:

Previous
From: Surafel Temesgen
Date:
Subject: Re: Conflict handling for COPY FROM
Next
From: Michael Meskes
Date:
Subject: Re: [Bug Fix] ECPG: could not use set xxx to default statement