Обсуждение: What is wrong with my pgadmin?

Поиск

Список

Период

Сортировка

What is wrong with my pgadmin?

От

Łukasz Jarych

Дата:

05 марта 2018 г., 20:05:53

Hi Guys,

what is wrong with my pgAdmin?

I am creating wrong query:

select 1/0 but still this is executed!

why?

Best wishes,

Jacek

Вложения

image.png

Re: What is wrong with my pgadmin?

От

Adrian Klaver

Дата:

05 марта 2018 г., 20:22:01

On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
> Hi Guys,
> 
> what is wrong with my pgAdmin?
> 
> I am creating wrong query:
> 
> select 1/0 but still this is executed!

Well it will be executed, but it should throw an error. Can you confirm 
that running select 1/0; in psql does indeed throw an error:

test=# select 1/0;
ERROR:  division by zero

Also:

1) What version of pgAdmin4 are you running?

2) What version of Postgres is it running against?

> 
> 
> 
> why?
> 
> Best wishes,
> Jacek
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: What is wrong with my pgadmin?

От

Martin Moore

Дата:

05 марта 2018 г., 20:27:35

Using pgAdmin 4 2.0 on pg 9.6 and 10 I get div/0 error.



On 05/03/2018, 14:22, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:

    On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
    > Hi Guys,
    >
    > what is wrong with my pgAdmin?
    >
    > I am creating wrong query:
    >
    > select 1/0 but still this is executed!

    Well it will be executed, but it should throw an error. Can you confirm
    that running select 1/0; in psql does indeed throw an error:

    test=# select 1/0;
    ERROR:  division by zero

    Also:

    1) What version of pgAdmin4 are you running?

    2) What version of Postgres is it running against?

    >
    >
    >
    > why?
    >
    > Best wishes,
    > Jacek
    >
    >


    --
    Adrian Klaver
    adrian.klaver@aklaver.com

Re: What is wrong with my pgadmin?

От

Murtuza Zabuawala

Дата:

05 марта 2018 г., 21:06:17

Hello,

This is a bug with pgAdmin4 (Bug: RM#3090).

Work around for this problem is to set

lc_messages = 'en_US.UTF-8'

in "postgresql.conf" file.

Regards,

Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Mar 5, 2018 at 7:57 PM, Martin Moore <martin.moore@avbrief.com> wrote:

Using pgAdmin 4 2.0 on pg 9.6 and 10 I get div/0 error.

On 05/03/2018, 14:22, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:

On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
> Hi Guys,
>
> what is wrong with my pgAdmin?
>
> I am creating wrong query:
>
> select 1/0 but still this is executed!

Well it will be executed, but it should throw an error. Can you confirm
that running select 1/0; in psql does indeed throw an error:

test=# select 1/0;
ERROR: division by zero

Also:

1) What version of pgAdmin4 are you running?

2) What version of Postgres is it running against?

>
>
>
> why?
>
> Best wishes,
> Jacek
>
>

--
Adrian Klaver
adrian.klaver@aklaver.com

Re: What is wrong with my pgadmin?

От

Łukasz Jarych

Дата:

05 марта 2018 г., 22:07:25

Hi,

yes, using psql there is an error.

Jacek

2018-03-05 15:22 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:

On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
Hi Guys,

what is wrong with my pgAdmin?

I am creating wrong query:

select 1/0 but still this is executed!

Well it will be executed, but it should throw an error. Can you confirm that running select 1/0; in psql does indeed throw an error:

test=# select 1/0;
ERROR: division by zero

Also:

1) What version of pgAdmin4 are you running?

2) What version of Postgres is it running against?

why?

Best wishes,
Jacek

--
Adrian Klaver
adrian.klaver@aklaver.com

Re: What is wrong with my pgadmin?

От

Łukasz Jarych

Дата:

05 марта 2018 г., 22:08:01

Hi geoff,

i am expecting that there will be error thrown by pg_admin.

Jacek

2018-03-05 15:09 GMT+01:00 geoff hoffman <geoff@rxmg.com>:

What result were you expecting? A divide by zero error?

> On Mar 5, 2018, at 07:05, Łukasz Jarych <jaryszek@gmail.com> wrote:
>
> Hi Guys,
>
> what is wrong with my pgAdmin?
>
> I am creating wrong query:
>
> select 1/0 but still this is executed!
>
> <image.png>
>
> why?
>
> Best wishes,
> Jacek
>
>

