Re: Operator script error

On Mon, 2012-03-12 at 14:51 +0100, Bartosz Dmytrak wrote:
> 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';
> 

Can you give me the script that allowed you to create the operator? The
script should contain the function definition. Without it, it would be a
lot of work to reproduce your issue.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com