Home > mailing lists

Operator script error - Mailing list pgadmin-support

From	Bartosz Dmytrak
Subject	Operator script error
Date	March 12, 2012 13:52:52
Msg-id	CAD8_UcZ35wH9GWsTyC47ZsOjdMg8aaWW_DHEXcbThKQg1tT7gg@mail.gmail.com Whole thread Raw
Responses	Re: Operator script error (Guillaume Lelarge <guillaume@lelarge.info>)
List	pgadmin-support

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';

Regards,
Bartek

From: Bartosz Dmytrak
Date: 12 March 2012, 13:44:31
Subject: Re: Set schema in pgAdmin

From: David Greco
Date: 12 March 2012, 17:05:45
Subject: Debugger off by one line