Re: [pgadmin-support] Migrating this list to PGLister on Friday, June 16th, 1300 UTC

2017-06-16 Thread Stephen Frost
Greetings, again! As an FYI, I am beginning the migration of this list now. You may see emails to this list be paused for a period of time, but none is expected to be lost. Thanks! Stephen * Stephen Frost (sfr...@snowman.net) wrote: > Greetings! > > The PostgreSQL Infrastructure team will be

[pgadmin-support] REVOKE PRIVILEGES in SQL tab of selected function

2017-06-16 Thread mammoth.power
Let's say we have this function: CREATE OR REPLACE FUNCTION public.test(in_value character varying) RETURNS character varying LANGUAGE 'plpgsql' COST 100.0 VOLATILE LEAKPROOF SECURITY DEFINER AS $$ BEGIN RETURN in_value; END; $$; ALTER FUNCTION public.test(character varying) OWNER

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread Richard Greenwood
Have you tried running in server mode on Windows? You launch a lightweight process on your windows computer, open a browser and from there can connect to local and remote psotgres instances on any platform. I think a lot of people are confused by the "server" mode an assume that you have to run the

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread Adam Brusselback
> Like is this a charade? Am I hallucinating? Are computer professionals still using MS Windows? Yes, a good number of people still use Windows, even in the Postgres world. It's not as uncommon as you seem to believe. I'd say among non-hackers, it's probably by far the majority.

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread Melvin Davidson
>Are computer professionals still using MS Windows? Yes, we use MS Windows with PgAdmin to connect to PostgreSQL on LINUX systems. Melvin Davidson 🎸     Cell 720-320-0155 I reserve the right to fantasize.  Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unus

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread Richard Greenwood
Like is this a charade? Am I hallucinating? Are computer professionals still using MS Windows? On Thu, Jun 15, 2017 at 12:07 PM, Patrick Headley wrote: > It doesn't sound like anyone is ignoring the problem but some issues are > harder to fix than others. If pgAdmin4 isn't working for you, use s

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread Patrick Headley
It doesn't sound like anyone is ignoring the problem but some issues are harder to fix than others. If pgAdmin4 isn't working for you, use something else. No one is saying you have to use pgAdmin4. While you are accusing many people of having something wrong in their heads I have observed that

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread Melvin Davidson
As others have pointed out, there are other graphical administration tools for PostgreSQL. If you really cannot wait for PgAdmin 4 to be "fixed" to your satisfaction, just look here: wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools I too am also disappointed in the current versio

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread Thomas Beinicke
lse just because the admin tool > is broken beyond the point of being usable to anyone? This is insanity. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread David G. Johnston
On Thu, Jun 15, 2017 at 10:05 AM, wrote: > It doesn't seem possible to get through to you. Whatever you spent those > one million dollars on, it sure as hell wasn't related to pgAdmin in any > way. More like very heavy drugs, if you think this is even acceptable for > pre-pre-pre-alpha software.

[pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

2017-06-15 Thread grekloedlc
It doesn't seem possible to get through to you. Whatever you spent those one million dollars on, it sure as hell wasn't related to pgAdmin in any way. More like very heavy drugs, if you think this is even acceptable for pre-pre-pre-alpha software. It's literally *unusable*. You get it? UNUSABLE.

Re: [pgadmin-support] a bug report: pgAdmin4 only shows splashscreen, no UI, no error

2017-06-15 Thread Dave Page
dmin.org. You could disable that by creating a file called config_local.py alongside config.py in the web/ directory of the installation, containing: UPGRADE_CHECK_ENABLED = False I'll create a ticket to have proxy authentication support added. -- Dave Page Blog: http://pgsnake.blogspot.

Re: [pgadmin-support] a bug report: pgAdmin4 only shows splashscreen, no UI, no error

2017-06-15 Thread McDonaldR
ving the new look pgAdmin4 a good going over. Ross -Original Message- From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Dave Page Sent: 15 June 2017 08:50 To: Jaroslav Záruba Cc: pgAdmin Support Subject: Re: [pgadmin-support] a bug

Re: [pgadmin-support] a bug report: pgAdmin4 only shows splashscreen, no UI, no error

2017-06-15 Thread Mike Surcouf
Do you have a proxy If so it’s a known issue. From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Jaroslav Záruba Sent: 15 June 2017 08:31 To: pgadmin-support@postgresql.org Subject: [pgadmin-support] a bug report: pgAdmin4 only shows

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-15 Thread Mike Surcouf
e big improvements. From: Patrick Headley [mailto:phead...@linxco-inc.com] Sent: 14 June 2017 16:57 To: Mike Surcouf; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] "pgadmin4" - slow? It used to take longer. Now, after starting up the times are comparable to pgAdmin3. Patri

