Re: Saving DDL to a file ...

2019-10-17 Thread Aditya Toshniwal
Hi Arni, On Fri, Oct 18, 2019 at 12:21 PM Arni Kromić wrote: > On 18/10/2019 07.01, Avin Kavish wrote: > > Can't you copy and paste it? > > On Fri., 18 Oct. 2019, 9:27 am Khushboo Vashi, < > khushboo.va...@enterprisedb.com> wrote: > >> Hi Michael, >> >> On Thu, Oct 17, 2019 at 10:31 PM Michael S

Re: Saving DDL to a file ...

2019-10-17 Thread Arni Kromić
On 18/10/2019 07.01, Avin Kavish wrote: > Can't you copy and paste it? > > On Fri., 18 Oct. 2019, 9:27 am Khushboo Vashi, > > wrote: > > Hi Michael, > > On Thu, Oct 17, 2019 at 10:31 PM Michael Shapiro > mailto:mshapir...@gmail.com>> wrote: > >

Re: Saving DDL to a file ...

2019-10-17 Thread Avin Kavish
Can't you copy and paste it? On Fri., 18 Oct. 2019, 9:27 am Khushboo Vashi, < khushboo.va...@enterprisedb.com> wrote: > Hi Michael, > > On Thu, Oct 17, 2019 at 10:31 PM Michael Shapiro > wrote: > >> When I look at the DDL for an object (eg view or function) under the SQL >> tab in PgAdmin4, how

Re: pgAdmin 4.14 connection error

2019-10-17 Thread Khushboo Vashi
Hi, On Fri, Oct 18, 2019 at 7:59 AM Senderovich, Alexander < asenderov...@dot.nyc.gov> wrote: > I am receiving database connection error, every time I try to connect to > database: > > > > > > I did not save any passwords, I just upgraded existing pgAdmin 4 > installation. > > > > This error made

Re: Saving DDL to a file ...

2019-10-17 Thread Khushboo Vashi
Hi Michael, On Thu, Oct 17, 2019 at 10:31 PM Michael Shapiro wrote: > When I look at the DDL for an object (eg view or function) under the SQL > tab in PgAdmin4, how do I save it to a file? > Not supported right now but we do have a feature request for the same. Ref: https://redmine.postgresql.o

pgAdmin 4.14 connection error

2019-10-17 Thread Senderovich, Alexander
I am receiving database connection error, every time I try to connect to database: [cid:image002.png@01D584E9.F49883E0] I did not save any passwords, I just upgraded existing pgAdmin 4 installation. This error made pgAdmin unusable. Is there any way to disable this saving password feature? Th

Re: Is pgadmin4 being developed at Microsoft?

2019-10-17 Thread Alex Williams
Thanks, Searching around for about 2 hours, downgrading/upgrading etc the stackoverflow page resolved this issue this time (link below.) Will keep this version for the foreseeable future and will block any further updates, as it does what I need, querying and exporting. https://stackoverfl

SQL for views

2019-10-17 Thread Michael Shapiro
How does PgAdmin extract the sql for a view? If I run select definition from pg_catalog.pg_views where viewname = 'xxx' and schemaname='yyy' the tables in the FROM clauses may or may not be fully qualified, depending on the current search_path. If the search_path includes the schema for a tabl

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread Aditya Toshniwal
Hi George, You need to create one. It is not shipped by default. On Thu, Oct 17, 2019, 22:36 George Weaver wrote: > Aditya, > > How do I get a config_local.py: > > > > Thanks, > > George > On 17/10/2019 12:00 p.m., Aditya Toshniwal wrote: > > Hi Didier, > > Just beside the config.py file < INST

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread Aditya Toshniwal
Hi Richard, It is not mentioned anywhere. But, the docs clearly say config_distro is intended for packagers (might get replaced if things change) and config_local for the end users. So, you're supposed to create a config_local for your settings. On Thu, Oct 17, 2019, 22:33 richard coleman wrote

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread George Weaver
Aditya, How do I get a config_local.py: Thanks, George On 17/10/2019 12:00 p.m., Aditya Toshniwal wrote: Hi Didier, Just beside the config.py file < INSTALLDIR>/web On Thu, Oct 17, 2019, 22:27 Didier Gasser-Morlay > wrote: Sorry to hijack this thread but whe

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread richard coleman
Aditya, That's new. I have kept that setting in that file ever since the it was introduced. This is the *first* time it's been removed. Documentation of Master Password feature: https://www.pgadmin.org/docs/pgadmin4/development/master_password.html Link to Desktop deployment from that page: ht

