Thread: What is wrong with my pgadmin?

What is wrong with my pgadmin?

From
Łukasz Jarych
Date:
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 


Attachment

Re: What is wrong with my pgadmin?

From
Adrian Klaver
Date:
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?

From
Martin Moore
Date:
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?

From
Murtuza Zabuawala
Date:
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?

From
Łukasz Jarych
Date:
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?

From
Łukasz Jarych
Date:
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?

From
Łukasz Jarych
Date:
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

Attachment

Re: What is wrong with my pgadmin?

From
Łukasz Jarych
Date:
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
 


Attachment

Re: What is wrong with my pgadmin?

From
Łukasz Jarych
Date:
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 



Attachment

Re: What is wrong with my pgadmin?

From
"David G. Johnston"
Date:
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?

From
Adrian Klaver
Date:
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?

From
Laurenz Albe
Date:
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?

From
"David G. Johnston"
Date:
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.