Home > mailing lists

Thread: What is wrong with my pgadmin?

What is wrong with my pgadmin?

From

Łukasz Jarych

Date:

05 March 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

Attachment

image.png

Re: What is wrong with my pgadmin?

From

Adrian Klaver

Date:

05 March 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?

From

Martin Moore

Date:

05 March 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?

From

Murtuza Zabuawala

Date:

05 March 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?

From

Łukasz Jarych

Date:

05 March 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?

From

Łukasz Jarych

Date:

05 March 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?

From

Łukasz Jarych

Date:

05 March 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

Attachment

Re: What is wrong with my pgadmin?

From

Łukasz Jarych

Date:

05 March 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

Attachment

Re: What is wrong with my pgadmin?

From

Łukasz Jarych

Date:

06 March 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

Attachment

image.png

Re: What is wrong with my pgadmin?

From

"David G. Johnston"

Date:

06 March 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?

From

Adrian Klaver

Date:

06 March 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?

From

Laurenz Albe

Date:

06 March 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?

From

"David G. Johnston"

Date:

06 March 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.