Migrating TIGER from Oracle to POSTGIS

[Ayorinde O Adesugba (CENSUS/DITD FED)]

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>
Sent: Wednesday, March 19, 2025 13:18
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 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/c0280066/attachment-0001.htm>