Operator script error

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

Responses

Browse pgadmin-support by date

  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