Adding: The bug in the last version of pgAdmin

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.

Responses

Browse pgadmin-support by date

  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