Re: [pgadmin-support] a bug report: pgAdmin4 only shows splashscreen, no UI, no error

2017-06-15 Thread Dave Page
ations of Windows + proxy server. Please try the build at https://developer.pgadmin.org/~dpage/pgadmin4-1.5-x86.exe. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support maili

[pgadmin-support] a bug report: pgAdmin4 only shows splashscreen, no UI, no error

2017-06-15 Thread Jaroslav Záruba
s WLS_USER=weblogic WORKSPACE=D:\workspace -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Patrick Headley
is encouraging? *From:*pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] *On Behalf Of *Patrick Headley *Sent:* 14 June 2017 01:23 *To:* pgadmin-support@postgresql.org *Subject:* Re: [pgadmin-support] "pgadmin4" - slow? While I still wish pgAdmin4

[pgadmin-support] Migrating this list to PGLister on Friday, June 16th, 1300 UTC

2017-06-14 Thread Stephen Frost
Greetings! The PostgreSQL Infrastructure team will be migrating the project's mailing lists from the existing system (an ancient and unmaintained piece of software called "majordomo2") to a newly developed mailing list system (known as "PGLister"), which better addresses the needs of the PostgreSQ

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
whatwg.org/. look like your loading something via ajax with async:false -Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: 14 June 2017 14:44 To: Mike Surcouf Cc: Bruno Friedmann; pgAdmin Support Subject: Re: [pgadmin-support] "pgadmin4" - slow? On Wed, Jun 14, 2

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
> https://xhr.spec.whatwg.org/. > > look like your loading something via ajax with async:false Yeah, that one is on my TODO to fix. > > > -Original Message- > From: Dave Page [mailto:dp...@pgadmin.org] > Sent: 14 June 2017 14:44 > To: Mike Surcouf > Cc: Bruno Friedm

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
Are you listening on ipv6? Because as mentioned that will create problems as the dns resolver always returns ::1 on windows Would it not be better to listen on both version of ip -Original Message- From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org

Re: [pgadmin-support] Am I hallucinating, or are the pgAdmin developers insane? Or am I?

2017-06-14 Thread Raymond O'Donnell
read; it may give yuo some comfort. Ray. You make me crazy with this behaviour. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Am I hallucinating, or are the pgAdmin developers insane? Or am I?

2017-06-14 Thread grekloedlc
I asked, very politely, about the whole situation. I didn't get any sensible replies at all -- only a bunch of irrelevant, weird nonsense from people who clearly didn't even read what I had written. Then somebody else asks a similar question and gets tons of replies, but again, everyone just ig

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
-slow-remote-page-load-performance-in-qtwebkit-windows > > -Original Message- > From: pgadmin-support-ow...@postgresql.org > [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Dave Page > Sent: 14 June 2017 14:17 > To: Bruno Friedmann > Cc: pgAdmin Support > Su

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
On Wed, Jun 14, 2017 at 2:28 PM, Melvin Davidson wrote: > *Regardless of the upcoming problem resolution regarding slow start times, > or any of the multitude of Reddit reports, I think PgAdmin developers > should consider this a lesson learned and test on ALL platforms (IE:Mac, > Windows, Linux)

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Melvin Davidson
.0.0.1', which is what gained the 10 seconds I mentioned above. Of course, the downside of this is that it requires IPv4 on the users machine, but practically speaking I don't think that's likely to be an issue - is anyone really running IPv6 only? -- Dave Page Blog: http://pgsnake.blo

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
ing '127.0.0.1', which is what gained the 10 seconds I mentioned above. Of course, the downside of this is that it requires IPv4 on the users machine, but practically speaking I don't think that's likely to be an issue - is anyone really running IPv6 only? -- Dave Page Blog: ht

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Bruno Friedmann
ne in that case) -- Bruno Friedmann Ioda-Net SĂ rl www.ioda-net.ch Bareos Partner, openSUSE Member, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread David Lloyd
this the case, one could explore another avenue by pointing some other browser with/without caching on to see if the GUI itself is the pain point? DSL From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Patrick Headley Sent: Tuesday,

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
which case I hope it helps. -Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: 14 June 2017 08:56 To: Mike Surcouf Cc: Patrick Headley; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] "pgadmin4" - slow? On Wed, Jun 14, 2017 at 8:29 AM, Mike Surcouf

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-14 Thread Dave Page
seconds. Re-enabled AV and it took the same amount of time to > open. > > Systems specs: > > Windows Version 10.0.14393 Build 14393 > 16.0 GB RAM with about 11 GB free at the time of launching pgAdmin 4 > Processor Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz, 3601 Mhz, 4 C

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
me that the network side is what is less performant - obviously the resolver, but I suspect also connection setup which is why I have high hopes for web packing. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQ

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
s will significantly reduce the number of round-trips between the browser and client, as well as the bandwidth required. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mai

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
A 32 second startup time and a 2-6 seconds to expand each node is encouraging? From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Patrick Headley Sent: 14 June 2017 01:23 To: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-13 Thread Patrick Headley
While I still wish pgAdmin4 was faster to start up I installed pgAdmin4 v1.5 today and performed some tests. Here's what I found. The test machine is a Windows 7 VirtualBox VM. The host has a 4GHz processor and an SSD. The host network connection uses an AC 1200 WiFi card. I believe I'm testin

