Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Add multi-order coverage (MOC) support to pgsphere#1

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
feodor merged 80 commits intopostgrespro:masterfrommsdemlei:add-moc
Jul 28, 2021

Conversation

@msdemlei
Copy link
Contributor

This PR, developed by Credativ inhttps://github.com/credativ/pgsphere/, adds support for IVOA Multi-Order Coverage maps (https://ivoa.net/documents/MOC/). They can be serialised and deserialised (to ASCII MOCs), they can be produced from polygons and circles, the can be intersected and joined. A simple indexing scheme is also provided.

Markus Nullmeierand others added30 commitsApril 22, 2021 13:57
Some index scans use commutated operators in PG12
Usage of PGXS is the normal case, so prefer that.
While at it, upgrade to -O2 and -fPIC.
PG13 doesn't work yet: pgs_moc.h:11:31: fatal error: access/tuptoaster.h: No such file or directory
We get the function from libhealpix-cxx-dev, while still usinghealpix_bare for the basic pixel operations
... and use the pgsphere coordinate convention for lat
df7cband others added27 commitsApril 22, 2021 14:01
For GIN indexing, we degrade all mocs to fixed level MOC_GIN_ORDER (5),and for each pixel, the index stores the set of all mocs where thispixel appears in.The query is degraded to the same level, and the GIN index is queriedfor these pixels.For intersects (&&) operations, a match is found if at least one pixelmatches. Since we are operating on degraded input, rechecking againstthe original moc is required.
This is thrown by the C++ healpix lib when a polygon is not convex.
Planning logs buffer usage now as well.
@obartunov
Copy link

obartunov commentedApr 23, 2021 via email

