What is wrong with my pgadmin?

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

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

Hello,

This is a bug with pgAdmin4 (Bug: RM#3090
<https://redmine.postgresql.org/issues/3090&gt;).

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:

Hi,

yes, using psql there is an error.

Jacek

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

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>:

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>:

Hi,

my history tab is:

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

Anyone pleasE?

Jacek

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

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.

On 03/05/2018 08:50 PM, Łukasz Jarych wrote:

Anyone pleasE?

This has already been answered:

/messages/by-id/CAKKotZQj_vupOYZKVXVfU_sjEADeJYMSftCNcV3dnY4eHqO64g@mail.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

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.

Yours,
Laurenz Albe

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.