[pgadmin-support] "pgadmin4" - slow?

2017-06-13 Thread David Lloyd
Is it just me or is "pgadmin4" just terribly slow? I'm running it on a capable HP Laptop (it runs Postgres itself very well) but "pgadmin4" seems impossibly slow. Connecting to my Postgres from the local machine doesn't seem to be the bottleneck (I have a Laravel application that runs ju

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-13 Thread Shira Bezalel
happen again and again. It even happened to me! I was super > proud > > of a product that was, to me, "vastly superior" to the old one, but the > > users absolutely hated it, and eventually, I had to realize that while > > technically better in some aspects, I had jus

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-12 Thread Mike Surcouf
,. IMHO the windows self-contained install is way too slow to be useable. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Broken Context Menu on MacOS Sierra

2017-06-12 Thread Anthony DeBarros
the > context menu is (and stays) unusable until I restart the application. > > Is this a known problem? > > Bernhard > > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support >

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-12 Thread marcelo
Astonishing... On 12/06/17 07:31, Dave Page wrote: To which the answer is that having invested $1M+ in pgAdmin 4, -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-12 Thread Mike Surcouf
>I do not. pgAdmin 3 and 4 both remember my passwords just fine. For me pgamdin doesn’t remember empty password (I am using gssapi)). -Original Message- From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Dave Page Sent: 12 June 2017

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-12 Thread Dave Page
dmin V", taking everything you've learned but improving on it heavily?" To which the answer is that having invested $1M+ in pgAdmin 4, no, we're not going to just ditch it. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterpri

[pgadmin-support] Broken Context Menu on MacOS Sierra

2017-06-12 Thread Bernhard Streit
a known problem? Bernhard -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-12 Thread Dave Page
t; If you have anything promising to tell me in regards to any of this, I'd > like to hear it. In the past, I've looked through the miserable > "alternatives", so it's probably pointless to tell me about any of those, > but if there is some sort of alternative th

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-11 Thread Melvin Davidson
Pawel, I am NOT Pgadmin support, but I tried your query in PgAdmin 4 v1.5 andI saw the following error returned. ERROR: relation "non_existing_table" does not existLINE 1: select * from non_existing_table; ^** Error **ERROR: relation "non_existing_table" doe

Re: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-11 Thread Pawel Hadam
; > If you have anything promising to tell me in regards to any of this, I'd > like to hear it. In the past, I've looked through the miserable > "alternatives", so it's probably pointless to tell me about any of those, > but if there is some sort of alternative that

Fwd: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-11 Thread Jack Royal-Gordon
Hi, First, I appreciate your tone of constructive criticism — there has been way too much negative criticism on this topic. However, as another user who has his own experiences with pgAdmin4, I feel compelled to reply regarding some of your complaints — please see my comments below. I don’t

[pgadmin-support] Serious feedback and questions about the future of pgAdmin.

