You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
When I Create table for structure, I got an Error Message, my SQL code is as follow:
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
OS System CentOS 7 2009
Postgresql Version 15.10
Citus Version: 12.1.4
bingo extension version :1.28.0
The text was updated successfully, but these errors were encountered: