<html 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:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:"Times New Roman \(Body CS\)";
panose-1:2 2 6 3 5 4 5 2 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Georgia",serif;
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="en-NL" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">I think the function
</span>AddGeometryColumn<span style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">
<span lang="EN-US">is deprecated already for some time (now should be </span></span><span lang="EN-US">ST_A</span>ddGeometryColumn<span lang="EN-US">)</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">
</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black">so maybe in postgis v13 it does not work anymore...<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black">yours</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black">-- <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black">Barend Köbben<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black">Senior Lecturer – ITC-GIP & ATLAS, University Twente<br>
PO Box 217, 7500 AE Enschede (The Netherlands) <br>
+31-(0)53 4874 253<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black"><br>
<i>Mon-, Tues-, Thursday afternoons: ITC Building 1-065<o:p></o:p></i></span></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:12.0pt;font-family:"Georgia",serif;color:black">Wednesdays: Citadel building H-100<o:p></o:p></span></i></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal">On 13/10/2020, 16:16, "postgis-users on behalf of Paolo Cavallini" <<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> on behalf of
<a href="mailto:cavallini@faunalia.it">cavallini@faunalia.it</a>> wrote:<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Hi Darafei<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Il 13/10/20 15:55, Darafei "Komяpa" Praliaskouski ha scritto:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<blockquote style="border:none;border-left:solid #B5C4DF 4.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-right:0cm" id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE">
<div>
<p class="MsoNormal"> - is postgis installed into the same database where you are unpacking<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">dump to? common issue is installing to "postgres" database and then<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">expecting to have it in "gis" or "$yourapp" one.<o:p></o:p></p>
</div>
</blockquote>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">sure<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<blockquote style="border:none;border-left:solid #B5C4DF 4.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-right:0cm" id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE">
<div>
<p class="MsoNormal"> - can you share a full reproducer scenario? there are two in the ticket<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">where there is no issue. can you retell step-by-step what you are doing<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">to get an error?<o:p></o:p></p>
</div>
</blockquote>
<div>
<p class="MsoNormal">I get the error when I import from QGIS (which uses GDAL behind the scenes):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">unknown, integer) does not exist<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">RIGA 1: SELECT AddGeometryColumn('public','world_simpl','geom',3857,...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> ^<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">NOTA: No function matches the given name and argument types. You might<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">need to add explicit type casts.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">This on:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">PostgreSQL 13.0 (Debian 13.0-3) on x86_64-pc-linux-gnu, compiled by gcc<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">(Debian 10.2.0-13) 10.2.0, 64-bit<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Whereas exactly the same thing on:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">PostgreSQL 11.9 (Debian 11.9-0+deb10u1) on x86_64-pc-linux-gnu, compiled<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">by gcc (Debian 8.3.0-6) 8.3.0, 64-bit<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">works smoothly, as has always done.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cheers.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">-- <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Paolo Cavallini<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">www.faunalia.eu - QGIS.org<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">training, support, development on QGIS, PostGIS and more<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">_______________________________________________<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">postgis-users mailing list<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</div>
</div>
</body>
</html>