pgsql: Ensure all files created for a single BufFile have the same reso

Ensure all files created for a single BufFile have the same resource owner.

Callers expect that they only have to set the right resource owner when
creating a BufFile, not during subsequent operations on it. While we could
insist this be fixed at the caller level, it seems more sensible for the
BufFile to take care of it. Without this, some temp files belonging to
a BufFile can go away too soon, eg at the end of a subtransaction,
leading to errors or crashes.

Reported and fixed by Andres Freund. Back-patch to all active branches.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/bffd1ce92cb4e3e44c3c0ff8cdd4a5a2a8be5e3c

Modified Files
--------------
src/backend/storage/file/buffile.c | 25 ++++++++++++++++++++++---
1 file changed, 22 insertions(+), 3 deletions(-)