[gdal-dev] Question about PG_LIST_ALL_TABLES in the documentation

[Even Rouault]

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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240220/41dd9c14/attachment-0001.htm>