From: | Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl> |
---|---|
To: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Operator script error |
Date: | 2012-03-12 13:51:56 |
Message-ID: | CAD8_UcZ35wH9GWsTyC47ZsOjdMg8aaWW_DHEXcbThKQg1tT7gg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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';
Regards,
Bartek
From | Date | Subject | |
---|---|---|---|
Next Message | David Greco | 2012-03-12 17:05:13 | Debugger off by one line |
Previous Message | Bartosz Dmytrak | 2012-03-12 13:43:31 | Re: Set schema in pgAdmin |