Thanks for PR, we will test it.
On Thu, Apr 22, 2021, 15:12 msdemlei ***@***.***> wrote: This PR, developed by Credativ inhttps://github.com/credativ/pgsphere/, adds support for IVOA Multi-Order Coverage maps (https://ivoa.net/documents/MOC/). They can be serialised and deserialised (to ASCII MOCs), they can be produced from polygons and circles, the can be intersected and joined. A simple indexing scheme is also provided. ------------------------------ You can view, comment on, or merge this pull request online at:#1 Commit Summary - pgsphere_1.1.4.916 - comment fixes - healpix_bare support added. - Compatibility with PostgreSQL 11 for GAVO extensions - init_test.out diffs - No longer putting .git into the tarball - ignore past Chealpix oddities - Import healpix_bare 1.0 - Add .gitlab-ci.yml - Add alternate expected output file for PG12 - Ignore more build artifacts - Makefile: Default to USE_PGXS - Build healpix_bare directly from toplevel Makefile - Only override CXXFLAGS on PG10 and older - doc: Fix syntax of CREATE INDEX statement - Add .travis.yml - Bump version to 1.2.0 and implement smoc_union aka || - Call add_to_map directly without going through add_to_moc - Implement smoc_intersection aka * - sum() and intersection() aggregates - Implement = and <> on smoc - Add smoc_disc(order, theta, phi, radius) - Upgrade travis to bionic to get newer libhealpix-cxx-dev - Remove unused empty file - Use | and & for moc union and intersection - Variables cleanup - Check order in smoc_disc - create_moc_release_context always returns 1, change to void and remove error checking in callers - Implement smoc-from-scircle, and swap order of arguments in smoc_disc - Implement smoc overlap - Fix variable declaration warnings - Run tests with -Werror - Add missing function prototypes - Simplify linking with g++ - Makefile: Suppress declaration-after-statement in healpix_bare.c - Refresh sparse.c and sscan.c - Add IMMUTABLE and PARALLEL SAFE decorators to moc functions - Ignore tags file - Move conv_theta and math constants to new header pgs_util.h - Implement smoc(order, spoly)::smoc - Comment all functions and operators - Add smoc subset operators - Use query_*_inclusive and add more test cases - Fix format warning on 32 bit - Fix spoly detoasting in smoc_spoly() - Drop MOC_FORMAT_64X and obsolete code using it - Add smoc_info() function - Remove redundant variable - Speed up smoc_eq by detoasting header only first - Test equality on a large smoc - Speed up overlaps operation by looking at the smoc header first - Speed up subset operations by looking at the smoc header first - Add smoc rounding function that converts smocs to lower order - Test smoc_round on level 0 - GIN index support - GIN: check && 'empty' - Use space as moc interval separator as per recent standards - Implement subset/superset for GIN - Rename smoc_round to smoc_degrade - Refactor gin_extact functions - Add a second gin opclass smoc_gin_ops_fine using level 8 - Add smoc(order, spoint) function - Store original moc order - Include stored moc order in output - Catch PlanckError - doc/Makefile: Default to USE_PGXS and openjade, and build docs during tests - PG13 compatibility - doc: smoc type - smoc documentation - Support equality lookups - Implement inequality index lookups - Remove beta README.GAVO file - Expand docs with more smoc details - Rename smoc_area to area and make it return steradians - moc: Fix regression test deviation on i386 - Fix smoc_degrade bitmask on 32bit - Rename internal function moc_round to moc_degrade for consistency - Fix gin key extraction on 32bit - Accept varying moc100 regression output on 32bit - Add new expected output files for PG13 File Changes - *M* .gitignore <https://github.com/postgrespro/pgsphere/pull/1/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947> (8) - *A* .gitlab-ci.yml <https://github.com/postgrespro/pgsphere/pull/1/files#diff-037ea159eb0a7cb0ac23b851e66bee30fb838ee8d0d99fa331a1ba65283d37f7> (22) - *A* .travis.yml <https://github.com/postgrespro/pgsphere/pull/1/files#diff-6ac3f79fc25d95cd1e3d51da53a4b21b939437392578a35ae8cd6d5366ca5485> (30) - *M* Makefile <https://github.com/postgrespro/pgsphere/pull/1/files#diff-76ed074a9305c04054cdebb9e9aad2d818052b07091de1f20cad0bbac34ffb52> (172) - *M* doc/Makefile <https://github.com/postgrespro/pgsphere/pull/1/files#diff-f48ddfd1eec38c4d39f84e195259371f8397cd30146f46b113bdcb4590ed262c> (7) - *M* doc/constructors.sgm <https://github.com/postgrespro/pgsphere/pull/1/files#diff-29f408668066752c862d63626faa3baead1a54518fff5b3d083a402ccbb0e4a7> (46) - *M* doc/functions.sgm <https://github.com/postgrespro/pgsphere/pull/1/files#diff-0180546dcadb87a25b4e0163d2f31e9c231e7bf6bb5bfb68c469bdde943aea0c> (73) - *M* doc/img/Makefile <https://github.com/postgrespro/pgsphere/pull/1/files#diff-7fed41f968335b44d6dd01a6ad72dd030746ead066c76f9d6b600a91407256b1> (3) - *D* doc/img/logo.jpg <https://github.com/postgrespro/pgsphere/pull/1/files#diff-f220f06c1ec6b50bf94447698ce36646558fd3e5bdb842127ca27b02e97214db> (0) - *A* doc/img/logo.png <https://github.com/postgrespro/pgsphere/pull/1/files#diff-fc78cd769239ef24e5fc6ab741fc80e8547605279ec95803a8ae185a8292bfbd> (0) - *M* doc/img/logo.xcf <https://github.com/postgrespro/pgsphere/pull/1/files#diff-d4faec13081ffdda7fb0a5df0a1231862e8d007cbafbe9d8d1e75908c3e0f9d9> (0) - *A* doc/img/smoc.png <https://github.com/postgrespro/pgsphere/pull/1/files#diff-e1b8d916dbbd62af112dea14afd08dd0b26f68e9d96e77c8660867426a01c5fb> (0) - *M* doc/indices.sgm <https://github.com/postgrespro/pgsphere/pull/1/files#diff-2a449b2ee27b81ecb5623950fe73125a7fa917450e5cb392569e128c9e526655> (45) - *M* doc/operators.sgm <https://github.com/postgrespro/pgsphere/pull/1/files#diff-599b701bba2d7aeba66e2bb253e45ea505619cb84affd806e61c2f15f5359ce1> (47) - *M* doc/pg_sphere.dsl-dist <https://github.com/postgrespro/pgsphere/pull/1/files#diff-993b767f7daa1fefa73d22b57576e2674c961d96ecd2747fcedc58b4f4c37df0> (3) - *M* doc/pg_sphere.xml <https://github.com/postgrespro/pgsphere/pull/1/files#diff-f93019561c828917548ada576f5cb4334448deefc71bc2c1f2fa5a96b3a6990d> (7) - *M* doc/types.sgm <https://github.com/postgrespro/pgsphere/pull/1/files#diff-f65e160e10e0e9cd924f723d4d78681e35a363b1eb394852a75f3335d7017480> (69) - *M* expected/bounding_box_gist.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-55c855d45b692ffa9ab724208a013f64561c7111492294ddca787f78ff40390b> (151) - *A* expected/bounding_box_gist_1.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-fa4d8a691ed3a2bfb989a5739076fbb95f7a68c48b0aeeec4aee4b96c62ddc74> (240) - *A* expected/healpix.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-07e58ecbf5a0a9592722ace822fe14067526490271e25341ceda36a7f3d3d012> (16847) - *M* expected/index.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-244624d8e6ce6511db1720b066f2b1c1cc26e34574758e636b46c6eb933ff38f> (28) - *A* expected/index_9.5.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-541e8ef2a97fa53328d76d293f8c0ac3e363b7897d0238bb016fec9d3b72b441> (62) - *A* expected/init_test.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-69cc48c563eaece9766bf637a45e3090a42a6b75fcf7c495792d757d9fbf800f> (37) - *A* expected/moc.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-dcff666f94878f03fec9f7513173419531c83e988d9a9f21ed40405f3f5e5b30> (779) - *A* expected/moc1.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-8e579a384fbe45252a7fc6315617404c5dfb3ed6aca40bb35d6c00eeac988c0c> (120) - *A* expected/moc100.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-e6e1fab1fb137177d19d722f005e23c9945f03816a06091a27040eae40b65247> (252) - *A* expected/moc100_1.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-4c325cd450a79a567df8a81bfc5b47393807025595520fef89e0feb0d368fdbe> (252) - *A* expected/moc100_2.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-17bf4cace6341e865ddbeb1f7aeafea589d499f32a03cac1c0678a9631401cab> (286) - *A* expected/moc100_3.out <https://github.com/postgrespro/pgsphere/pull/1/files#diff-460ba1d5e4c8bd3919860f8e5e5995d0092a271dd94ecdcfeacbdf36469e477b> (286) - *M* gist.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-932a1fb7a6ab1f29131f5f950ad2ca62db0c33abd39cf83a0df4cb7279b8764a> (429) - *M* gist.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-22553ff2d171cf28564173fc47424cfb63bc91db166b1fa1c6fb52b9057b8048> (8) - *M* gnomo.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-3632544ed95e0ff9f10476d7b255af4947e4e9b27a37509400346ff65a8519d3> (5) - *A* gnomo.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-2973050036006f2d8c43fdbddd178a9b3994226a116420e39306fc0261df3849> (9) - *M* gnomo.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-d3f687a9e238d735210f3dfa743fcb44ae4d619889a2d56073be1e55fd1afb6c> (4) - *M* gq_cache.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-a456be67f2b47f37f1cc7cf39fee82494dc68b3b1652beed02c826479fb52782> (12) - *A* healpix.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-66e34909e7129b501f31870f0bfa90dca040aa4bef935b89b464067358e3813f> (233) - *A* healpix.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-382c0e2a08a48ff4c5486398988d7a2b013222e16f3707ae0c2a12679927b7e0> (99) - *A* healpix_bare/LICENSE <https://github.com/postgrespro/pgsphere/pull/1/files#diff-a08aeebb33617e40ccb3dffe729e03a843b5afc5a9492f8d2d4ab2de041e945f> (29) - *A* healpix_bare/NEWS <https://github.com/postgrespro/pgsphere/pull/1/files#diff-98ded5bc53f1944f8a008e48881def3bd60473f2181f95e3523dfd5d07dcc138> (2) - *A* healpix_bare/README <https://github.com/postgrespro/pgsphere/pull/1/files#diff-aabfc75e15de5a9a10267d6d60dc0a58986b9f30db99b0ceabb9482fa5b5b88b> (42) - *A* healpix_bare/healpix_bare.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-928b1feab70d3e950c92ed49301bf2e2281726ac8fcc72b00bf53bf6a21680d0> (310) - *A* healpix_bare/healpix_bare.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-1e1cd70acc8cccd919fc51201e2c0f828bd18b0b9cdcafaa6eeb794e55b074ca> (118) - *A* healpix_bare/test.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-c2a797f192a295b3da58a09f4bb859c9ebdff501431dad3fa60747d0a85387b7> (129) - *A* index_9.5 <https://github.com/postgrespro/pgsphere/pull/1/files#diff-5f7a2e5533df6bb8117cf33b42e2ee0751ea46d377cdba5373e9c371662dc5f8> (0) - *M* key.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-5c83bfa9863a8ec3e7bcd9a86671123047c884eef2a156f4b6824a66bb341f9b> (28) - *A* moc.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-350c5520cae4660aff3936f738f8cd116a15f37e5e8ff73a8ae80d0678d61fd8> (1204) - *M* path.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-dd5e9dc8fe1f52308750c5b22086433b63835d5a70fc1d0b910fba8b1aceb694> (4) - *M* path.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-ef57d519f1a2a1355f11a493b14895f20280b020c5f1a140994aa286219c77df> (6) - *A* pg_sphere--1.2.0.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-245617666e9634da59648218578e84d6b38f40e596bbd37bdb39cb66ecb8368a> (2) - *M* pg_sphere.control <https://github.com/postgrespro/pgsphere/pull/1/files#diff-9e7a22ef5c901657b32e6e7022b3e1f7a32aabc7f7c24193e87b5704958806b0> (2) - *M* pg_sphere.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-daecd1bd44d2cb0d6f78aca21ea4f7f323964e701fb5707c899fb34e75e207c0> (13) - *A* pgs_9.5.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-032dd0e72068d1aa8ea33ac336d4bc6ae00e3fc1905b2edb72828325931406ef> (7) - *A* pgs_chealpix.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-801b4bbd21b53fd71b94cf715a18d93cf3bc4b43f40838a732265b1cb31b7e4f> (16) - *M* pgs_contains_ops.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-01cce773ef9b51e3c164594888acd89e7a5201a9f7ebd3154e7f50441191ae09> (6) - *M* pgs_contains_ops_compat.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-668a9b51c203c97b391329c365f1d900893187ad9ea823153494fea24849fe5b> (6) - *M* pgs_gist.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-61dbd08710a3458793db82665eaa7ef79348b10170edead87af8b3a5a2261c83> (2) - *A* pgs_gist_pointkey.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-6b7362176cb2382d3cbb721a8a0b728dddf28d7e8af19132f3a44984293e8eda> (38) - *A* pgs_gist_spoint3.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-8b8e4c488653f9be13166d3a7b2fd88775432c44e470bb6ea5362b718194e060> (69) - *A* pgs_healpix.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-014752725b6a9b4f034894c64922658baed265cb1893e17cbcffce41df4bf6f2> (34) - *A* pgs_moc.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-2ad8bcf9ba5e4c6699b8a89f95ab29bc6d778c46277c84aa6aa0a2bf64bb7f29> (133) - *A* pgs_moc_compat.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-155743fe3670cc46d12c89d08cfc1de3cfabeaa84c83c504bceeedc8371467d7> (22) - *A* pgs_moc_ops.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-c6ad7d4c904835e5a3b024f22c417952ef58751e43fdba286cc407ae5135bf65> (372) - *A* pgs_moc_type.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-a38d8907bb4b1c299e394b91d015931aa799b83a16193c3cf08d860a238fff35> (169) - *A* pgs_process_moc.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-584164001e6d634de32c9507d04b8dae579f9dbd46966b2f2041e1bda5f52931> (172) - *A* pgs_util.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-e711032045c806a057665170850d7e5dea6cc69df710e6a2056c0a94bb6cf2f4> (29) - *M* polygon.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-953f22d2ad4b27c4f34ec5b46ef8b6c39d25326c7ce951858692fc03bbd98dde> (2) - *M* polygon.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-d16cfe773a607f041fdada277fd22b184d6660ee4632c381e789d28339de2389> (6) - *A* process_moc.cpp <https://github.com/postgrespro/pgsphere/pull/1/files#diff-d927e91feaa6409d554e93926c6a9c4556b1ef403aa55d3b4021398ac2323acf> (1050) - *M* sparse.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-7fc8acec3ffc4781b4d5874c70a457d8be5c82925042dcbfe992926f4d33958d> (392) - *M* sparse.h <https://github.com/postgrespro/pgsphere/pull/1/files#diff-4b220cb76a00154ef68645bf54bc269b72d4bee08e1f02b0b6c30f16b39bb37a> (15) - *M* sql/bounding_box_gist.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-b88659ae343f6c5f02132c8ed42e35b76da41566117c03a80e6f8ae0ce880779> (23) - *A* sql/healpix.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-eba6c6c47a48a84d4b5b075ac86dbe2fa46a976fb11a9b50a357cff245e51035> (2866) - *M* sql/index.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-cafcdf2fbc095f14d50c0f1dfa06f99e6631ec392ef9d4219d6d87b6d96e24d3> (10) - *A* sql/index_9.5.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-464075507742281db71e2ea98c00acd1d3335e08264f3cc8638112cd754cf836> (18) - *A* sql/init_test.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-30ce40254cc1b230b307eadbe383196a01652470b3dbb8990c068dfb2709d5cf> (4) - *A* sql/moc.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-aa38d50d96ccf65ea78fa892b32e697ffd2c76f952137577427bc5b78313c07c> (177) - *A* sql/moc1.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-e59f9d0cf0f6fe3d8123a556f30c74fa5f4996489dbd9c1eff41f6accb0188f3> (40) - *A* sql/moc100.sql <https://github.com/postgrespro/pgsphere/pull/1/files#diff-0bdda40df11a0299794a2115585f631464089c3c571817f94146075347b4c3a7> (166) - *M* sscan.c <https://github.com/postgrespro/pgsphere/pull/1/files#diff-58bfcf8e8ce047e76dc5048fe2ac354d9aaaf907ef38d783fd64301f9a49fecc> (2140) - *A* test_top_build_dir/Makefile <https://github.com/postgrespro/pgsphere/pull/1/files#diff-7239c7cd65b2dc331adce11dac56a29a29cede61a04b7cc16437cff5d5aba082> (2) - *A* upgrade_scripts/contains-ops-fixes-1.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-0b1f71a583b00285e02802b49096bb1bd9a815f47afc8ddb853f5f60746a092a> (39) - *A* upgrade_scripts/contains-ops-fixes-2.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-99351ecaecb2e18abd1f0f6783392420877c78e253d513f9d50881851aafa7bd> (26) - *A* upgrade_scripts/pg_sphere--1.0--1.0_gavo.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-6a049c99d3c041738f4bcf6a6a29ae6d5f9c427d6d0637d80ef93c3450ccb1b3> (2) - *A* upgrade_scripts/pg_sphere--1.0--1.1.5_from_2015-08-31.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-ca2e742a8200dc7a5fe2110f63c4cd6909003701f566b15f7bcbad1b50d2cdf7> (2) - *A* upgrade_scripts/pg_sphere--1.0--1.1.5_from_2016-02-07.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-9cc327e02cd045aff87dc31e0f22a687b81e9b9e940e5be0ea952b69f0e93101> (2) - *A* upgrade_scripts/pg_sphere--1.0_gavo--1.1.5beta0gavo.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-b3f42f60d8f35fb472d78da5f002ccebd0ecac044239b03a24c01bb9926a9dad> (2) - *A* upgrade_scripts/pg_sphere--1.1.5--1.1.5.1.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-31fa50a52712ef455a70f017e2880e4ea0c6c26e51859a5d8e57d31518f97804> (2) - *A* upgrade_scripts/pg_sphere--1.1.5_from_2015-08-31--1.1.5.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-72cbe86ca12eee376c20ffe72b7a2bd5ad64ec408d2d40d9341cc9f3bf5b3b7a> (2) - *A* upgrade_scripts/pg_sphere--1.1.5_from_2016-02-07--1.1.5.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-984c3e7fb56c57ee8e2cc805395c42b6fc9c4603b42427a1412064837b19f6cd> (2) - *A* upgrade_scripts/pg_sphere--1.1.5beta0gavo--1.1.5beta2gavo.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-2317dcaff2c2090bcf1956fbb26744c662fe22abf52ca143e2d12bfccdc6c5a5> (2) - *A* upgrade_scripts/pg_sphere--1.1.5beta2gavo--1.1.5beta4gavo.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-9aedc02770a9c04f54b57ab201977d9a6889fdfa993b3d4313d01377055adee4> (2) - *A* upgrade_scripts/pg_sphere--unpackaged--1.1.5.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-2d0b359fe16aaf178a9204aaf911595aea40fc759830b13f5f8e5a39cdde42ff> (2) - *A* upgrade_scripts/pg_sphere--unpackaged--1.1.5beta0gavo.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-4ea24dd5434152d1cd0bd216d697a50917d80993597d0b1118b1993337df70bb> (2) - *A* upgrade_scripts/pgs_box.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-006d2586c625ee8528190a6bc1c173777c4d4524cd054bd4ba201ac83e6fd317> (95) - *A* upgrade_scripts/pgs_circle.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-6c0eb4d5da68a16d9efafebd6f6ae75e8473fea54fa887a56cc6a1f5ecbc6346> (31) - *A* upgrade_scripts/pgs_contains_ops_compat.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-c95d34b371050dbdd8e46945bf5444e995697f990a47080232540906c93d4e75> (120) - *A* upgrade_scripts/pgs_ellipse.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-9ad8fa05a05a8a8ed99b589e5985c119c598a12a023b7fc64191f56aa51cd071> (55) - *A* upgrade_scripts/pgs_euler.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-4e2397c006783c34d395e153f727463cefbaf9f755b7025fb086680928db79dc> (23) - *A* upgrade_scripts/pgs_gist.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-d1291b95e497384451b098aa4ddcff7650af4e7652d23d9d78b664c5b3d960f6> (27) - *A* upgrade_scripts/pgs_gist_contains_ops.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-0650efea6236c2ab122252a8898b57552c3e3c1452c622f14efda482a0b590ef> (73) - *A* upgrade_scripts/pgs_gist_drop_spoint2.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-8b47abc8db3e2b06917bea4452f465e58fa62c47b399d031592efc7373941117> (11) - *A* upgrade_scripts/pgs_line.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-f34dd0c614d07d1e641fa4fc97ba7e605e49c6d3a168bf80aa4f54a723b4539b> (41) - *A* upgrade_scripts/pgs_path.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-53f80fa22aba27c5b3b42e06b717c972d1b1d99bdb0ba6de429095c005316b26> (67) - *A* upgrade_scripts/pgs_point.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-0b0bdeedb710d72ae2f6efeeec26f8bfbaff4996f00e475c6ef9e22b3d8a8466> (14) - *A* upgrade_scripts/pgs_polygon.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-c3c27e02f30614e636a4bd46b9e2cf7e99fb34444629573101342ef2ec240378> (68) - *A* upgrade_scripts/pgs_pre111.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-c56c46c590a4fe147b6d1b7c527072c4d6fcd60d3eda56cf86f58f69b682352f> (7) - *A* upgrade_scripts/pgs_types.sql.in <https://github.com/postgrespro/pgsphere/pull/1/files#diff-042c47d7fee6d5f7f99007f513afb4147db539a263ca1cab0376781386d893e3> (24) Patch Links: -https://github.com/postgrespro/pgsphere/pull/1.patch -https://github.com/postgrespro/pgsphere/pull/1.diff — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABQURYTZVLLA5K7EMAKTDILTKAHCRANCNFSM43MKRFYQ> .

@feodorfeodor merged commit7ff66ac intopostgrespro:masterJul 28, 2021
@vitcppvitcpp mentioned this pull requestJul 19, 2023
Sign up for freeto join this conversation on GitHub. Already have an account?Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

5 participants

@msdemlei@obartunov@feodor@jontxu@df7cb

[8]ページ先頭

©2009-2025 Movatter.jp