<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<p style="font-family:Calibri;font-size:10pt;color:#000000;margin:5pt;font-style:normal;font-weight:normal;text-decoration:none;" align="Center">
Census - General<br>
</p>
<br>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);background-color:rgb(255, 255, 255)">
<hr style="margin-right: 0px; margin-left: 0px;">
<div style="margin-right: 0px; margin-left: 0px; font-family: "Default Sans Serif", Verdana, Arial, Helvetica, sans-serif; font-size: 13px;">
<i>Thanks, </i></div>
<p style="margin: 0px;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 13px;"><i><br>
</i></span></p>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;"><b>Ayorinde Adesugba,
</b>Special Assistant to ADC,</div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">Spatial Data Systems, DITD</div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">U.S. Census Bureau </div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">O: 301-763-2057 | M: 202-381-8034 | F: 301-763-4710 </div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;"><a href="mailto:ayorinde.o.adesugba@census.gov" id="OWA56744961-f066-ae94-f4b5-955eb3844b27" class="OWAAutoLink">ayorinde.o.adesugba@census.gov</a> </div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;"><a href="http://www.census.gov/" target="_blank" id="OWAeffdfdac-49d9-b9c0-ad3f-d12bb74e7470" class="OWAAutoLink">census.gov</a> |
<a href="https://twitter.com/uscensusbureau" id="OWA9ffab908-8ac4-361a-93d9-328685f02a59" class="OWAAutoLink" title="https://twitter.com/uscensusbureau">
@uscensusbureau</a> | <a href="https://2020census.gov" id="OWA0f9512c0-bd5f-f438-de68-31334695e34a" class="OWAAutoLink" title="https://2020census.gov">
2020Census.gov</a></div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">Connect with us on
<a href="http://www.census.gov/about/contact-us/social_media.html" target="_blank" id="OWA99125b8d-1b79-a9b4-cc02-a800ab15e693" class="OWAAutoLink">
Social Media</a></div>
<p style="margin: 0px;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 13px;"> </span></p>
</div>
</div>
<div id="appendonsend"></div>
<br>
<p style="font-family:Calibri;font-size:10pt;color:#000000;margin:5pt;font-style:normal;font-weight:normal;text-decoration:none;" align="Center">
Census - General<br>
</p>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Sandro Santilli <strk@kbt.io><br>
<b>Sent:</b> Wednesday, March 19, 2025 13:18<br>
<b>To:</b> Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba@census.gov><br>
<b>Cc:</b> postgis-devel@lists.osgeo.org <postgis-devel@lists.osgeo.org><br>
<b>Subject:</b> Re: Migrating TIGER from Oracle to POSTGIS</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">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;<br>
</div>
</span></font></div>
</body>
</html>