Citus bug for bingo extension
When I Create table for structure, I got an Error Message, my SQL code is as follow:
CREATE TABLE struct(
id int not null,
binary_molcontent bytea,
primary key (id)
);
create index structIdx on struct using bingo_idx (binary_molcontent bingo.bmolecule);
all the above code was OK;but when I executed the following code:
SELECT create_distributed_table('struct', 'id', 'hash');
I got the error "table struct has dependency on unsupported object "operator class bingo.bmolecule for access method bingo_idx", bingo.bmolecule and bingo_idx are from bingo extension, which can be used in standalone postgresql well
the detailed definition of bmolecule is
CREATE OPERATOR CLASS bmolecule
FOR TYPE bytea USING bingo_idx
AS
OPERATOR 1 public.@ (bytea, sub),
OPERATOR 2 public.@ (bytea, exact),
OPERATOR 3 public.@ (bytea, smarts),
OPERATOR 4 public.@ (bytea, gross),
OPERATOR 5 public.< (bytea, mass),
OPERATOR 6 public.> (bytea, mass),
OPERATOR 7 public.@ (bytea, sim),
FUNCTION 1 matchSub(bytea, sub),
FUNCTION 2 matchExact(bytea, exact),
FUNCTION 3 matchSmarts(bytea, smarts),
FUNCTION 4 matchGross(bytea, gross),
FUNCTION 5 _match_mass_less(bytea, mass),
FUNCTION 6 _match_mass_great(bytea, mass),
FUNCTION 7 matchSim(bytea, sim);
OS System CentOS 7 2009 Postgresql Version 15.10 Citus Version: 12.1.4 bingo extension version :1.28.0
Hi, ihalatci thanks your labeling, here is the more information about bingo extension: the documentation of how to use and install is at the site https://lifescience.opensource.epam.com/bingo/bingo-postgres.html, the source code is at site https://github.com/epam/Indigo