On February 19, 2019 3:05:37 AM PST, Surafel Temesgen <surafel3...@gmail.com>
wrote:
>On Sat, Feb 16, 2019 at 8:24 AM Andres Freund <and...@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.
Err, what? Again, that requires super user permissions (in contrast to copy
from/to stdin/out). Backends run as the user postgres runs under - it will
always have write permissions to at least the entire data directory. I think
not addressing this just about guarantees the feature will be rejected.
Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
