<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Times New Roman'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>OK I got it.</DIV>
<DIV> </DIV>
<DIV>I used append after table delete.</DIV>
<DIV> </DIV>
<DIV>Bob</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV style="FONT: 10pt tahoma">
<DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=rjpawley@shaw.ca
href="mailto:rjpawley@shaw.ca">Bob Pawley</A> </DIV>
<DIV><B>Sent:</B> Wednesday, July 13, 2011 11:29 AM</DIV>
<DIV><B>To:</B> <A title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
</DIV>
<DIV><B>Subject:</B> [postgis-users] ogr2ogr</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Times New Roman'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>I am importing to Postgis using ogr2ogr in overwrite mode so that I can
trigger further actions.</DIV>
<DIV> </DIV>
<DIV>However overwrite seems to drop the trigger function while overwriting the
table.</DIV>
<DIV> </DIV>
<DIV>What would be the best method of importing and triggering a function?</DIV>
<DIV> </DIV>
<DIV>Bob</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></DIV></DIV>
<P>
<HR>
_______________________________________________<BR>postgis-users mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></DIV></DIV></DIV></BODY></HTML>