Hi,
it looks like operator script is generated incorrectly:
eg.
-- Operator: Calc.@#(NONE, _text) -- Lack of quotation
-- DROP OPERATOR Calc.@#(NONE, _text); -- Lack of quotation
CREATE OPERATOR Calc.@#(
PROCEDURE = """Calc"".""doSomething""", -- Wrong quotation
RIGHTARG = _text);
COMMENT ON OPERATOR Calc.@#(NONE, _text) IS 'this is comment'; -- Lack of quotation
Schema name and function should be quoted properly:
-- Operator: "Calc".@#(NONE, _text)
-- DROP OPERATOR "Calc".@#(NONE, _text);
CREATE OPERATOR "Calc".@#(
PROCEDURE ="Calc"."doSomething",
RIGHTARG = _text);
COMMENT ON OPERATOR "Calc".@#(NONE, _text) IS 'this is comment';
Regards,
Bartek