Skip to content
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 our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Citus bug for bingo extension #7906

Open
jank9201 opened this issue Feb 20, 2025 · 0 comments
Open

Citus bug for bingo extension #7906

jank9201 opened this issue Feb 20, 2025 · 0 comments

Comments

@jank9201
Copy link

jank9201 commented Feb 20, 2025

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant