[pgadmin-support] PG 9.1 Windows 7 64-bit pgAdmin says all pgAgent jobs fail

2012-02-28 Thread Guy Rouillier
I started writing this after struggling and Googling for hours and not getting anywhere. I'm running EnterpriseDB 9.1.2.2 64-bit on Windows 7 64-bit. I installed pgAdmin separately, version 1.14.1. The database appears to be working fine. pgAgent was automatically installed and the service s

[pgadmin-support] Likely bug in executing pgScript on wrong database

2012-02-28 Thread Charles Gutjahr
I've found what appears to be a bug in the way pgAdmin III executes pgScript, which can cause it to run scripts on the wrong database. I couldn't find any records of the bug in your Trac site, so I'm reporting it here. Here's how to reproduce. In this example, assume I have two databases called

Re: [pgadmin-support] Possible defects with extensions in pgadmin3-1.14.2

2012-02-28 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 17:04 -0500, James B. Byrne wrote: > CentOS-6.2 > PostgreSQL-9.1.2 > PGAdmin3-1.14.2 > > All installed via yum from repo at postgresql.org. > > I previously sent this report to the pg users list: > > First: > When viewing the properties of the plpgsql extension the > sql pa

[pgadmin-support] Possible defects with extensions in pgadmin3-1.14.2

2012-02-28 Thread James B. Byrne
CentOS-6.2 PostgreSQL-9.1.2 PGAdmin3-1.14.2 All installed via yum from repo at postgresql.org. I previously sent this report to the pg users list: First: When viewing the properties of the plpgsql extension the sql pane of the properties window of PGAdmin incorrectly gives the command ALTER EXT

Re: [pgadmin-support] feature request - show role members

2012-02-28 Thread Bartosz Dmytrak
2012/2/28 Guillaume Lelarge > On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > > Hi, > > I would like to see who is member of selected role, somewhere in group > role > > form. Hope this will help to administrate multiuser environments. > > > > This feature is covered by query: > > SEL

Re: [pgadmin-support] Panel height redimensioning in Query builder

2012-02-28 Thread Colin Beckingham
On 02/28/2012 10:28 AM, Guillaume Lelarge wrote: On Thu, 2012-02-23 at 13:41 -0500, Colin Beckingham wrote: Using OpenSUSE 12.1, pgadmin3 1.15 Dev (updated today) In the query builder, open the SQL editor. 1 - attempt to adjust the height of the editor panel. Cursor changes shape, and drag an

Re: [pgadmin-support] Panel height redimensioning in Query builder

2012-02-28 Thread Guillaume Lelarge
On Thu, 2012-02-23 at 13:41 -0500, Colin Beckingham wrote: > Using OpenSUSE 12.1, pgadmin3 1.15 Dev (updated today) > > In the query builder, open the SQL editor. > 1 - attempt to adjust the height of the editor panel. Cursor changes > shape, and drag and drop allows the panel to resize, but does

Re: [pgadmin-support] feature request - show role members

2012-02-28 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > Hi, > I would like to see who is member of selected role, somewhere in group role > form. Hope this will help to administrate multiuser environments. > > This feature is covered by query: > SELECT p.rolname, m.rolname as member, g.rolname

Re: [pgadmin-support] pgAdmin hangs

2012-02-28 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 12:49 +0100, Bartosz Dmytrak wrote: > Hi, > works after renaming. File in different email. > Thank you. I've found your issue. We didn't deal well with empty strings in the queries history file. It's now fixed in git. Thanks again. -- Guillaume http://blog.guillaume.lela

Re: [pgadmin-support] pgAdmin hangs

2012-02-28 Thread Bartosz Dmytrak
Hi, works after renaming. File in different email. Regards, Bartek 2012/2/28 Guillaume Lelarge > On Tue, 2012-02-28 at 10:10 +0100, Bartosz Dmytrak wrote: > > hi, > > I've tried to open SQL query tool using SQL button to see table > definition > > (Copy SQL from main window to query tool = TRU

Re: [pgadmin-support] pgAdmin hangs

2012-02-28 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 10:10 +0100, Bartosz Dmytrak wrote: > hi, > I've tried to open SQL query tool using SQL button to see table definition > (Copy SQL from main window to query tool = TRUE) , but pgAdmin does not > reply. > Using other instance of pgAdmin on server side, I can see new process is

Re: [pgadmin-support] pg_dump.exe - quotation marks in schema names

2012-02-28 Thread sbremal
Work like a charm! Thanks. B. > Subject: Re: [pgadmin-support] pg_dump.exe - quotation marks in schema names > From: guilla...@lelarge.info > To: sbre...@hotmail.com > CC: pgadmin-support@postgresql.org > Date: Mon, 27 Feb 2012 22:23:03 +0100 > > On Mon, 2012-02-27 at 16:22 +, sbre...@hotm

[pgadmin-support] pgAdmin hangs

2012-02-28 Thread Bartosz Dmytrak
hi, I've tried to open SQL query tool using SQL button to see table definition (Copy SQL from main window to query tool = TRUE) , but pgAdmin does not reply. Using other instance of pgAdmin on server side, I can see new process is started for Query Tool (status ) in server status window. agAdmin l

[pgadmin-support] feature request - show role members

2012-02-28 Thread Bartosz Dmytrak
Hi, I would like to see who is member of selected role, somewhere in group role form. Hope this will help to administrate multiuser environments. This feature is covered by query: SELECT p.rolname, m.rolname as member, g.rolname as grantor FROM pg_authid p INNER JOIN pg_auth_members am ON (p.oid