2017-06-11 Thread grekloedlc
Dear pgAdmin developers, When I first heard that you were doing a total rewrite of pgAdmin III, I was extremely excited, because I had long been frustrated with the various annoyances and bugs in that program, which I was (and am still, actually) using daily, primarily how it always felt like a

Re: [pgadmin-support] No SQL errors visible in pgAdmin 4 1.5

2017-06-09 Thread Murtuza Zabuawala
That is strange. I do not see any error in log file :( -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Fri, Jun 9, 2017 at 2:31 AM, Pawel Hadam wrote: > Hi Murtuza, > > Thank you - I have followed those steps and please find attached

Re: [pgadmin-support] Connecting to a different database while in Query Tool tab

2017-06-08 Thread Michael Shapiro
i use this feature a lot in PgAdmin 3 -- when I need to copy a view or function from one database to another. On Thu, Jun 8, 2017 at 11:19 AM, Anthony DeBarros wrote: > OK, thanks. Might be a feature to consider ... > > On Thu, Jun 8, 2017 at 12:11 PM, Murtuza Zabuawala enterprisedb.com> wrote:

Re: [pgadmin-support] Connecting to a different database while in Query Tool tab

2017-06-08 Thread Anthony DeBarros
OK, thanks. Might be a feature to consider ... On Thu, Jun 8, 2017 at 12:11 PM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > Hello, > > No, you cannot connect to different database from an existing open query > tool window, you have to open new tab for different database. > >

Re: [pgadmin-support] Connecting to a different database while in Query Tool tab

2017-06-08 Thread Murtuza Zabuawala
Hello, No, you cannot connect to different database from an existing open query tool window, you have to open new tab for different database. -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Thu, Jun 8, 2017 at 9:23 PM, Anthony DeBarros

[pgadmin-support] Connecting to a different database while in Query Tool tab

2017-06-08 Thread Anthony DeBarros
Question: In pgAdmin 4, if I have a query tool tab open and then want to connect to a different database on my server, can I do that while working in the current tab? Right now, it seems like I need to click on the other database in the object browser and open a new tab to work on a different data

Re: [pgadmin-support] No SQL errors visible in pgAdmin 4 1.5

2017-06-08 Thread Murtuza Zabuawala
Hi Pawel, I am not able not find any entry for your queries in log file, Can you turn of the dashboard graphs for a while and then try to re-produce the issue. Steps to turn of the graphs, 1) Goto File menu --> Preferences --> Dashboards --> Graphs 2) Provide a rate value as 123456789 in all 5 in

Re: [pgadmin-support] yum update fails due to unsigned pgadmin package

2017-06-08 Thread Mike Surcouf
Thanks Devrim yum clean all fixed it. From: dev...@gunduz.org [mailto:dev...@gunduz.org] Sent: 07 June 2017 16:16 To: pgadmin-support@postgresql.org; Mike Surcouf; 'pgadmin-support@postgresql.org' Subject: Re: [pgadmin-support] yum update fails due to unsigned pgadmin package Hi

Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

2017-06-07 Thread bertrand
Hello, I had pretty much the same problem as Peter and this version solved it. Thanks. -- View this message in context: http://www.postgresql-archive.org/pgAdmin-4-v1-3-fails-to-load-tp5951102p5965367.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com

Re: [pgadmin-support] yum update fails due to unsigned pgadmin package

2017-06-07 Thread devrim
is a webserver and I like to keep up with security which invoices >yum update regularly > >Thanks > >Mike. > > > >-- >Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref

[pgadmin-support] yum update fails due to unsigned pgadmin package

2017-06-07 Thread Mike Surcouf
yum update stops and says... Package pgadmin4-v1-docs-1.5-3.rhel7.noarch.rpm is not signed Any idea how I can update? This is a webserver and I like to keep up with security which invoices yum update regularly Thanks Mike. -- Sent via pgadmin-support mailing list (pgadmin-support

Re: [pgadmin-support] No SQL errors visible in pgAdmin 4 1.5

2017-06-07 Thread Dave Page
/pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] No SQL errors visible in pgAdmin 4 1.5

2017-06-07 Thread Murtuza Zabuawala
Hello, Are you able to locate "config.py" in pgAdmin4 directory? If yes then create a new file named "config_local.py" along side "config.py" and add below config option in it, FILE_LOG_LEVEL = logging.DEBUG Restart pgAdmin4 and try to re-produce the issue again. -- Regards, Murtuza Zabuawala E

