<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 class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The testsuite is interesting... it is a hinderance cause I dont understand all the moving parts.</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The <b>ST_GetFaceGeometry</b> has to change to (varchar, int8) in sqlmm.sql.in</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
That change has been made, but I am unable to run the tests because it keeps reporting that
<b>st_getfacegeometry(character varying, integer)</b> does not exist. It refers to
<b>COMMENT ON FUNCTION in topology_comments.sql.</b></div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I am not sure what file(s) to change so the comments are fixed.</div>
<div class="elementToProof" 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" class="elementToProof">
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0);font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;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">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">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></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">
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:59<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 05:44:12PM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:<br>
<br>
> I am facing a more interesting challenge. The topology_comments.sql<br>
> needs to be updated, so that it references int8 (bigint) instead of<br>
> integer for a few functions that need to be updated.<br>
> <br>
> How do I trigger the comment rebuild.<br>
<br>
Comments are generated from the documentation so you should get <br>
get an automated rebuild after editing doc/extras_topology.xml<br>
<br>
If you don't, that'd be a bug<br>
<br>
See also doc/README in case you want to be more specific about<br>
what you want to build ( spoiler: make -C doc comments )<br>
<br>
> I have been stuck on a test for over 2/3 hours cause the comment on<br>
> the function no longer lines up with the new signature for the function.<br>
<br>
Isn't PostGIS testsuite great ? :)<br>
<br>
Feel free to provide an improvement to the run_test.pl script to catch<br>
those kind of errors and suggest a solution.<br>
<br>
--strk;<br>
</div>
</span></font></div>
</body>
</html>