<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)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:Aptos;}
@font-face
{font-family:"ITC Avant Garde Std Bk";
panose-1:2 11 5 2 2 2 2 2 2 4;}
@font-face
{font-family:"ITC Avant Garde Std Md";
panose-1:2 11 6 2 2 2 2 2 2 4;}
@font-face
{font-family:"var\(--font-mono\)";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Nur Text Zchn";
margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.NurTextZchn
{mso-style-name:"Nur Text Zchn";
mso-style-priority:99;
mso-style-link:"Nur Text";
font-family:"Calibri",sans-serif;}
span.E-MailFormatvorlage27
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:35393894;
mso-list-template-ids:1319012308;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:795175683;
mso-list-template-ids:606340630;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2
{mso-list-id:846745597;
mso-list-template-ids:-1034796846;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3
{mso-list-id:2021203404;
mso-list-template-ids:-1911141766;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style></head><body lang=DE link="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Moin,<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>folgende PostgreSQL-Fehler (falschen Datentyp bei signaturnummer) erhalten ich, wenn ich ein QGIS-Projekt mit den NAS-Daten (ALKIS-Import 4.1-23) über den QGIS-Server nutze. Die „signaturnummer“ sollte wohl INTEGER sein?<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Beispielhafte Fehlereinträge in der Log-Datei vom QGIS-Server:<br><br></span><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>2025-10-17 11:09:05,387 WARNING [94140] Qgis: PostGIS: Query: BEGIN READ ONLY;DECLARE qgis_98 BINARY CURSOR FOR SELECT st_asbinary(st_simplify( st_removerepeatedpoints("line",5.29311), 4.63147, true ),'NDR'),"ogc_fid","signaturnummer"::text FROM "public"."po_lines" WHERE (("line" && st_makeenvelope(401127.04632999998284504,5334679.79271748661994934,415822.03405399998882785,5341640.22814551368355751,25832)) AND (((thema='Politische Grenzen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT LIKE 'ax_flurstueck%'))))) AND ("signaturnummer" IN (2016,2018,2020,2010,2022,2014,2012)) returned 7 [ERROR: operator does not exist: character varying = integer<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>LINE 1: ... LIKE 'ax_flurstueck%'))))) AND ("signaturnummer" IN (2016,2...<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> ^<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>HINT: No operator matches the given name and argument types. You might need to add explicit type casts.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>]<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>2025-10-17 11:09:05,387 WARNING [94140] Qgis: PostGIS: 1 cursor states lost.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>SQL: BEGIN READ ONLY;DECLARE qgis_98 BINARY CURSOR FOR SELECT st_asbinary(st_simplify( st_removerepeatedpoints("line",5.29311), 4.63147, true ),'NDR'),"ogc_fid","signaturnummer"::text FROM "public"."po_lines" WHERE (("line" && st_makeenvelope(401127.04632999998284504,5334679.79271748661994934,415822.03405399998882785,5341640.22814551368355751,25832)) AND (((thema='Politische Grenzen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT LIKE 'ax_flurstueck%'))))) AND ("signaturnummer" IN (2016,2018,2020,2010,2022,2014,2012))<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Result: 7 (ERROR: operator does not exist: character varying = integer<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>LINE 1: ... LIKE 'ax_flurstueck%'))))) AND ("signaturnummer" IN (2016,2...<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> ^<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>HINT: No operator matches the given name and argument types. You might need to add explicit type casts.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>)<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Hat das schon jemand bemerkt oder tritt das nur bei mir auf?<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Könnte signaturnummer direkt als INTEGER statt VARCHAR beim Import angelegt werden?<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Mit dem unten genannten Workaround sind die Fehler verschwunden.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Viele Grüße<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Günter<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-family:"ITC Avant Garde Std Bk",sans-serif;color:#E36C0A;mso-fareast-language:DE'>WAGNER-</span></b><span style='font-family:"ITC Avant Garde Std Md",sans-serif;color:#1F497D;mso-fareast-language:DE'>IT</span><b><span style='color:#1F497D;mso-fareast-language:DE'><o:p></o:p></span></b></p><p class=MsoNormal><span style='mso-fareast-language:DE'>Ingenieurbüro für Geoinformatik</span><b><span style='font-size:12.0pt;color:#1F497D;mso-fareast-language:DE'><br></span></b><span style='mso-fareast-language:DE'>Carl-Orff-Weg 7<br>79312 Emmendingen<br>Tel.: 07641/9621668<br>Fax: 07641/915599<br><a href="http://www.wagner-it.de/"><span style='color:blue'>www.wagner-it.de</span></a><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>----------------------------------------------------------<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Analyse der KI:<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:13.5pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Umgebung:<o:p></o:p></span></b></p><ul type=disc><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>PostgreSQL Version:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> 16.10<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>QGIS Server Version:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> 3.40.11<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>PostGIS Version:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> 3.4.3<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Norbit Import-Tool:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> 4.1-23<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Betriebssystem:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> Ubuntu 24.04 LTS<o:p></o:p></span></li></ul><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:13.5pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Problem:<o:p></o:p></span></b></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Die Spalte </span><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>signaturnummer</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> in den Tabellen </span><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>po_lines</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>, </span><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>po_points</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> und </span><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>po_polygons</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> wird als Datentyp </span><b><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>character varying</span></b><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> (VARCHAR)</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> angelegt.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Aktueller Import:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>sql<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>|</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>character</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>varying</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:13.5pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Auswirkung:<o:p></o:p></span></b></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>QGIS-Server führt Abfragen mit <b>Integer-Werten</b> durch:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>sql<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>SELECT</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> ... </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>FROM</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_lines <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>WHERE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>IN</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> (</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2016</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>, </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2018</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>, </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2020</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>, </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2010</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>, </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2022</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>, </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2014</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>, </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2012</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>)<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>```<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>Dies führt zu PostgreSQL-Fehlern:<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>```<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>ERROR: operator does </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>not</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> exist: </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>character</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>varying</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>=</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>LINE </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>1</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>: ... </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>AND</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> (</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#50A14F;mso-ligatures:none;mso-fareast-language:DE'>"signaturnummer"</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>IN</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> (</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2016</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>,</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2018</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>,</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2020</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>,</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2010</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>,</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2022</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>,</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2014</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>,</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>2012</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>))<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>HINT: </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>No</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> operator matches the given name </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>and</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> argument </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>types</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>. You might need </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>to</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>add</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> explicit </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>type</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> casts.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Folge:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></p><ul type=disc><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2 level1 lfo1'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Rendering-Fehler bei Layer "Politische Grenzen"<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2 level1 lfo1'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Performance-Einbußen<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2 level1 lfo1'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Fehlerhafte Darstellung<o:p></o:p></span></li></ul><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:13.5pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Lösung:<o:p></o:p></span></b></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Die Spalte sollte als Datentyp </span><b><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>integer</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> erstellt werden:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>sql<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>|</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:13.5pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Betroffene Tabellen:<o:p></o:p></span></b></p><ul type=disc><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level1 lfo2'><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>po_lines.signaturnummer</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level1 lfo2'><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>po_points.signaturnummer</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level1 lfo2'><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>po_polygons.signaturnummer</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><o:p></o:p></span></li></ul><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:13.5pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Workaround (manuell nach jedem Import):<o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>sql<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>ALTER</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TABLE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_lines <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>ALTER</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>COLUMN</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TYPE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>USING</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer::</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>;<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>ALTER</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TABLE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_points <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>ALTER</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>COLUMN</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TYPE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>USING</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer::</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>;<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>ALTER</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TABLE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_polygons <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>ALTER</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>COLUMN</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TYPE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>USING</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer::</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>integer</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>;<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>REINDEX </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TABLE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_lines;<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>REINDEX </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TABLE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_points;<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>REINDEX </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>TABLE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_polygons;<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>Hinweis:</span></b><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> Bei </span><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>po_points</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> können auch Text-Werte wie </span><span style='font-size:10.0pt;font-family:"Courier New";mso-ligatures:none;mso-fareast-language:DE'>"pg-gemarkung"</span><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'> vorkommen. Diese müssen vor der Konvertierung auf NULL gesetzt werden:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'>sql<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>UPDATE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> po_points <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>SET</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>=</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#B76B01;mso-ligatures:none;mso-fareast-language:DE'>NULL</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> <o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm'><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#A626A4;mso-ligatures:none;mso-fareast-language:DE'>WHERE</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> signaturnummer </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#4078F2;mso-ligatures:none;mso-fareast-language:DE'>!~</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'> </span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#50A14F;mso-ligatures:none;mso-fareast-language:DE'>'^[0-9]+$'</span><span style='font-size:10.0pt;font-family:"var(--font-mono)",serif;color:#383A42;mso-ligatures:none;mso-fareast-language:DE'>;<o:p></o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Aptos",sans-serif;mso-ligatures:none;mso-fareast-language:DE'><hr size=2 width="100%" align=center></span></div><p class=MsoPlainText><o:p> </o:p></p></div></body></html>