<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=us-ascii"><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:"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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>The topology_comments.sql is autogenerated from the xml docs.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>To fix it, you need to fix the references in the docs <a href="https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml">https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>e.g. I am not sure which one you are working on but for example this one if you needed the edge to be bigint<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://postgis.net/docs/manual-dev/en/ST_NewEdgesSplit.html">https://postgis.net/docs/manual-dev/en/ST_NewEdgesSplit.html</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Need to change the input integer to bigint and the output to bigint, though the <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml#L2271">https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml#L2271</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba@census.gov> <br><b>Sent:</b> Wednesday, March 19, 2025 1:44 PM<br><b>To:</b> Sandro Santilli <strk@kbt.io><br><b>Cc:</b> postgis-devel@lists.osgeo.org<br><b>Subject:</b> Re: Migrating TIGER from Oracle to POSTGIS<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p align=center style='margin:5.0pt;text-align:center'><span style='font-size:10.0pt;font-family:"Calibri",sans-serif;color:black'>Census - General<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span style='color:black'>Thanks.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>I am facing a more interesting challenge. The topology_comments.sql needs to be updated, so that it references int8 (bigint) instead of integer for a few functions that need to be updated.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>How do I trigger the comment rebuild. I have been stuck on a test for over 2/3 hours cause the comment on the function no longer lines up with the new signature for the function.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div id=Signature><div id=divtagdefaultwrapper><div class=MsoNormal align=center style='text-align:center;background:white'><span style='font-family:"Calibri",sans-serif;color:black'><hr size=2 width="100%" align=center></span></div><div><p class=MsoNormal style='background:white'><i><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'>Thanks, </span></i><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'><o:p></o:p></span></p></div><p style='background:white'><span style='font-family:"Calibri",sans-serif;color:black'><o:p> </o:p></span></p><div><p class=MsoNormal style='background:white'><b><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>Ayorinde Adesugba, </span></b><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>Special Assistant to ADC,<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>Spatial Data Systems, DITD<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>U.S. Census Bureau <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>O: 301-763-2057 | M: 202-381-8034 | F: 301-763-4710 <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'><a href="mailto:ayorinde.o.adesugba@census.gov">ayorinde.o.adesugba@census.gov</a> <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'><a href="http://www.census.gov/" target="_blank">census.gov</a> | <a href="https://twitter.com/uscensusbureau" title="https://twitter.com/uscensusbureau">@uscensusbureau</a> | <a href="https://2020census.gov" title="https://2020census.gov">2020Census.gov</a><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>Connect with us on <a href="http://www.census.gov/about/contact-us/social_media.html" target="_blank">Social Media</a><o:p></o:p></span></p></div><p style='background:white'><span style='font-size:10.0pt;font-family:"Calibri",sans-serif;color:black'> </span><span style='font-family:"Calibri",sans-serif;color:black'><o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p align=center style='margin:5.0pt;text-align:center'><span style='font-size:10.0pt;font-family:"Calibri",sans-serif;color:black'>Census - General<o:p></o:p></span></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="98%" align=center></div><div id=divRplyFwdMsg><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'> Sandro Santilli <<a href="mailto:strk@kbt.io">strk@kbt.io</a>><br><b>Sent:</b> Wednesday, March 19, 2025 13:18<br><b>To:</b> Ayorinde O Adesugba (CENSUS/DITD FED) <<a href="mailto:Ayorinde.O.Adesugba@census.gov">Ayorinde.O.Adesugba@census.gov</a>><br><b>Cc:</b> <a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a> <<a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a>><br><b>Subject:</b> Re: Migrating TIGER from Oracle to POSTGIS</span> <o:p></o:p></p><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt'>On Wed, Mar 19, 2025 at 12:02:36PM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:<br><br>> Is there a way to run a particular test (or tests)?<br><br>For Topology we only have "regress tests", which can be run with the<br>regress/run_test.pl script (run with no args to get help text)<br><br>Example run of a single test from a build dir:<br><br> ${srcdir}/regress/run_test.pl \<br> --topology \<br> -v \<br> ${srcdir}/topology/test/regress/createtopology<br><br>You'll need to have run `make staged-install` before, for the test<br>script to find the postgis libraries and enabler scripts.<br><br>> I am trying to modify a particular test, and it would be great<br>> to focus on that test rather than kicking off the full suite.<br><br>Makes sense.<br><br>--strk;<o:p></o:p></span></p></div></div></div></div></body></html>