Re: [pgadmin-support] No SQL errors visible in pgAdmin 4 1.5

2017-06-07 Thread Pawel Hadam
>> pgAdmin III >> >> 1.22.2 I can see a full error message telling me what was wrong (please >> >> see >> >> the screenshots). It looks to me like the messages are turned off >> >> somewhere >> >> but I cannot see it in any preferences or options. I would appreciate >> >> any >> >> help or hints how to turn them on or where I can see them in pgAdmin 4 >> >> 1.5. >> >> >> >> I am using PostgreSQl 9.6 on Windows 10 Pro. >> >> >> >> Thank you and kind regards >> >> Pawel >> >> >> >> >> >> >> > > > -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] No SQL errors visible in pgAdmin 4 1.5

2017-06-06 Thread Murtuza Zabuawala
Hi, Without log file it very hard to trace the issue as this is not re-producible on our side. Are you sure that *pgadmin4.log* file is empty? Can you try again changing the logging configuration, add below config option in "config_local.py" (which is in pgAdmin4 installation directory), FILE_LO

Re: [pgadmin-support] Centos 7 missing pgadmin dependency

2017-06-05 Thread Juris Sleiners
Hi, Just wanted to report that versions 1.4 and 1.5 has non functioning Copy function of the queried data. Thanks. On Mon, Jun 5, 2017 at 4:28 PM Devrim GĂĽndĂĽz wrote: > > Hi, > > On Thu, 2017-05-25 at 09:45 +, Mike Surcouf wrote: > > Any news on pushing 1.5 to the repo > > Sorry for the l

Re: [pgadmin-support] Centos 7 missing pgadmin dependency

2017-06-05 Thread Devrim GĂĽndĂĽz
Hi, On Thu, 2017-05-25 at 09:45 +, Mike Surcouf wrote: > Any news on pushing  1.5 to the repo Sorry for the late response, I pushed the packages last week. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitte

[pgadmin-support] pgadmin4: "The application server could not be contacted."

2017-06-02 Thread petrov.bori...@mail.ru
g96 Linux 4.10.14-200.fc25.x86_64 Fedora release 25 (Twenty Five) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Logging all actions

2017-06-02 Thread Murtuza Zabuawala
In *pgadmin3*, 1) Goto, File -> Options 2) Select 'Logging' And select the option of your choice. (Debug option will log everything) Log location: ~/pgadmin.log In *pgAdmin4*, You need to change the logging configuration using "config_local.py" file, Add below config option in "config_local

[pgadmin-support] Logging all actions

2017-06-02 Thread Vivek Pandey
Hello there, We are using postgres 9.3 in some of our applications in production. Recently we were asked to implement a security measure where all actions by an user (but not the application) gets logged in a log file. To avoid any adverse impact on the database performance, we do not want to e

Re: [pgadmin-support] remove the older pgAdmin 1.4 that came with the PGSQL installation?

2017-06-01 Thread Dave Page
iseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] remove the older pgAdmin 1.4 that came with the PGSQL installation?

2017-06-01 Thread jmorgan3
Hello. I have upgraded by pgAdmin from 1.4 to 1.5 on my windows installation of PGSQL. Is there a way to now remove the older pgAdmin 1.4 that came with the PGSQL installation? If so, can you tell me how to do this. Thanks, Derek -- Sent via pgadmin-support mailing list (pgadmin-support

[pgadmin-support] GUI App: "The application server could not be contacted."

2017-05-31 Thread petrov.bori...@mail.ru
ux 4.10.14-200.fc25.x86_64 Fedora release 25 (Twenty Five) -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] pgAdmin4 and boolean columns

2017-05-30 Thread Surinder Kumar
Hi Nigel, ​Already a similar issue RM2218 logged which is resolved. Also, which version of pgAdmin4 you are using ? On Wed, May 31, 2017 at 3:00 AM, Nigel Tucker < ni...@specialisedstructures.co.nz> wrote: > Hi, > > > > pgAdmin4 has difficulty with s

Re: [pgadmin-support] postgis geometry type not displayed correctly

2017-05-30 Thread Khushboo Vashi
On Tue, May 30, 2017 at 8:51 PM, Dave Page wrote: > Khushboo, can you look into this please (and log and RM to go with it > if required)? > > Sure, I will work on this after finishing my current RM #2425 . > Thanks. > > On Tue, May 30, 2017 at 4:09 PM

