- Notifications
You must be signed in to change notification settings - Fork15
Closed
Description
PG17 doesn't like thebigint @ smoc
andsmoc @ bigint
operators:
+psql:pg_sphere.test.sql:9968: ERROR: commutator operator @> is already the commutator of operator <@+psql:pg_sphere.test.sql:9978: ERROR: commutator operator @> is already the commutator of operator <@
This is from pgs_moc_compat.sql.in:
-- a minimal set of backwards-compatible operators for GAVO DaCHS,-- see http://soft.g-vo.org/dachsCREATE OPERATOR @ ( LEFTARG = bigint, RIGHTARG = smoc, PROCEDURE = healpix_subset_smoc, COMMUTATOR = '@>', NEGATOR = '!<@', RESTRICT = contsel, JOIN = contjoinsel);CREATE OPERATOR @ ( LEFTARG = spoint, RIGHTARG = smoc, PROCEDURE = spoint_subset_smoc, COMMUTATOR = '@>', NEGATOR = '!<@', RESTRICT = contsel, JOIN = contjoinsel);
The IMHO best fix would be to drop the@
operator. Alternatively, we can drop the COMMUTATOR and NEGATOR clauses.
Comments?
Cc:@msdemlei
Metadata
Metadata
Assignees
Labels
No labels