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

Reply via email to