Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread johannes graën
On Tue, Feb 16, 2016 at 1:04 PM, Dave Page wrote: > Are you in a position to be able to install the EDB PostgreSQL installer? > I'm curious to know if the build of pgAdmin that's included with that works > OK. It was built against a fairly old version of GTK for maximum > compatibility with differ

Re: [pgadmin-support] PgAdmin III 1.22 crashes, bug riport

2016-02-16 Thread Dave Page
Cool - thanks. I'll go commit that patch :-) On Tue, Feb 16, 2016 at 3:11 PM, Crain, Andrew wrote: > Dave, > Yes, I did get reconnects, several times (expected), and not one caused a > crash. Looks like you nailed it. > Thanks! > Andy > > From: Dave Page > Date: Tuesday, February 16, 2016 at 5:

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread Gabriel E . Sánchez Martínez
On 02/16/2016 07:23 AM, Gabriel Sánchez wrote: On Feb 16, 2016 7:04 AM, "Dave Page" > wrote: > > > > On Tue, Feb 16, 2016 at 11:06 AM, johannes graën mailto:johan...@selfnet.de>> wrote: >> >> On Tue, Feb 16, 2016 at 12:00 PM, Dave Page >

Re: [pgadmin-support] PgAdmin III 1.22 crashes, bug riport

2016-02-16 Thread Crain, Andrew
Dave, Yes, I did get reconnects, several times (expected), and not one caused a crash. Looks like you nailed it. Thanks! Andy From: Dave Page mailto:dp...@pgadmin.org>> Date: Tuesday, February 16, 2016 at 5:54 AM To: "Crain, Andrew" mailto:acr...@cincinna.gannett.com>> Cc: "Strauch, Sheldon" mai

Re: [pgadmin-support] DEFAULT PRIVILEGES incorrect

2016-02-16 Thread Sanket Mehta
Hi, I have evaluated the code and found another issue while trying to resolve this bug. Lets assume we have created 3 roles foo1, foo2 and bar1 and one schema "test". Now using foo1 role we have given SELECT privileges to bar1 as mentioned below: SELECT ROLE foo1; ALTER DEFAULT PRIVILEGES IN SCH

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread Gabriel Sánchez
On Feb 16, 2016 7:04 AM, "Dave Page" wrote: > > > > On Tue, Feb 16, 2016 at 11:06 AM, johannes graën wrote: >> >> On Tue, Feb 16, 2016 at 12:00 PM, Dave Page wrote: >> > Where did your build come from? What version of wxWidgets is it using? >> >> It's an official Arch package: >> https://www.arc

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread Dave Page
On Tue, Feb 16, 2016 at 11:06 AM, johannes graën wrote: > On Tue, Feb 16, 2016 at 12:00 PM, Dave Page wrote: > > Where did your build come from? What version of wxWidgets is it using? > > It's an official Arch package: > https://www.archlinux.org/packages/community/x86_64/pgadmin3/ Huh, they h

Re: [pgadmin-support] PgAdmin III 1.22 crashes, bug riport

2016-02-16 Thread Dave Page
Hi On Tue, Feb 16, 2016 at 3:36 AM, Strauch, Sheldon wrote: > Hi Dave, > > PFA another dump attached. > > This happened again while resizing an SQL window with a moderate-sized > query and a data grid with one column that is extremely large text. > I've just spent 20 minutes or so playing with

Re: [pgadmin-support] DEFAULT PRIVILEGES incorrect

2016-02-16 Thread Erwin Brandstetter
Hi Sanket! The point is that "FOR ROLE foo" can only be omitted in the DDL command if the *current *role is identical to the role for which it applies. I would strongly advise not to try and build in this syntax shortcut at all. It should be much simpler and less error prone to always add the app

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread johannes graën
On Tue, Feb 16, 2016 at 12:00 PM, Dave Page wrote: > Where did your build come from? What version of wxWidgets is it using? It's an official Arch package: https://www.archlinux.org/packages/community/x86_64/pgadmin3/ The wxWidgets version is 2.8.12.1: https://www.archlinux.org/packages/extra/x86

Re: [pgadmin-support] DEFAULT PRIVILEGES incorrect

2016-02-16 Thread Dave Page
On Tue, Feb 16, 2016 at 11:06 AM, Sanket Mehta < sanket.me...@enterprisedb.com> wrote: > > On Tue, Feb 16, 2016 at 4:34 PM, Dave Page wrote: > >> >> >> On Tue, Feb 16, 2016 at 10:53 AM, Sanket Mehta < >> sanket.me...@enterprisedb.com> wrote: >> >>> Hi Dave, >>> >>> Below is my understanding of th

Re: [pgadmin-support] DEFAULT PRIVILEGES incorrect

