<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;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* 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;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
span.EmailStyle26
{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>No it will not affect the C code. So if the C code doesn’t handle int8, it still needs to be fixed.<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 4:34 PM<br><b>To:</b> lr@pcorp.us; '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><div><p class=MsoNormal>Got it, thanks!<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Will this change affect the c code? I am know getting some error related to edgering. It seems there is a mismatch in the recursive query with integer and int8. I will send the exact error but it seems like the GetFace3’Edges is calling into c code.<o:p></o:p></p></div></div><div id=ms-outlook-mobile-body-separator-line><p class=MsoNormal><o:p> </o:p></p></div><div id=ms-outlook-mobile-signature><div><div><div class=MsoNormal align=center style='text-align:center'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif'><hr size=2 width=361 style='width:270.75pt' align=center></span></div></div><div><p class=MsoNormal><em><span style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Thanks, </span></em><span style='font-family:"Calibri",sans-serif'><o:p></o:p></span></p></div><p style='margin:0in'><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><o:p> </o:p></span></p><div><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Ayorinde Adesugba, </span></strong><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Special Assistant to ADC,</span><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Spatial Data Systems, DITD</span><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>U.S. Census Bureau </span><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>O: 301-763-2057 | M: 202-381-8034 | F: 301-763-4710 </span><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'><a href="mailto:ayorinde.o.adesugba@census.gov">ay</a><a href="mailto:ayorinde.o.adesugba@census.gov">orinde.o.adesugba@census.gov</a> </span><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'><a href="http://www.census.gov/">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></span><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Connect with us on </span><span style='font-size:10.0pt;font-family:"Calibri",sans-serif'><a href="http://www.census.gov/about/contact-us/social_media.html"><span style='font-family:"Arial",sans-serif'>Social Media</span></a></span><o:p></o:p></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'> <a href="mailto:lr@pcorp.us">lr@pcorp.us</a> <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>><br><b>Sent:</b> Wednesday, March 19, 2025 4:29:29 PM<br><b>To:</b> Ayorinde O Adesugba (CENSUS/DITD FED) <<a href="mailto:Ayorinde.O.Adesugba@census.gov">Ayorinde.O.Adesugba@census.gov</a>>; 'Sandro Santilli' <<a href="mailto:strk@kbt.io">strk@kbt.io</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><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 align=left width="100%" style='width:100.0%'><tr><td style='background:#A6A6A6;padding:0in 0in 0in 0in'></td><td width="100%" style='width:100.0%;background:#EAEAEA;padding:0in 0in 0in 0in;background:revert!important;border:revert!important;bottom:revert!important;color:revert!important;direction:revert!important;display:revert!important;font-size:revert!important;height:revert!important;letter-spacing:revert!important;line-height:revert!important;margin:revert!important;opacity:revert!important;order:revert!important;outline:revert!important;overflow:revert!important;padding:revert!important;position:revert!important;tab-size:revert!important;table-layout:revert!important;text-align:revert!important;text-indent:revert!important;text-orientation:revert!important;text-overflow:revert!important;text-transform:revert!important;top:revert!important;vertical-align:revert!important;visibility:revert!important;white-space:revert!important;width:revert!important;word-break:revert!important;word-spacing:revert!important;writing-mode:revert!important;zoom:revert!important;width:100%!important;background-color:#EAEAEA!important;padding:15px!important;font-size:12px!important;font-weight:normal!important;color:#212121!important;text-align:left!important;word-wrap:break-word!important'><div><p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly'><span style='font-family:"Segoe UI",sans-serif;color:black'>You don't often get email from <a href="mailto:lr@pcorp.us">lr@pcorp.us</a>. <a href="https://aka.ms/LearnAboutSenderIdentification">Learn why this is important</a> </span><span style='font-family:"Segoe UI",sans-serif'><o:p></o:p></span></p></div></td><td style='background:#EAEAEA;padding:0in 0in 0in 0in;background:revert!important;border:revert!important;bottom:revert!important;color:revert!important;direction:revert!important;display:revert!important;font-size:revert!important;height:revert!important;letter-spacing:revert!important;line-height:revert!important;margin:revert!important;opacity:revert!important;order:revert!important;outline:revert!important;overflow:revert!important;padding:revert!important;position:revert!important;tab-size:revert!important;table-layout:revert!important;text-align:revert!important;text-indent:revert!important;text-orientation:revert!important;text-overflow:revert!important;text-transform:revert!important;top:revert!important;vertical-align:revert!important;visibility:revert!important;white-space:revert!important;width:revert!important;word-break:revert!important;word-spacing:revert!important;writing-mode:revert!important;zoom:revert!important;width:75px!important;background-color:#EAEAEA!important;padding:5px!important;font-size:12px!important;font-weight:normal!important;color:#212121!important;text-align:left!important;word-wrap:break-word!important'></td></tr></table><div><div><p class=xmsonormal>The topology_comments.sql is autogenerated from the xml docs.<o:p></o:p></p><p class=xmsonormal> <o:p></o:p></p><p class=xmsonormal>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=xmsonormal> <o:p></o:p></p><p class=xmsonormal>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=xmsonormal> <o:p></o:p></p><p class=xmsonormal><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=xmsonormal> <o:p></o:p></p><p class=xmsonormal>Need to change the input integer to bigint and the output to bigint, though the <o:p></o:p></p><p class=xmsonormal> <o:p></o:p></p><p class=xmsonormal><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=xmsonormal> <o:p></o:p></p><p class=xmsonormal> <o:p></o:p></p><p class=xmsonormal> <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=xmsonormal><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) <<a href="mailto:Ayorinde.O.Adesugba@census.gov">Ayorinde.O.Adesugba@census.gov</a>> <br><b>Sent:</b> Wednesday, March 19, 2025 1:44 PM<br><b>To:</b> Sandro Santilli <<a href="mailto:strk@kbt.io">strk@kbt.io</a>><br><b>Cc:</b> <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></div><p class=xmsonormal> <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</span><o:p></o:p></p><p class=xmsonormal> <o:p></o:p></p><div><p class=xmsonormal><span style='color:black'>Thanks.</span><o:p></o:p></p></div><div><p class=xmsonormal><span style='color:black'> </span><o:p></o:p></p></div><div><p class=xmsonormal><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.</span><o:p></o:p></p></div><div><p class=xmsonormal><span style='color:black'> </span><o:p></o:p></p></div><div><p class=xmsonormal><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.</span><o:p></o:p></p></div><div><p class=xmsonormal><span style='color:black'> </span><o:p></o:p></p></div><div id="x_Signature"><div id="x_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=xmsonormal style='background:white'><i><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'>Thanks, </span></i><o:p></o:p></p></div><p style='background:white'><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><div><p class=xmsonormal 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,</span><o:p></o:p></p></div><div><p class=xmsonormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>Spatial Data Systems, DITD</span><o:p></o:p></p></div><div><p class=xmsonormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>U.S. Census Bureau </span><o:p></o:p></p></div><div><p class=xmsonormal 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 </span><o:p></o:p></p></div><div><p class=xmsonormal 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> </span><o:p></o:p></p></div><div><p class=xmsonormal 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></span><o:p></o:p></p></div><div><p class=xmsonormal 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></span><o:p></o:p></p></div><p style='background:white'><span style='font-size:10.0pt;font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p></div></div><p class=xmsonormal> <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</span><o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="98%" align=center></div><div id="x_divRplyFwdMsg"><p class=xmsonormal><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=xmsonormal> <o:p></o:p></p></div></div><div><div><p class=xmsonormal><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;</span><o:p></o:p></p></div></div></div></div></div></div></div></div></body></html>