Saving DDL to a file ...

2019-10-17 Thread Michael Shapiro
When I look at the DDL for an object (eg view or function) under the SQL tab in PgAdmin4, how do I save it to a file? Also, is there a way to run the DDL in a different database (so I can "copy" the object from one database to another)

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread Aditya Toshniwal
Hi Didier, Just beside the config.py file < INSTALLDIR>/web On Thu, Oct 17, 2019, 22:27 Didier Gasser-Morlay wrote: > Sorry to hijack this thread but where should config_local.py be ? > > Le jeu. 17 oct. 2019 à 18:50, Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> a écrit : > >> Hi Ri

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread Didier Gasser-Morlay
Sorry to hijack this thread but where should config_local.py be ? Le jeu. 17 oct. 2019 à 18:50, Aditya Toshniwal < aditya.toshni...@enterprisedb.com> a écrit : > Hi Richard, > > You need to add the setting in config_local.py. Other files will be > replaced except config_local.py. > > On Thu, Oct

Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread Aditya Toshniwal
Hi Richard, You need to add the setting in config_local.py. Other files will be replaced except config_local.py. On Thu, Oct 17, 2019, 22:15 richard coleman wrote: > Ugg, > > Just upgraded pgAdmin4 to the latest version 4.14. Even though I have had > the Master Password requirement disabled fo

Seriously? MASTER PASSWORD REQUIRED Again?!#$@!

2019-10-17 Thread richard coleman
Ugg, Just upgraded pgAdmin4 to the latest version 4.14. Even though I have had the Master Password requirement disabled for as long as it has been in existence, guess what I was greeted with upon starting pgAdmin4? If you guessed the prompt requiring me to create a Master Password, or be locked

pgAdmin 4 v4.14 released

2019-10-17 Thread Akshay Joshi
The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.14. This release of pgAdmin 4 includes over 21 bug fixes and new features. For more details please see the release notes at: https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_14.html. pgAdmin is the leading Open

Re: Session timeout

2019-10-17 Thread Arni Kromić
On 17/10/2019 11.05, Khushboo Vashi wrote: > Hi Arni, > > On Thu, Oct 17, 2019 at 1:41 PM Arni Kromić > wrote: > > A question asked on the list reminded me of something... I've always > wondered if it's possible to prolong or prevent pgAdmin4 session > t

Re: Session timeout

2019-10-17 Thread Khushboo Vashi
Hi Arni, On Thu, Oct 17, 2019 at 1:41 PM Arni Kromić wrote: > A question asked on the list reminded me of something... I've always > wondered if it's possible to prolong or prevent pgAdmin4 session > timeouts. This way if I leave the computer for a long time (especially > if it gets suspended),

Session timeout

2019-10-17 Thread Arni Kromić
A question asked on the list reminded me of something... I've always wondered if it's possible to prolong or prevent pgAdmin4 session timeouts. This way if I leave the computer for a long time (especially if it gets suspended), I have to refresh page, and login again. That also means that any query

Fwd: Save Session?

2019-10-17 Thread Arni Kromić
Now I noticed this was posted on a wrong list... I felt a forward was in order. Forwarded Message Subject:Re: Save Session? Date: Thu, 17 Oct 2019 09:31:08 +0200 From: Arni Kromić To: pgsql-...@lists.postgresql.org On 16/10/2019 13.30, Mike Martin wrote: > Is