Re: [pgadmin-support] pgAdmin4 and boolean columns

2017-05-30 Thread Surinder Kumar
Hi Nigel, Please log the issue here so that it can be tracked. https://redmine.postgresql.org/projects/pgadmin4 Thanks Surinder On Wed, May 31, 2017 at 3:00 AM, Nigel Tucker < ni...@specialisedstructures.co.nz> wrote: > Hi, > > > > pgAdmin4 has

[pgadmin-support] pgAdmin4 and boolean columns

2017-05-30 Thread Nigel Tucker
Hi, pgAdmin4 has difficulty with setting or changing Boolean check boxes in Windows 10. Double clicking on a Boolean cell initially null converts the display to an empty box, which on leaving that cell displays 'false'. If you return to the box and click once on it, it switches to a ticked

Re: [pgadmin-support] postgis geometry type not displayed correctly

2017-05-30 Thread Dave Page
or >> > should I be asking this on the postgis list? >> > >> > Thanks, >> > Rich >> > >> > -- >> > Richard W. Greenwood, PLS >> > www.greenwoodmap.com >> >> >> >> -- >> Dave Page >> Blog: http:

Re: [pgadmin-support] postgis geometry type not displayed correctly

2017-05-30 Thread Murtuza Zabuawala
ed to "MultiPolygon, 3739". Any ideas > or > > should I be asking this on the postgis list? > > > > Thanks, > > Rich > > > > -- > > Richard W. Greenwood, PLS > > www.greenwoodmap.com > > > > -- > Dave Page > Blog: http://pgsnake.blogspot.

Re: [pgadmin-support] postgis geometry type not displayed correctly

2017-05-30 Thread Dave Page
Polygon, 3739". Any ideas or > should I be asking this on the postgis list? > > Thanks, > Rich > > -- > Richard W. Greenwood, PLS > www.greenwoodmap.com -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The

[pgadmin-support] postgis geometry type not displayed correctly

2017-05-30 Thread Richard Greenwood
I don't know if this question belongs on this list or the postgis list. In psql and pgAdmin3 a postgis geometry column is show as e.g. Column |Type ---+- polygeom | geometry(MultiPolygon,3739) however in pgAdmin4 it's show as: polygeom g

[pgadmin-support] Error when editing data on a table

