Hello, pgadmin-support!
I've wrote about bug in pgAdmin 10.0.
It bug takes place when pgAdmin run under Windows and
sql-server is running on another Linux machine.
> It seems, there are a bug in last version pgAdmin 10.0.
> I see different results of function execution depending on in which
> shell this function was created - psql or pgAdmin.
> Please, try next under both shell
> CREATE OR REPLACE FUNCTION testbug(src text)
> RETURNS text AS
> $BODY$declare
> test text;
> begin
> test = regexp_replace($1, E'\\M|\\m', '''' , 'g');
> RETURN test;
> end;$BODY$
> LANGUAGE 'plpgsql' IMMUTABLE
> COST 100;
> select testbug('a.s.v');
> Under psql the result will be
> testbug
> -------------
> 'a'.'s'.'v'
> it's true
> but under pgAdmin the result will be wrong
> testbug
> -----------
> a.s.v
> Best regards,
> Anton Zakharov,
> Russia.