<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
Hi,</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
I'm having an issue upgrading from postgresql 11 postgis 3 to postgresql 12 postgis 3 via pg_upgrade utility. That's because pg_constraint.consrc was removed in postgresql 12 [1]. Is it possible to do such upgrade or do I need to run pg_dumpall and upgrade
semi-manually?<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
```</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<span>pg_restore: from TOC record 219; 1259 722261 VIEW geometry_columns postgres<br>
</span>
<div>pg_restore: error could not execute query: ERROR: column s.consrc does not exist<br>
</div>
<div>LINE 28: "replace"("split_part"("s"."consrc", ''''::"text...<br>
</div>
<span></span>```</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
[1] <a href="https://www.postgresql.org/docs/12/release-12.html" id="LPlnk613520">
https://www.postgresql.org/docs/12/release-12.html</a><br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"></p>
<p class="x_MsoNormal" style="margin-top:0px; margin-bottom:0px; text-align:justify; line-height:14.5pt">
<span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">Mgr. Michal Zimmermann</span><b><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black"></span></b><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black"><b></b></span></p>
<p class="x_MsoNormal" style="margin-top:0px; margin-bottom:0px"><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">M: +420 603 513 860
</span><span style="font-size:12.0pt; color:black"></span><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">|</span><b><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">
</span></b><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">E: michal.zimmermann@gmtech.cz<b>
</b></span><span style="font-size:12.0pt; color:black"></span></p>
<p class="x_MsoNormal" style="margin-top:0px; margin-bottom:0px; line-height:14.5pt">
<span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">GMtech s.r.o.</span><b><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">
</span></b><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black"></span><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">|
</span><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">Michelská 29/6 | 140 00 Praha 4</span><span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:rgb(34,34,34)"></span></p>
<p class="x_MsoNormal" style="margin-top:0px; margin-bottom:0px; line-height:14.5pt">
<span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:black">kancelář Brno: Kounicova 271/13 | 602 00 Brno<b></b></span></p>
<p class="x_MsoNormal" style="margin-top:0px; margin-bottom:0px; line-height:14.5pt">
<span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont""><a href="http://www.symap.cz" target="_blank" rel="noopener noreferrer">www.gmtech.cz</a><span style="color:#222222"></span><b><span style="color:black"></span></b></span></p>
<p class="x_MsoNormal" style="margin-top:0px; margin-bottom:0px; line-height:14.5pt">
<span style="font-size:10pt; font-family:"Arial",sans-serif,serif,"EmojiFont"; color:rgb(34,34,34)"> </span></p>
<p class="x_MsoNormal" style="margin-top:0px; margin-bottom:0px"><span style=""><img class="EmojiInsert" id="OWAPstImg757554" alt="A57BCAFA" style="width:1.0416in; height:0.7916in" width="100" height="76" border="0" data-outlook-trace="F:1|T:1" src="cid:06f3a125-0521-4d59-88d3-7f9c89c7fe3c"></span></p>
<br>
<p style="margin-top:0px; margin-bottom:0px"></p>
</div>
</div>
</body>
</html>