From: | mazdazip <zip(at)mazdazip(dot)ru> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Adding: The bug in the last version of pgAdmin |
Date: | 2010-02-18 16:18:47 |
Message-ID: | 1376301884.20100218191847@mazdazip.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-02-18 20:52:41 | Re: Adding: The bug in the last version of pgAdmin |
Previous Message | Josh Berkus | 2010-02-17 22:52:03 | Re: Garbage character inserted at the beginning of every SQL file on OSX |