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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
