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(dot)(at)#(NONE, _text) -- Lack of quotation
>
> -- DROP OPERATOR Calc(dot)(at)#(NONE, _text); -- Lack of quotation
>
> CREATE OPERATOR Calc(dot)(at)#(
> PROCEDURE = """Calc"".""doSomething""", -- Wrong quotation
> RIGHTARG = _text);
> COMMENT ON OPERATOR Calc(dot)(at)#(NONE, _text) IS 'this is comment'; -- Lack of
> quotation
>
>
> Schema name and function should be quoted properly:
>
> -- Operator: "Calc"(dot)(at)#(NONE, _text)
>
> -- DROP OPERATOR "Calc"(dot)(at)#(NONE, _text);
>
> CREATE OPERATOR "Calc"(dot)(at)#(
> PROCEDURE ="Calc"."doSomething",
> RIGHTARG = _text);
> COMMENT ON OPERATOR "Calc"(dot)(at)#(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