Migrating TIGER from Oracle to POSTGIS

[Ayorinde O Adesugba (CENSUS/DITD FED)]

Census - General

Got it, thanks!

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.

________________________________
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
ay<mailto:ayorinde.o.adesugba at census.gov>orinde.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: lr at pcorp.us <lr at pcorp.us>
Sent: Wednesday, March 19, 2025 4:29:29 PM
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov>; 'Sandro Santilli' <strk at kbt.io>
Cc: postgis-devel at lists.osgeo.org <postgis-devel at lists.osgeo.org>
Subject: RE: Migrating TIGER from Oracle to POSTGIS

You don't often get email from lr at pcorp.us. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>

The topology_comments.sql is autogenerated from the xml docs.



To fix it, you need to fix the references in the docs  https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml



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



https://postgis.net/docs/manual-dev/en/ST_NewEdgesSplit.html



Need to change the input integer to bigint  and the output to bigint, though the



https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml#L2271







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



Census - General



Thanks.



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



________________________________

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<mailto:strk at kbt.io>>
Sent: Wednesday, March 19, 2025 13:18
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov<mailto:Ayorinde.O.Adesugba at census.gov>>
Cc: postgis-devel at lists.osgeo.org<mailto:postgis-devel at lists.osgeo.org> <postgis-devel at lists.osgeo.org<mailto:postgis-devel at lists.osgeo.org>>
Subject: Re: Migrating TIGER from Oracle to POSTGIS



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

> Is there a way to run a particular test (or tests)?

For Topology we only have "regress tests", which can be run with the
regress/run_test.pl script (run with no args to get help text)

Example run of a single test from a build dir:

  ${srcdir}/regress/run_test.pl \
    --topology \
    -v \
    ${srcdir}/topology/test/regress/createtopology

You'll need to have run `make staged-install` before, for the test
script to find the postgis libraries and enabler scripts.

> I am trying to modify a particular test, and it would be great
> to focus on that test rather than kicking off the full suite.

Makes sense.

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