<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@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;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New",serif;
color:black;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;
color:black;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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]--></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Kit,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>What sort of problems are you encountering?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If you have constraints on your current tables and are using for example a parent table, then the raster_columns would only consider the constraints applied to the parent table, not the child tables. This may or may not be okay depending on what you are doing. It also does require you make sure you have spatial indexes on the parent table even if your parent table is always empty.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Also I don't think GDAL uses raster_columnn view as much as it could. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Case in point: this part that tries to find a spatial index:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><a href="https://trac.osgeo.org/gdal/browser/trunk/gdal/frmts/postgisraster/postgisrasterdataset.cpp#L316">https://trac.osgeo.org/gdal/browser/trunk/gdal/frmts/postgisraster/postgisrasterdataset.cpp#L316</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> I think part of the reason for that – like verifying existence of indexes appeared in GDAL first before appearing in raster_columns or simultaneously appeared, so GDAL reimplements some of the query logic used by raster_columns.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>There was also a period of flux between 2.0 and 2.1 where some raster_columns were renamed, removed, added so that GDAL couldn't consistently rely on them without checking PostGIS version.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> postgis-devel [mailto:postgis-devel-bounces@lists.osgeo.org] <b>On Behalf Of </b>kit<br><b>Sent:</b> Tuesday, May 02, 2017 4:37 PM<br><b>To:</b> postgis-devel@lists.osgeo.org<br><b>Subject:</b> Re: [postgis-devel] [postgis-users] raster2pgsql: out_db=false with -R flag (And Showing out_db rasters in QGIS)<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><p style='margin-left:.5in'>Is there a potential issue with how gdal expects to see the raster and in particular the metadata it gets from raster_columns? I've some trouble with GDAL and partitioning that I need to work through at some point - but that for the moment I'm effectvely materializing a view ov my underlying tables to subsequently generate the statistics and constraints that GDAL want to see. <o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><div><p class=MsoNormal style='margin-left:.5in'>On 02/05/2017 21:24, Regina Obe wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Disregard what I said. I see that the SQL statements I thought mistakenly were coming from DbManager are generated by GDAL (looking at the GDAL postgis raster code).</span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So the change would need to be done in GDAL driver. I think having a PostGIS function GDAL can count on calling that would always return the materialized raster tile would simplify things though.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So I'm thinking strongly of implementing that in PostGIS 2.4. I think all other calls that GDAL is doing to for example get meta data and overviews would be the same for out-db as it is for in-db.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Even,</span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Any input you have on the matter would be very welcomed. I guess this would need to wait for GDAL 2.2 or 2.3 and verify said helper function exists (or version of PostGIS) before it can be used.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,</span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina</span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:1.0in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Regina Obe [<a href="mailto:lr@pcorp.us">mailto:lr@pcorp.us</a>] <br><b>Sent:</b> Tuesday, May 02, 2017 4:04 PM<br><b>To:</b> 'PostGIS Users Discussion' <a href="mailto:postgis-users@lists.osgeo.org"><postgis-users@lists.osgeo.org></a><br><b>Cc:</b> 'PostGIS Development Discussion' <a href="mailto:postgis-devel@lists.osgeo.org"><postgis-devel@lists.osgeo.org></a><br><b>Subject:</b> RE: [postgis-users] raster2pgsql: out_db=false with -R flag (And Showing out_db rasters in QGIS)</span><o:p></o:p></p></div></div><p class=MsoNormal style='margin-left:1.0in'> <o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Just to add the bug regarding raster2pgsql will be fixed in upcoming 2.3.3</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>And the work-around is to use –Y with –s as detailed in the ticket.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><a href="https://trac.osgeo.org/postgis/ticket/3738">https://trac.osgeo.org/postgis/ticket/3738</a></span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regarding the QGIS issue with GDAL not supporting out-db. I've been thinking that the easier fix might be to make the change in QGIS DbManager instead of PostGIS.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>The ultimate problem is that PostGIS is feeding an out-db raster instead of the raster bytes. QGIS just makes queries to the PostGIS database and uses GDAL to consume the raw bytes.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If QGIS dbmanager were to instead of doing SELECT rast … did something like SELECT ST_Materialize(rast) AS rast …. FROM somerast table …</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Where yet to be implemented PostGIS function ST_Materialize or whatever we decide to call it does nothing with in-db, but returns the raster bytes of out-db, then QGIS DbManager can treat out-db like any in-db raster.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I'm thinking this would be a faster fix than mucking with PostGIS GDAL driver and in the end might help simplify the PostGIS GDAL driver handling of out-db since it can use the same function.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>strk,</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I think you are familiar with the internal workings of QGIS Db Manager. You think this proposed option is feasible and less taxing or we'd still need to do something on the GDAL end to make this work?</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.5in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Tumasgiu Rossini<br><b>Sent:</b> Tuesday, May 02, 2017 8:26 AM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> Re: [postgis-users] raster2pgsql: out_db=false with -R flag (And Showing out_db rasters in QGIS)</span><o:p></o:p></p><p class=MsoNormal style='margin-left:1.5in'> <o:p></o:p></p><div><div><div><p class=MsoNormal style='margin-left:1.5in'>I think that raster2pgsql is indeed a mature tool, but it is the out-db feature of postgis<o:p></o:p></p></div><p class=MsoNormal style='margin-left:1.5in'>which is maybe not widely used, and so the bugs takes more time to appear because<o:p></o:p></p></div><p class=MsoNormal style='margin-left:1.5in'>of the fewer users.<o:p></o:p></p><div><div><div><div><p class=MsoNormal style='margin-left:1.5in'> <o:p></o:p></p><div><p class=MsoNormal style='margin-left:1.5in'>2017-05-02 12:18 GMT+02:00 <<a href="mailto:Michael.Haertel@t-systems.com" target="_blank">Michael.Haertel@t-systems.com</a>>:<o:p></o:p></p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hello Tumasgiu Rossini,</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>thank you very much for your fast and comprehensive response. I was not aware of that bug yet but found so many references to raster2pgsql that I just assumed that it was a mature tool already. </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>(And noted that I gave wrong parameter in the subject line of my mail, should have been R and not F).</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Good luck with your programming efforts. I guess it’s somewhat complex since you have to deal with the real pixel data. </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regards,</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Michael</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><b><span style='font-size:10.0pt;font-family:"Tahoma",sans-serif'>Von:</span></b><span style='font-size:10.0pt;font-family:"Tahoma",sans-serif'> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>Im Auftrag von </b>Tuma</span><span lang=DE style='font-size:10.0pt;font-family:"Tahoma",sans-serif'>sgiu Rossini<br><b>Gesendet:</b> Dienstag, 2. Mai 2017 12:08<br><b>An:</b> PostGIS Users Discussion<br><b>Betreff:</b> Re: [postgis-users] raster2pgsql: out_db=false with -F flag (And Showing out_db rasters in QGIS)</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE> </span><o:p></o:p></p><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:1.5in'><span lang=DE>Hi,</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>To answer your first question : </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>the combination of the -s and -R options actually transforms out-db raster into in-db,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:1.5in'><span lang=DE>it is a recent known bug, see <a href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042003.html" target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042003.html</a> <br>for more information.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>For the latter question,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>Qgis uses gdal to fetch raster data from postgis and the out-db support is not implemented.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>You can though maybe use workarounds, more info here :<br><a href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042077.html" target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042077.html</a><br><a href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042053.html" target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042053.html</a></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>Using out-db rasters and Qgis at my company, I am facing myself this problem and</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>I am trying to implement out-db support in gdal, though I am no gdal developer</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>and it is not a high priority feature.</span><o:p></o:p></p></div></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE> </span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE>2017-05-02 11:37 GMT+02:00 <<a href="mailto:Michael.Haertel@t-systems.com" target="_blank">Michael.Haertel@t-systems.com</a>>:</span><o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Dear users,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I hope that somebody can tell me if I found a bug or simply don’t use the command correctly.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Given:</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>A directory with four GeoTIFF files </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>PostgreSQL 9.6.1, compiled by Visual C++ build 1800, 64-bit</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>POSTGIS="2.3.1 r15264" GEOS="3.6.0-CAPI-1.10.0 r4265" SFCGAL="1.3.0" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.1.1, released 2016/07/07" LIBXML="2.7.8" LIBJSON="0.12" RASTER</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>OS is Windows 7</span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I try to import the Tiff files as OUT_DB raster files using this command:</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Courier New",serif'>1.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Courier New",serif'>raster2pgsql.exe -s 25832 -I -R -n myFilename -C -M -F C:\_GEODATA_\*.tif raster2x2 > t:\DTK10.sql<br><br></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Output:</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>a.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 1/4: C:\_GEODATA_\24_dtk10_32356_5608_2_nw_col.tif</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>b.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 2/4: C:\_GEODATA_\25_dtk10_32356_5610_2_nw_col.tif</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>c.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 3/4: C:\_GEODATA_\34_dtk10_32358_5608_2_nw_col.tif</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>d.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 4/4: C:\_GEODATA_\35_dtk10_32358_5610_2_nw_col.tif</span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Courier New",serif'>2.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Courier New",serif'>psql.exe --host=localhost --port=5432 --username=xxx --dbname=xxx -f t:\DTK10.sql</span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br>Output:</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>a.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>BEGIN</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>b.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>CREATE TABLE</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>c.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>d.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>e.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>f.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>g.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>CREATE INDEX</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>h.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>ANALYZE</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>i.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding SRID constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>j.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding scale-X constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>k.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding scale-Y constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>l.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding blocksize-X constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>m.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding blocksize-Y constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>n.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding alignment constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>o.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding number of bands constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>p.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding pixel type constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>q.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding nodata value constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>r.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding out-of-database constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>s.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding maximum extent constraint</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>t.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>addrasterconstraints</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>u.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>----------------------</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>v.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>t</span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Problem is that the view “raster_columns” always shows FALSE for out_db, even though I used the F flag:</span><o:p></o:p></p></div><table class=MsoNormalTable border=0 cellpadding=0 width=544 style='width:408.0pt;margin-left:1.5in'><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_table_catalog"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_table_schema"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_table_name"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_raster_column"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"srid"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"scale_x"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"scale_y"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"blocksize_x"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"blocksize_y"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"same_alignment"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"regular_blocking"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"num_bands"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"pixel_types"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"nodata_values"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"out_db"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"extent"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"spatial_index"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"gismobile"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"public"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"raster2x2 "<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"rast"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>25832<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0.5<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>-0.5<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>4000<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>4000<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>true<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>false<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>1<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>{8BUI}<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>{NULL}<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>{f}<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0103000020E864000001000000050000000000000080BA154100000000906455410000000080BA154100000000786855410000000000F9154100000000786855410000000000F9154100000000906455410000000080BA15410000000090645541<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>true<o:p></o:p></p></td></tr></table><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><table class=MsoNormalTable border=0 cellpadding=0 width=96 style='width:1.0in;margin-left:1.5in'><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"rid"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"rast"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"filename"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>1<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF0000000080BA1541000000008466554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C32345F64746B31305F33323335365F353630385F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"24_dtk10_32356_5608_2_nw_col.tif"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>2<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF0000000080BA1541000000007868554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C32355F64746B31305F33323335365F353631305F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"25_dtk10_32356_5610_2_nw_col.tif"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>3<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF00000000C0D91541000000008466554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C33345F64746B31305F33323335385F353630385F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"34_dtk10_32358_5608_2_nw_col.tif"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>4<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF00000000C0D91541000000007868554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C33355F64746B31305F33323335385F353631305F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"35_dtk10_32358_5610_2_nw_col.tif"<o:p></o:p></p></td></tr></table><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>What I found out: As soon as I omit the s flag (to provide a SRS) the column shows TRUE.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I guess that this is not the intended behaviour is it?</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>My QGIS 2.18 only shows black boxes for out_db rasters, the rasters themselves (pixel values) only appear for “in-DB” rasters. Did anybody succeed in showing out_db rasters in QGIS?</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Interestiung is also that gdalinfo is not showing any extents although it shows correct SRS and the “extent” column is populated (see above):</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Courier New",serif'>C:\_PortableApps_\pgsql\bin>"c:\QGIS\bin\gdalinfo.exe" PG:"dbname='xxx' host='localhost' port='5432' user='mhaerte2' password='xxx' table='raster2x2'"</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Driver: PostGISRaster/PostGIS Raster driver</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Files: none associated</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Size is 0, 0</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Coordinate System is:</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>PROJCS["ETRS89 / UTM zone 32N",</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> GEOGCS["ETRS89",</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> DATUM["European_Terrestrial_Reference_System_1989",</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> SPHEROID["GRS 1980",6378137,298.257222101,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","7019"]],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> TOWGS84[0,0,0,0,0,0,0],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","6258"]],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PRIMEM["Greenwich",0,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","8901"]],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> UNIT["degree",0.0174532925199433,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","9122"]],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","4258"]],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PROJECTION["Transverse_Mercator"],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["latitude_of_origin",0],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["central_meridian",9],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["scale_factor",0.9996],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["false_easting",500000],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["false_northing",0],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> UNIT["metre",1,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","9001"]],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AXIS["Easting",EAST],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AXIS["Northing",NORTH],</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","25832"]]</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Subdatasets:</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> --- snip! --</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Corner Coordinates:</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Upper Left ( 0.0, 0.0)</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Lower Left ( 0.0, 0.0)</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Upper Right ( 0.0, 0.0)</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Lower Right ( 0.0, 0.0)</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Center ( 0.0, 0.0)</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Does anyone have a clue? </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Thank you for your comments,</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Michael</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span lang=DE> </span><o:p></o:p></p></div></div></div><p class=MsoNormal style='margin-left:1.5in'><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div><p class=MsoNormal style='margin-left:1.5in'> <o:p></o:p></p></div></div></div></div></div><p class=MsoNormal style='margin-left:.5in'><br><br><br><o:p></o:p></p><pre style='margin-left:.5in'>_______________________________________________<o:p></o:p></pre><pre style='margin-left:.5in'>postgis-devel mailing list<o:p></o:p></pre><pre style='margin-left:.5in'><a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a><o:p></o:p></pre><pre style='margin-left:.5in'><a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><o:p></o:p></pre></blockquote><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div></body></html>