2017-05-26 Thread Daniel Grace
I am using pgAdmin 1.22.0. Often when editing data on a table via the "view the data in the selected object" icon, I get the error: ASSERT INFO: ../src/common/wincmn.cpp(478): assert "GetEventHandler() == this" failed in ~wxWindowBase(): any pushed event handlers must have been removed BACKTRACE

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Shira Bezalel
for everyone, but for me that > >> > configuration is easy to maintain and provides a faster, more stable > >> > pgAdmin4 than pgAdmin3. > >> > > >> > On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf > >> > wrote: > >> >> > >&

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Dave Page
> > On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf >> > wrote: >> >> >> >> I just changed from Windows desktop to SERVER_MODE with apache and it >> >> is >> >> completely different app. >> >> >> >> So much f

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Shira Bezalel
ouf > wrote: > >> > >> I just changed from Windows desktop to SERVER_MODE with apache and it > is > >> completely different app. > >> > >> So much faster. Looks like there is something seriously wrong with the > >> Qt implementation. >

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Dave Page
ent app. >> >> So much faster. Looks like there is something seriously wrong with the >> Qt implementation. >> >> Plus I only have to install it once. >> >> It’s a pain to setup in server mode though. >> >> >> >> From: pgadmin-support-ow...@p

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Richard Greenwood
letely different app. > > So much faster. Looks like there is something seriously wrong with the > Qt implementation. > > Plus I only have to install it once. > > It’s a pain to setup in server mode though. > > > > *From:* pgadmin-support-ow...@postgresql.org [mailto:

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Shira Bezalel
ve to install it once. > > It’s a pain to setup in server mode though. > > > > *From:* pgadmin-support-ow...@postgresql.org [mailto: > pgadmin-support-ow...@postgresql.org] *On Behalf Of *Richard Greenwood > *Sent:* 24 May 2017 14:15 > *To:* pgadmin-support@postgresql.o

Re: [pgadmin-support] Can I use the same sqlite database for update pgadmin4 version?

2017-05-25 Thread Dave Page
DB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Can I use the same sqlite database for update pgadmin4 version?

2017-05-25 Thread Lazaro Garcia
Hello, for migrating pgadmin4 1.4 to 1.5 can I use the same sqlite database used with 1.4? Regards.

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Mike Surcouf
I just changed from Windows desktop to SERVER_MODE with apache and it is completely different app. So much faster. Looks like there is something seriously wrong with the Qt implementation. Plus I only have to install it once. It’s a pain to setup in server mode though. From: pgadmin-support

Re: [pgadmin-support] Centos 7 missing pgadmin dependency

2017-05-25 Thread Mike Surcouf
Any news on pushing 1.5 to the repo Thanks Mike -Original Message- From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Devrim GĂĽndĂĽz Sent: 12 May 2017 09:37 To: Matt Heitker; pgadmin-support@postgresql.org Subject: Re: [pgadmin

[pgadmin-support] change Query-# by table name

2017-05-24 Thread Lazaro Garcia
Hello everyone, could be possible to change for future release the tab name Query-# with the table name when a table is queried? Regards.

Re: [pgadmin-support] pgAdmin4 speed

2017-05-24 Thread Melvin Davidson
kalley.com From: Richard Greenwood To: pgadmin-support@postgresql.org Sent: Wednesday, May 24, 2017 9:15 AM Subject: [pgadmin-support] pgAdmin4 speed There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdm

[pgadmin-support] pgAdmin4 speed

2017-05-24 Thread Richard Greenwood
There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about. I'm running the python server script and then us

[pgadmin-support] Counter of elements (X) inside subnodes under schema nodes

2017-05-23 Thread mammoth.power
OK, it is not really a bug. It's more a feature request. At the moment when I expand a schema in the browser, then I see nodes for collations, domains, tables, . It would be nice to see the counter of elements under this nodes. Functions (0), Tables (31), . Sometimes I need manually ex

[pgadmin-support] SQL Formatting: FOR EACH ROW in CREATE TRIGGER sql-statement is not in a new line

2017-05-23 Thread mammoth.power
It looks like it was prepared to be displayed as a new line, but the line break is missing. pgAdmin 4 CREATE CONSTRAINT TRIGGER aaa_aid_trigger AFTER INSERT OR DELETE ON bbb.aaa DEFERRABLE INITIALLY DEFERREDFOR EACH ROW WHEN (("ccc"() = 'ddd'::name)) EXECUTE

[pgadmin-support] SQL Font: Bold font and tab width don't match

2017-05-23 Thread mammoth.power
At the moment it looks for example like this: It would be nice to have an option to change the font for better output. Or another embedded font in pgAdmin 4 package. This is how I like it to be displayed (screenshot of notepad++): pgAdmin 4 v1.5 Desktop Runtime Windows 10 x6

Re: [pgadmin-support] making me love pgAdmin III

2017-05-23 Thread mammoth.power
: mammoth.po...@gmx.us Betreff: AW: [pgadmin-support] making me love pgAdmin III Hi, yeah, of course I can backup a single table and of course I can backup the whole database. But that is not what I wanted! Because if you have hundreds of tables I cannot backup only one by one. J Regards

Re: [pgadmin-support] making me love pgAdmin III

2017-05-23 Thread mammoth.power
looks like at the moment it is not possible to say “backup database” and select specific tables. But it works for the whole database or specific table. Von: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] Im Auftrag von Christoph Schreiber Gesendet: Dienst

Re: [pgadmin-support] making me love pgAdmin III

2017-05-23 Thread Christoph Schreiber
; PgAdmin Support Betreff: Re: [pgadmin-support] making me love pgAdmin III Christopher, I am not PgAdmin support, but in all fairness >You cannot make a pg_dump from a single column. You always have to dump the >whole table. this has never been the case. pg_dump has never had the opt

Re: [pgadmin-support] making me love pgAdmin III

2017-05-23 Thread Melvin Davidson
Christopher, I am not PgAdmin support, but in all fairness >You cannot make a pg_dump from a single column. You always have to dump the >whole table. this has never been the case. pg_dump has never had the option to >dump just a single column. https://www.postgresql.org/docs/9.6/s

  1   2   3   4   5   6   7   8   9   10   >