Re: What is "Count Rows' supposed to do?

You didn't answer my question. Are you telling me that you have failed to realise this so far? Here's a feature request: https://redmine.postgresql.org/issues/4574 >

Re: What is "Count Rows' supposed to do?

Hi, On Wed, Aug 7, 2019 at 10:37 AM Avin Kavish wrote: > Considering that you have a popup saying Rows Counted, don't you think > it's also prudent to show the count on the popup itself as opposed to > requiring a user to select a different panel in order to see the count > operation that he jus

Re: What is "Count Rows' supposed to do?

Considering that you have a popup saying Rows Counted, don't you think it's also prudent to show the count on the popup itself as opposed to requiring a user to select a different panel in order to see the count operation that he just triggered with a different menu option? On Wed, Aug 7, 2019 at

Re: What is "Count Rows' supposed to do?

Hi, On Wed, Aug 7, 2019 at 6:04 AM Dave Caughey wrote: > In the navigator, drill down to your tables. Right-click on any table, > and select "Count Rows". > > A little pale-green popup appears in the lower right corner of pgAdmin > that says "Table Rows Counted". But that's all it says... I.e

Re: My user experience with pgAdmin 4.

tutiluren, I think you’re being a little thin-skinned here. I don’t think he was accusing you of misusing the browser, but I think you should admit that the root of most of the problems being described here is the necessity of clearing your browser history often, due to bad players who take adva

What is "Count Rows' supposed to do?

In the navigator, drill down to your tables. Right-click on any table, and select "Count Rows". A little pale-green popup appears in the lower right corner of pgAdmin that says "Table Rows Counted". But that's all it says... I.e., it doesn't actually report the number of rows in that table, as

Re: My user experience with pgAdmin 4.

"What could be done to improve your workflow?" This is the definition of arrogance... My "workflow" isn't what is abusing my browser. Don't even try to make this about me "doing something wrong".

Re: import upload file to pgadmin get CSRF error

I have tried remove and reinstall pgadmin4 but nothing changed. I have checked both /usr/lib/python2.7/site-packages/pgadmin4-web/ and /usr/pgadmin4/ were untouched by the re-installation and update. I have also tried rename these folders but no new folders were created after re-installation. For s

Re: import upload file to pgadmin get CSRF error

And I did restart httpd after running 'yum update pgadmin4' but it didn't work. On Wed, Aug 7, 2019 at 8:38 AM Wh isere wrote: > Thank you all! Sorry for the late reply due to timezone difference. Yes > the pgadmin4 is on web mode. I run '/usr/pgadmin4/bin/pgadmin4-web-setup.sh' > to set it up a

Re: import upload file to pgadmin get CSRF error

Thank you all! Sorry for the late reply due to timezone difference. Yes the pgadmin4 is on web mode. I run '/usr/pgadmin4/bin/pgadmin4-web-setup.sh' to set it up after installing with 'yum install pgadmin4' before. currently under /usr/pgadmin4/ there is only a bin folder with pgadmin4-web-setup.sh

Re: PGAdmin: type geography does not exist

On Tue, 6 Aug 2019 at 14:32, Ashesh Vashi wrote: > If you're running from the sql editor, then - you have either of the two > options: > Set search_path = 'teleon, public'; > CREATE TABLE... > > Or, > > Specify the schema in front of tge type. > > -- Thanks, Ashesh > > > Will have a go at it. Ho

Re: PGAdmin: type geography does not exist

I'm not sure if the schema the extension is installed in is causing the problem. I always install extensions in the pg_catalog schema. On Tue, Aug 6, 2019 at 7:32 AM Ashesh Vashi wrote: > If you're running from the sql editor, then - you have either of the two > options: > Set search_path = 'tel

Re: PGAdmin: type geography does not exist

To add more info to this, types in postgres are schema bound. There is no knowing where the geography type is in your database. You might want to check all the schema to find where the type is, its in public by default unless you renamed public, and add it to the search path. Also, If you have som

Re: PGAdmin: type geography does not exist

If you're running from the sql editor, then - you have either of the two options: Set search_path = 'teleon, public'; CREATE TABLE... Or, Specify the schema in front of tge type. -- Thanks, Ashesh On Tue, 6 Aug 2019, 17:14 Tony Shelver, wrote: > Schema | Name| Descripti

Re: PGAdmin: type geography does not exist

Schema | Name| Description +---+-- teleon | geography | postgis type: Ellipsoidal spatial data type. (1 row) On Tue, 6 Aug 2019 at 12:36, Ashesh Vashi wrote: > And - the following command for psql? > \dT geograph

Re: PGAdmin: type geography does not exist

And - the following command for psql? \dT geography -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* On Tue, Aug 6, 2019 at 4:02 PM Tony Shelver

Re: PGAdmin: type geography does not exist

On Tue, 6 Aug 2019 at 12:18, Ashesh Vashi wrote: > Can you please let me know the output of 'SHOW search_path' from the psql? > Ashesh, if I run SHOW search_path in psql, there is no output. Just returns with the prompt.

Re: PGAdmin: type geography does not exist

Can you please let me know the output of 'SHOW search_path' from the psql? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* On Tue, Aug 6, 2019 a

PGAdmin: type geography does not exist

PGadmin4.11 Ubuntu 18.04 Postgresql 11.4 I just tried to create the table below: CREATE TABLE teleon.to_location ( locn_id serial NOT NULL, geo_position geography(POINT, 4326) NOT NULL, upd_time timestamp NOT NULL, app_src_key char NOT NULL, CONSTRAINT to_location_pk PRIMARY KEY (locn_id) I got :

Re: import upload file to pgadmin get CSRF error

Hi On Tue, Aug 6, 2019 at 8:43 AM Fahar Abbas wrote: > Hi Avin, > > Please replay on Ashesh question: Is it running in 'web' or 'desktop' > mode? > Ashesh asked Wh isere that question, not Avin. > > Also adding Dave Page for his further inputs about shutdown pgadmin4 > server process. > If

Re: import upload file to pgadmin get CSRF error

Hi Avin, Please replay on Ashesh question: Is it running in 'web' or 'desktop' mode? Also adding Dave Page for his further inputs about shutdown pgadmin4 server process. Kind Regards, On Tue, Aug 6, 2019 at 12:06 PM Avin Kavish wrote: > You can use any one of ps, top, htop, or systemctl to

Re: import upload file to pgadmin get CSRF error

You can't just randomly install GUIs every time a process needs to be terminated. On Tue, Aug 6, 2019 at 12:19 PM Fahar Abbas wrote: > Hi, > > On Tue, Aug 6, 2019 at 11:36 AM Wh isere wrote: > >> Thank you! I am running pgadmin on a remote server, so there is not Gui >> interface, is there comm

Re: import upload file to pgadmin get CSRF error

You can use any one of ps, top, htop, or systemctl to view running services/processes and kill them On Tue, Aug 6, 2019 at 12:21 PM Ashesh Vashi wrote: > On Tue, Aug 6, 2019 at 12:18 PM Fahar Abbas > wrote: > >> Hi, >> >> On Tue, Aug 6, 2019 at 11:36 AM Wh isere wrote: >> >>> Thank you! I am r