Migrating TIGER from Oracle to POSTGIS

[Ayorinde O Adesugba (CENSUS/DITD FED)]

Census - General


The testsuite is interesting... it is a hinderance cause I dont understand all the moving parts.

The ST_GetFaceGeometry has to change to (varchar, int8) in sqlmm.sql.in

That change has been made, but I am unable to run the tests because it keeps reporting that st_getfacegeometry(character varying, integer) does not exist. It refers to COMMENT ON FUNCTION in topology_comments.sql.

I am not sure what file(s) to change so the comments are fixed.

________________________________
Thanks,


Ayorinde Adesugba, Special Assistant to ADC,
Spatial Data Systems, DITD
U.S. Census Bureau
O: 301-763-2057 | M: 202-381-8034 | F: 301-763-4710
ayorinde.o.adesugba at census.gov<mailto:ayorinde.o.adesugba at census.gov>
census.gov<http://www.census.gov/> | @uscensusbureau<https://twitter.com/uscensusbureau>  | 2020Census.gov<https://2020census.gov>
Connect with us on Social Media<http://www.census.gov/about/contact-us/social_media.html>




Census - General

________________________________
From: Sandro Santilli <strk at kbt.io>
Sent: Wednesday, March 19, 2025 13:59
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov>
Cc: postgis-devel at lists.osgeo.org <postgis-devel at lists.osgeo.org>
Subject: Re: Migrating TIGER from Oracle to POSTGIS

On Wed, Mar 19, 2025 at 05:44:12PM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:

> 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.
>
> How do I trigger the comment rebuild.

Comments are generated from the documentation so you should get
get an automated rebuild after editing doc/extras_topology.xml

If you don't, that'd be a bug

See also doc/README in case you want to be more specific about
what you want to build ( spoiler: make -C doc comments )

> 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.

Isn't PostGIS testsuite great ? :)

Feel free to provide an improvement to the run_test.pl script to catch
those kind of errors and suggest a solution.

--strk;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20250319/e0d2c829/attachment.htm>