Re: What is wrong with my pgadmin?

От

Łukasz Jarych

Дата:

05 марта 2018 г., 22:10:49

I am using:

I am using:

thank you for help,

Jacek

2018-03-05 15:22 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:

On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
Hi Guys,

what is wrong with my pgAdmin?

I am creating wrong query:

select 1/0 but still this is executed!

Well it will be executed, but it should throw an error. Can you confirm that running select 1/0; in psql does indeed throw an error:

test=# select 1/0;
ERROR: division by zero

Also:

1) What version of pgAdmin4 are you running?

2) What version of Postgres is it running against?

why?

Best wishes,
Jacek

--
Adrian Klaver
adrian.klaver@aklaver.com

Вложения

Re: What is wrong with my pgadmin?

От

Łukasz Jarych

Дата:

05 марта 2018 г., 22:12:07

Hi,

my history tab is:

2018-03-05 15:52 GMT+01:00 Grant Fisher <grant.fisher@gmail.com>:

On Mon, Mar 5, 2018 at 8:05 AM, Łukasz Jarych <jaryszek@gmail.com> wrote:
Hi Guys,

what is wrong with my pgAdmin?

I am creating wrong query:

select 1/0 but still this is executed!

why?

Best wishes,
Jacek

Jacek,

What does your query history tab show?

Thanks,
Grant

Вложения

Re: What is wrong with my pgadmin?

От

Łukasz Jarych

Дата:

06 марта 2018 г., 10:50:32

Anyone pleasE?

Jacek

2018-03-05 15:05 GMT+01:00 Łukasz Jarych <jaryszek@gmail.com>:

Hi Guys,

what is wrong with my pgAdmin?

I am creating wrong query:

select 1/0 but still this is executed!

why?

Best wishes,
Jacek

Вложения

image.png

Re: What is wrong with my pgadmin?

От

"David G. Johnston"

Дата:

06 марта 2018 г., 11:06:45

On Monday, March 5, 2018, Łukasz Jarych <jaryszek@gmail.com> wrote:

Anyone pleasE?

Don't know but you might get better results by emailing the support list for the pgAdmin application. This list is for general questions about the server.

David J.

Re: What is wrong with my pgadmin?

От

Adrian Klaver

Дата:

06 марта 2018 г., 11:06:55

On 03/05/2018 08:50 PM, Łukasz Jarych wrote:
> Anyone pleasE?

This has already been answered:

https://www.postgresql.org/message-id/CAKKotZQj_vupOYZKVXVfU_sjEADeJYMSftCNcV3dnY4eHqO64g%40mail.gmail.com

> 
> Jacek
> 
> 2018-03-05 15:05 GMT+01:00 Łukasz Jarych <jaryszek@gmail.com 
> <mailto:jaryszek@gmail.com>>:
> 
>     Hi Guys,
> 
>     what is wrong with my pgAdmin?
> 
>     I am creating wrong query:
> 
>     select 1/0 but still this is executed!
> 
> 
> 
>     why?
> 
>     Best wishes,
>     Jacek
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: What is wrong with my pgadmin?

От

Laurenz Albe

Дата:

06 марта 2018 г., 16:15:36

David G. Johnston wrote:
> On Monday, March 5, 2018, Łukasz Jarych <jaryszek@gmail.com> wrote:
> > Anyone pleasE?
> 
> Don't know but you might get better results by emailing the support list for the pgAdmin application.  This list is
forgeneral questions about the server.
 

I agree about asking the specialized list, but -general is certainly
not only for the server.

Yours,
Laurenz Albe

Re: What is wrong with my pgadmin?

От

"David G. Johnston"

Дата:

06 марта 2018 г., 20:40:19

On Tue, Mar 6, 2018 at 3:15 AM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:

David G. Johnston wrote:
> On Monday, March 5, 2018, Łukasz Jarych <jaryszek@gmail.com> wrote:
> > Anyone pleasE?
>
> Don't know but you might get better results by emailing the support list for the pgAdmin application. This list is for general questions about the server.

I agree about asking the specialized list, but -general is certainly
not only for the server.

Yes, I over-generalized, though not by much IMO. I was too tired to qualify what kind of client questions were on-topic since "psql" would still be imperfect.

David J.

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: What is wrong with my pgadmin?

Вложения

Вложения

Вложения

Вложения