Re: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh

2013-01-06 Thread Robert Klaus
Thank you!I think this is exactly what we need. Just get a list of all namespaces in the server except for the one that we don't want to appear and put them in a string of schemanames . . . 'public','evdo','lte','voice', ... etc -Original Message- From: pgadmin-support-ow...@postg

Re: [pgadmin-support] See full query text in Server Status window

2013-01-06 Thread Guillaume Lelarge
On Fri, 2013-01-04 at 12:17 +0100, Guillaume Lelarge wrote: > On Fri, 2013-01-04 at 11:57 +0100, Guillaume Lelarge wrote: > > On Fri, 2012-12-28 at 23:52 +1100, Evan Martin wrote: > > > I think Ctrl-R is good for refresh (like Firefox and other browsers) and > > > Ctrl-Shift-C sounds fine, too. >

Re: [pgadmin-support] pgadmin3 - Crash on renaming

2013-01-06 Thread Guillaume Lelarge
On Mon, 2012-12-24 at 09:59 +0100, Guillaume Lelarge wrote: > On Sun, 2012-12-23 at 16:13 -0800, Thangalin wrote: > > Hi, > > > > Note that pgadmin3 -v or pgadmin3 --version should show the version number; > > double clicking on the About dialog should allow selection of the text. ;-) > > > > I

Re: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh

2013-01-06 Thread Guillaume Lelarge
On Sun, 2013-01-06 at 11:27 -0600, Robert Klaus wrote: > Get all schemas, except some of them. One schema will have 90+% of the > database objects. > You can already do that without having a custom pgAdmin. > If we could eliminate that schema fewer rows would be returned by the > underlying

Re: [pgadmin-support] Can't access URLs in documentation

2013-01-06 Thread Guillaume Lelarge
On Thu, 2012-12-20 at 11:40 +0100, Victor Engmark wrote: > The documentation for pgAdmin 1.14.0 (installed from official Ubuntu > 12.04.1 repository) contains several URLs to external web pages (for > example in Help -> Bug Report). If I click any of these I get an error > message like the followin

Re: [pgadmin-support] remove variables

2013-01-06 Thread Guillaume Lelarge
On Fri, 2013-01-04 at 16:18 +0100, Bartosz Dmytrak wrote: > Hi, > one of my dbs has the following settings: > ALTER ROLE hibuser IN DATABASE kpi > SET default_transaction_read_only = 'off'; > ALTER DATABASE kpi > SET search_path = "$user", pg_temp; > > I would like to remove hibuser settings u

Re: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh

2013-01-06 Thread Robert Klaus
Get all schemas, except some of them. One schema will have 90+% of the database objects. If we could eliminate that schema fewer rows would be returned by the underlying queries, allowing us to continue using pgAdmin. I've only been working with this company (and postgresql) for 90 days so

Re: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh

2013-01-06 Thread Guillaume Lelarge
On Fri, 2013-01-04 at 09:18 -0600, Robert Klaus wrote: > Connecting to the database server just took 62 seconds, which defaults to the > database that has almost all of the 36,000+ objects. Another 40 seconds to > open any of the schemas within that database. Once the schema is opened any > o

Re: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh

2013-01-06 Thread Guillaume Lelarge
On Sat, 2013-01-05 at 12:38 -0600, Robert Klaus wrote: > Below, I deleted the logfile, connected to a database server, and immediately > copied the log here without doing anything else. It took 5+ minutes. > > Would someone be able to point me to a place in the source code where I can > add pre