[postgis-users] ownership and permissions on ogr_fdw shapefiles

[Richard Greenwood]

I'm using ogr_fdw to delete and insert rows in shapefiles from postgis
tables. The operations change the ownership and permissions of the files.
Is it possible to control ownership and permissions with ogr_fdw or do I
need to do that outside of psql. For example, before my sql operations on
the ogr_fdw tables they look like:
-rw-rw---- 1 rich postgres 465K Jul 13 15:08 GUERNSEY_PARCELS.dbf
-rw-rw---- 1 rich postgres  96K Jul 13 15:08 GUERNSEY_PARCELS.shp
-rw-rw---- 1 rich postgres 5.2K Jul 13 15:08 GUERNSEY_PARCELS.shx
and after:
-rw------- 1 postgres postgres 465K Jul 13 15:18 GUERNSEY_PARCELS.dbf
-rw------- 1 postgres postgres  96K Jul 13 15:18 GUERNSEY_PARCELS.shp
-rw------- 1 postgres postgres 5.2K Jul 13 15:18 GUERNSEY_PARCELS.shx
I'd like the ownership & permissions to not change.

Thanks,
Rich
-- 
Richard W. Greenwood, PLS
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210713/72c3c42a/attachment.html>