Thread: What is wrong with my pgadmin?
Hi Guys,
what is wrong with my pgAdmin?
I am creating wrong query:
select 1/0 but still this is executed!
![](/media/maillist_attaches/pgsql-general/2018/03/5/CAGv31od0mdhJXDT1pwPwmoUpjzKSvZkkZb_r8jZP2nFXVLeHTA@mail.gmail.com/image.png)
why?
Best wishes,
Jacek
Attachment
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).
Work around for this problem is to set
lc_messages = 'en_US.UTF-8'
in "postgresql.conf" file.
--![](https://drive.google.com/a/enterprisedb.com/uc?id=0B6jGeB3BfKRMV0t4MEp0YnZCTTA&export=download)
Regards,
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
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
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
>
>
I am using:
![](/media/maillist_attaches/pgsql-general/2018/03/5/CAGv31oeP8bBRvMLWLOz+qhqfvbhAgKcnROBJm=GKpgaBXLpGtA@mail.gmail.com/image.png)
![](/media/maillist_attaches/pgsql-general/2018/03/5/CAGv31oeP8bBRvMLWLOz+qhqfvbhAgKcnROBJm=GKpgaBXLpGtA@mail.gmail.com/image-1.png)
![](/media/maillist_attaches/pgsql-general/2018/03/5/CAGv31oeP8bBRvMLWLOz+qhqfvbhAgKcnROBJm=GKpgaBXLpGtA@mail.gmail.com/image.png)
I am using:
![](/media/maillist_attaches/pgsql-general/2018/03/5/CAGv31oeP8bBRvMLWLOz+qhqfvbhAgKcnROBJm=GKpgaBXLpGtA@mail.gmail.com/image-1.png)
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
Hi,
![](/media/maillist_attaches/pgsql-general/2018/03/5/CAGv31ofR9fVjVCScspK7acUBWSGW3JoxK3krMpudwMRAD5G4-Q@mail.gmail.com/image-1.png)
my history tab is:
![](/media/maillist_attaches/pgsql-general/2018/03/5/CAGv31ofR9fVjVCScspK7acUBWSGW3JoxK3krMpudwMRAD5G4-Q@mail.gmail.com/image-1.png)
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,JacekJacek,What does your query history tab show?Thanks,
Grant
Attachment
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
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: 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
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
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.