<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Jukka,</p>
<p>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.<br>
</p>
<p>spatial_ref_sys and geometry_columns table/views are always
removed from the listing due
<a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/blob/e7f14b7ff025bea54b9fd2363cda5eeae6d5ade6/ogr/ogrsf_frmts/pg/ogrpgdatasource.cpp#L1357">https://github.com/OSGeo/gdal/blob/e7f14b7ff025bea54b9fd2363cda5eeae6d5ade6/ogr/ogrsf_frmts/pg/ogrpgdatasource.cpp#L1357</a>
. 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 :-)<br>
</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 20/02/2024 à 15:37, Rahkonen Jukka
via gdal-dev a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:DB9PR09MB6887677F2C8FEB5D69F5412BFD502@DB9PR09MB6887.eurprd09.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator"
content="Microsoft Word 15 (filtered medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}span.Shkpostityyli17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
mso-ligatures:none;
mso-fareast-language:EN-US;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">I don’t undestand this
part of the PosgGIS driver documentation
<a href="https://gdal.org/drivers/vector/pg.html#faqs"
moz-do-not-send="true" class="moz-txt-link-freetext">https://gdal.org/drivers/vector/pg.html#faqs</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">“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)”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">An easy way to check the
permissions is to query those views/tables directly.<br>
ogrinfo PG:xxxxx spatial_ref_sys<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ogrinfo PG:xxxxx
geometry_columns<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">If ogrinfo lists
something else than an error, then permissions are OK. Is
this method good enough so I could edit the documentation?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>