Jukka,
I would probably completely remove that paragraph, or at least remove
the wrong hint on how to check if permissions are correct. Correct
permission settings of a PostgreSQL/PostGIS database is probably out of
scope of the driver documentation. But your suggestion for an alternate
method sounds OK too.
spatial_ref_sys and geometry_columns table/views are always removed from
the listing due
https://github.com/OSGeo/gdal/blob/e7f14b7ff025bea54b9fd2363cda5eeae6d5ade6/ogr/ogrsf_frmts/pg/ogrpgdatasource.cpp#L1357
. The weird thing is that looking in the history that filtering was
already done before the FAQ entry was written, so I'm not sure to
remember what I had in mind 16 years ago when I wrote it :-)
Even
Le 20/02/2024 à 15:37, Rahkonen Jukka via gdal-dev a écrit :
Hi,
I don’t undestand this part of the PosgGIS driver documentation
https://gdal.org/drivers/vector/pg.html#faqs
“Permission issues on geometry_columns and/or spatial_ref_sys tables
can be generally confirmed if you can see the tables by setting the
configuration option PG_LIST_ALL_TABLES to YES. (e.g. ogrinfo -
-config PG_LIST_ALL_TABLES YES PG:xxxxx)”
For the first, was the meaning to say the opposite, that there are
permission issues if you cannot see the tables? And for the second,
with current GDAL and PostGIS versions user does not see
geometry_columns and spatial_ref_sys on the ogrinfo layer list even
with this config option. It seems that they are filtered away from the
result. I do see that the config option has an effect and for example
raster_columns and raster_overviews are added to the layer list.
An easy way to check the permissions is to query those views/tables
directly.
ogrinfo PG:xxxxx spatial_ref_sys
ogrinfo PG:xxxxx geometry_columns
If ogrinfo lists something else than an error, then permissions are
OK. Is this method good enough so I could edit the documentation?
-Jukka Rahkonen-
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