2016-02-16 Thread Sanket Mehta
On Tue, Feb 16, 2016 at 4:34 PM, Dave Page wrote: > > > On Tue, Feb 16, 2016 at 10:53 AM, Sanket Mehta < > sanket.me...@enterprisedb.com> wrote: > >> Hi Dave, >> >> Below is my understanding of this issue: >> >> In ALTER DEFAULT PRIVLEGES statement, "FOR ROLE "part is >> missing. >> > > That's w

Re: [pgadmin-support] DEFAULT PRIVILEGES incorrect

2016-02-16 Thread Dave Page
On Tue, Feb 16, 2016 at 10:53 AM, Sanket Mehta < sanket.me...@enterprisedb.com> wrote: > Hi Dave, > > Below is my understanding of this issue: > > In ALTER DEFAULT PRIVLEGES statement, "FOR ROLE "part is > missing. > That's what Erwin has reported, yes. > > as per postgresql documentation targ

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread Dave Page
On Tue, Feb 16, 2016 at 10:57 AM, johannes graën wrote: > On Tue, Feb 16, 2016 at 11:52 AM, Dave Page wrote: > > My best guess is that when you use Ctrl+V, some other control on the > window > > actually has focus and is "swallowing" the keypress before our code sees > it. > > Can you confirm th

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread johannes graën
On Tue, Feb 16, 2016 at 11:52 AM, Dave Page wrote: > My best guess is that when you use Ctrl+V, some other control on the window > actually has focus and is "swallowing" the keypress before our code sees it. > Can you confirm that the SQL textbox is definitely the focussed control when > you hit C

Re: [pgadmin-support] PgAdmin III 1.22 crashes, bug riport

2016-02-16 Thread Dave Page
On Mon, Feb 15, 2016 at 9:53 PM, Crain, Andrew wrote: > Dave, > I’ve been using the test build for several hours, longer than the typical > interval between crashes, and have had no problems, including upon > returning to the UI after a connection has become stale, which is when the > problem typ

Re: [pgadmin-support] DEFAULT PRIVILEGES incorrect

2016-02-16 Thread Sanket Mehta
Hi Dave, Below is my understanding of this issue: In ALTER DEFAULT PRIVLEGES statement, "FOR ROLE "part is missing. as per postgresql documentation target_name should follow below rule: target_name: The name of an existing role of which the current role is a member. If FOR ROLE is omitted, the

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread Dave Page
On Tue, Feb 16, 2016 at 8:13 AM, johannes graën wrote: > On Tue, Feb 9, 2016 at 2:55 PM, Gabriel Sánchez > wrote: > > The same happens to me. Although copying and waiting usually works for > me. > > I've got a new clue. Although cut + paste inserts the wrong text, the > cutted text is available

Re: [pgadmin-support] Debugger freeze

2016-02-16 Thread Dave Page
On Mon, Feb 15, 2016 at 9:30 PM, Korry Douglas < korry.doug...@enterprisedb.com> wrote: > > Like Dave, I am not able to replicate the problem. However, I tested with > a Linux version of the database server and a Linux version of pgAdmin. > > Dave, did you test on Windows or Linux? > I tested on

Re: [pgadmin-support] Copy & paste key commands not working correctly

2016-02-16 Thread johannes graën
On Tue, Feb 9, 2016 at 2:55 PM, Gabriel Sánchez wrote: > The same happens to me. Although copying and waiting usually works for me. I've got a new clue. Although cut + paste inserts the wrong text, the cutted text is available to other programs afterwards. So my guess would be that pgadmin just u

Re: [pgadmin-support] Debugger freeze

2016-02-16 Thread Stefan Stefanov
Korry, I used EDB graphic installer. Sincerely, Stefan > Оригинално писмо >От: Korry Douglas korry.doug...@enterprisedb.com >Относно: Re: [pgadmin-support] Debugger freeze >До: Stefan Stefanov >Изпратено на: 15.02.2016 23:30 Like Dave, I am n

Re: [pgadmin-support] Debugger freeze

2016-02-16 Thread Korry Douglas
Like Dave, I am not able to replicate the problem. However, I tested with a Linux version of the database server and a Linux version of pgAdmin. Dave, did you test on Windows or Linux? Stefan - did you compile these packages (the database server and pgAdmin) yourself? Or did you download a

Re: [pgadmin-support] Debugger freeze

2016-02-16 Thread Stefan Stefanov
Hi, dbg_test() debugs happily on the same Pgadmin iii connected to Postgresql 9.2.8 compiled by VC++ build 1600 32-bit running on windows-7 32-bit. Sincerely, Stefan > Оригинално писмо >От: Korry Douglas korry.doug...@enterprisedb.com >Относно: Re: [pgadmin-support]

Re: [pgadmin-support] Debugger freeze

2016-02-16 Thread Stefan Stefanov
Hi, This function and any other function work as usual outside of the debugger. Actually I found the problem when debugging a 'real' function. This one is just for the sake of a clean test. It seems that the delay causes the failure. I did this: start a debug session and loop q