Re: PGadmin 4.11 query tool message output

2019-08-01 Thread Aditya Toshniwal
Hi, This is issue is logged and fixed - https://redmine.postgresql.org/issues/4525. Will be available in next release. On Thu, Aug 1, 2019 at 6:34 PM Ailar Kiristaja wrote: > Hi, > > I did upgrade PGadmin from 4.9 to 4.11 and now affected rows information > is missing in query tool messages out

Re: How can I add a custom EPSG to the Map (Geometry) Viewer in PGAdmin4,

2019-08-01 Thread Calle Hedberg
Dave, EPSG is a structured data set of Coordinate Reference Systems and Coordinate Transformations - the data set was originally designed by the European Petroleum Survey Group (EPSG) but is from 2005 maintained by the International Oil and Gas Association Survey Committee. Each EPSG has a unique

Re: Search database objects

2019-08-01 Thread Milan Oparnica
Thanks Dave. I'm glad you're having it in mind. I see few duplicates on Redmine, so at least this time i feel I'm not the-only-one :) I'll check the 2172 issue from time to time. As in that Heineken commercial with Mars rover: "And now we wait !"  :) BR, Milan Oparnica On 1.8.19. 09:56,

Re: Managing 'Operators' in pgAdmin4

2019-08-01 Thread Milan Oparnica
Hi Dave, I know it's far from top priority feature, but I use it occasionally in pgAdmin3. It works, at least the part the admin tool is used for. As you noted, it's not the creation, but maintenance, or better said - quick check when cryptic errors complain about missing operator for type A

Re: no results in 4.11 Ubuntu

2019-08-01 Thread richard coleman
Richard, As far as I know, yea, though you can use your GMail or Outlook accounts as well, if you have one. rik. On Thu, Aug 1, 2019 at 9:31 AM Richard Greenwood < richard.greenw...@gmail.com> wrote: > Thanks for the info. Do I really have to create an account just to view > the issue? The link

Re: no results in 4.11 Ubuntu

2019-08-01 Thread Richard Greenwood
Thanks for the info. Do I really have to create an account just to view the issue? The link you sent just goes to a postgresql.org "sign in" page. On Thu, Aug 1, 2019 at 6:58 AM richard coleman wrote: > Richard, > > Congratulations, you too have been hit by the mis-packaged pgAdmin4.11 bug > rec

PGadmin 4.11 query tool message output

2019-08-01 Thread Ailar Kiristaja
Hi, I did upgrade PGadmin from 4.9 to 4.11 and now affected rows information is missing in query tool messages output tab after update or delete. Server version on ubuntu 16.04. Ailar Kiristaja

Re: no results in 4.11 Ubuntu

2019-08-01 Thread richard coleman
Richard, Congratulations, you too have been hit by the mis-packaged pgAdmin4.11 bug recorded as Issue # 4520 (among others) . *TLDR* version; pgAdmin 4.11 is dependent on a version of psycopg2 that isn't in the repository (any repository)

no results in 4.11 Ubuntu

2019-08-01 Thread Richard Greenwood
I'm not getting any results from any query in pgAdmin 4.11 on Ubuntu. I only get a message: 'table_oid' I've tried on two Ubuntu 18.04 based computers (XUbuntu and Mint) in Firefox and Chrome against 3 servers. Queries in pgAdminIII and psql are fine. My "about" info below: Version 4.11 Copyrig

Re: How can I add a custom EPSG to the Map (Geometry) Viewer in PGAdmin4,

2019-08-01 Thread Avin Kavish
Hey bobb, but we have a custom EPSG, where do I add this into PGAdmin4 > EPSGs are stored in a table called spatial_ref_sys. All you need to do is insert a record that contains the definition in well known text format and proj4 format (for transformation). I'd recommend checking the table first b

Re: How can I add a custom EPSG to the Map (Geometry) Viewer in PGAdmin4,

2019-08-01 Thread Dave Page
Hi On Wed, Jul 31, 2019 at 3:24 PM Basques, Bob (CI-StPaul) < bob.basq...@ci.stpaul.mn.us> wrote: > All, > > Following the appreciation thread and saw the reference to the geometry > viewer, I didn’t even know that was in there. Anyway, nice, but we have a > custom EPSG, where do I add this into

Re: Managing 'Operators' in pgAdmin4

2019-08-01 Thread Dave Page
Hi On Wed, Jul 31, 2019 at 4:02 PM Milan Oparnica wrote: > Hello, > > I like the fresh and modern approach that pgAdmin4 offers, updating > instantly when new versions pop-up praying to find few options I still miss > from pgAdmin3. > > Working with 'Operators' objects > > >

Re: Search database objects

2019-08-01 Thread Dave Page
On Wed, Jul 31, 2019 at 4:03 PM Milan Oparnica wrote: > Hello, > > I like the fresh and modern approach that pgAdmin4 offers, updating > instantly when new versions pop-up praying to find few options I still miss > from pgAdmin3. > > Search database objects > === > > I'm sure this too