<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 10pt; color: #000000'><font face="Arial" size="2">Hallo, </font><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; ">wir haben heute erfolgreich den GDAL Patch getestet.</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; ">Da wir in unserer DB keine Historie benötigen, haben wir </div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; ">die Funktion deleteFeature um den context erweitert.</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; "><br></div><div><font face="Arial" size="2">CREATE FUNCTION deleteFeature(typename text, featureid text, context text )</font></div><div><font face="Arial" size="2"><br></font></div><div><font face="Arial" size="2">Innerhalb der Funktion fragen wir diesen nun ab:</font></div><div><font face="Arial" size="2"><br></font></div><div><font face="Arial" size="2"><div>IF lower($3) = 'delete' THEN</div><div> query := 'DELETE FROM ' || lower($1) || ' WHERE gml_id = ''' || $2 || '''';</div><div> EXECUTE query;</div><div> query := 'DELETE FROM alkis_beziehungen WHERE beziehung_von = ''' || $2 || ''' OR beziehung_zu = ''' || $2 || '''';</div><div> EXECUTE query;</div><div>ELSE</div><div> query := 'DELETE FROM ' || lower($1) || ' WHERE gml_id = ''' || $2 || '''';</div><div> EXECUTE query;</div><div>END IF;</div></font></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; ">Vielen Dank für die Ändernungen!</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 10pt; "><br><br>Schöne Grüße<br><div><div><br></div><div><br></div><div>Wolfgang Jacobs</div><br><hr><p style="font-size: 12pt; "><span style="font-size: 10pt; "><font class="Apple-style-span" face="arial, helvetica, sans-serif"><i>GeoNet GmbH<br>
Möllerstraße 42<br>
45966 Gladbeck<o:p></o:p></i></font></span></p><p style="font-size: 12pt; "><span style="font-size: 10pt; "><font class="Apple-style-span" face="arial, helvetica, sans-serif"><i><br></i></font></span></p>
<p style="font-size: 12pt; "><span style="font-size: 10pt; "><font class="Apple-style-span" face="arial, helvetica, sans-serif"><i>Tel.: <span class="Apple-tab-span" style="white-space:pre"> </span>+49/(0) 2043/20 57 27 0<br>
Durchwahl: <span class="Apple-tab-span" style="white-space:pre"> </span>+49/(0) 2043/20
57 27 14<br>
Fax: <span class="Apple-tab-span" style="white-space:pre"> </span>+49/(0) 2043/20 57 27 29<br>
Email: <span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:volker.winkler@geonet-online.de">mailto:wolfgang.jacobs@geonet-online.de</a><br>
Internet <span class="Apple-tab-span" style="white-space:pre"> </span><a href="http://www.geonet-online.de">http://www.geonet-online.de</a><o:p></o:p></i></font></span></p><p style="font-size: 12pt; "><span style="font-size: 10pt; "><i><br></i></span></p>
<p><i><font class="Apple-style-span" size="1" face="arial, helvetica, sans-serif">Amtsgericht: Gelsenkirchen HRB 4817</font><font class="Apple-style-span" face="Arial, sans-serif" style="font-size: 10pt; "><o:p></o:p></font></i></p><span name="x"></span><br></div></div></div></body></html>