Re: Directory/File Access Permissions for COPY and Generic File Access Functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Jeremy Harris <jgh(at)wizmail(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Directory/File Access Permissions for COPY and Generic File Access Functions
Date: 2014-10-29 17:57:33
Message-ID: 28263.1414605453@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> On 2014-10-29 16:38:44 +0000, Jeremy Harris wrote:
>> On 29/10/14 16:11, Andres Freund wrote:
>>> I do think checking the link count to
>>> be 1 is safe though.

>> You will fail against certain styles of online-backup.

> Meh. I don't think that's really a problem for the usecases for COPY
> FROM.

I think Jeremy's point is that if such a backup technology is in use, it
would result in random failures whenever the backup daemon happened to
have an extra hardlink at the moment you tried to access the file.

In other words, just another scenario where the proposed feature fails.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2014-10-29 18:11:01 Re: Directory/File Access Permissions for COPY and Generic File Access Functions
Previous Message Stephen Frost 2014-10-29 17:57:17 Re: Materialized views don't show up in information_schema