Migrating TIGER from Oracle to POSTGIS

[lr at pcorp.us]

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_top
ology.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_top
ology.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>
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/05b6cc3a/attachment.htm>