search

postgrespro / pgsphere

PgSphere provides spherical data types, functions, operators, and indexing for PostgreSQL.
https://pgsphere.org
BSD 3-Clause "New" or "Revised" License
16 stars 15 forks source link

Drop obsolete compatibility @({bigint,spoint}, smoc) operators #92

Closed df7cb closed 8 months ago

df7cb commented 8 months ago

These were required by GAVO DaCHS, but are not used anymore. Furthermore, PG17 will forbid declaring commutators and negators relations with operators that themselves have relations to different operators.

We delete pgs_moc_compat.sql.in and remove it from the old pg_sphere--1.1.5beta2gavo--1.1.5beta4gavo.sql upgrade script. This is ok to do since dropping the operators uses "if exists".

Discussion: https://www.postgresql.org/message-id/flat/ZTfL1G1fBPQHVPWV%40msg.df7cb.de#ce3801c084bcf05b6b976cb2d0e25b2d

Close #85.

df7cb commented 8 months ago

Sorry, I had typoed the "git push --force" command and mistakenly deleted the branch which auto-closed #91. This is the same patch rebased to current master.

vitcpp commented 8 months ago

@df7cb Thank you for the PRs! I propose to make the new release at the beginning of the next week if no new PRs will appear.

df7cb commented 8 months ago

I have another indexing idea in the pipeline that would make sense including with 1.4, so please wait a bit. I should be able to submit it this week.

df7cb commented 8 months ago

@vitcpp I need more time, so please don't wait with 1.4 and go on with a release.