Re: [pgadmin-support] 1.16.1: many operations cause display tree to collapse

2013-05-10 Thread Aren Cambre
Thanks. I'll shut up now. :-) You guys really need a bug tracker. On Thu, May 9, 2013 at 1:02 AM, Dave Page wrote: > Yes. > > > On Thursday, May 9, 2013, Aren Cambre wrote: > >> Is anyone paying attention to this? >> >> On Sun, Apr 14, 2013 at 9:13 A

Re: [pgadmin-support] 1.16.1: many operations cause display tree to collapse

2013-05-08 Thread Aren Cambre
Is anyone paying attention to this? On Sun, Apr 14, 2013 at 9:13 AM, Michael Shapiro wrote: > I can confirm this behavior as well. > > On Sun, Apr 14, 2013 at 8:52 AM, Aren Cambre wrote: > >> Just FYI, this bug is still present in 1.16.1 (Apr 2, 2013, rev: >> REL-1_16_

Re: [pgadmin-support] 1.16.1: many operations cause display tree to collapse

2013-04-14 Thread Aren Cambre
Just FYI, this bug is still present in 1.16.1 (Apr 2, 2013, rev: REL-1_16_1). As for whether it happens when adding columns, my experience on Windows 7 is that the tree doesn't collapse when when I add columns or do other modifications through the table's *Properties* dialog. Otherwise, it happens

Re: [pgadmin-support] Re: Group role not shown in properties > Default Privileges after adding it

2012-05-28 Thread Aren Cambre
> This doesn't make sense. If I create a login role, it should show up here >> and allow me to assign it to arbitrary tables. >> > > That's intentional (and configurable): see > http://www.pgadmin.org/support/faq.php#UserPrivileges > Argh, thanks. Now I remember running into this before. This nee

[pgadmin-support] Pasting of Excel data into tables

2012-02-22 Thread Aren Cambre
Is it possible to paste Excel data into tables, presuming the data and structure is similar to the Postgres table? It looks like I ought to be able to paste copied data into the Edit Data dialog, but that paste only ends up in one cell. E.g., if I have a table with 5 columns, and I copy a 5 col x

Re: [pgadmin-support] Query truncated in Server Status

2012-02-19 Thread Aren Cambre
Thanks! Yes, I am using Windows. Aren On Sun, Feb 19, 2012 at 5:12 AM, Guillaume Lelarge wrote: > On Sun, 2012-02-19 at 10:23 +0100, Guillaume Lelarge wrote: > > On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre wrote: > > > In the Server Status program, long que

Re: [pgadmin-support] Query truncated in Server Status

2012-02-18 Thread Aren Cambre
' end from (select "the_geom" from "raw"."dallas_rlc_summary" where "the_geom" is not null limit 100) as t* On Sat, Feb 18, 2012 at 6:54 PM, Aren Cambre wrote: > In the Server Status program, long queries get truncated. > > Pressing Ctrl-C or th

[pgadmin-support] Query truncated in Server Status

2012-02-18 Thread Aren Cambre
ery got truncated at the 250th character. I've reproduced on other queries. I'm OK if the query needs to be truncated to fit in the UI, but the whole query ought to be copied to the clipboard. This is making it challenging for me to analyze a problematic Quantum GIS query. Aren Cambre

Re: [pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

2012-01-14 Thread Aren Cambre
a proper answer. > It works fine for me with W7 and latest Pgadmin > > ------ > *From:* Aren Cambre > *To:* pgadmin-support@postgresql.org > *Sent:* Saturday, January 14, 2012 12:48 AM > *Subject:* [pgadmin-support] Feature request: associate .sql

[pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

2012-01-13 Thread Aren Cambre
On Windows systems, it sure would be nice if files with .sql extensions automatically open in pgAdmin III when I double click on them. It appears that pgAdmin may not register *.sql* extension at all, as even when I right-click and look at the *Open with* menu, I don't see pgAdmin III even listed.

Re: [pgadmin-support] Problems changing a view

2011-12-02 Thread Aren Cambre
Could pgAdmin detect if the view has no dependents and offer to drop and replace the view? My views generally have no dependents. Don't know if that's typical, however. Aren On Fri, Dec 2, 2011 at 3:08 AM, Dave Page wrote: > > > On Fri, Dec 2, 2011 at 3:47 AM, Aren Cambr

[pgadmin-support] Problems changing a view

2011-12-01 Thread Aren Cambre
If I change this view: * SELECT dallas_rlc_locations.location_code, count(dallas_rlc."CitationId") AS count, dallas_rlc_locations.location, dallas_rlc_locations.the_geom* * FROM raw.dallas_rlc_locations* * LEFT JOIN raw.dallas_rlc ON dallas_rlc."Loc Code" = dallas_rlc_locations.location_code* *

[pgadmin-support] Feature request: Select All in Query Builder

2011-08-27 Thread Aren Cambre
Feature request In Query Builder, when I add a relation to the design surface, all columns are unchecked. I'd like a way I can check or uncheck all items in the relation. Currently, the only way I can intuit to do this is to manually click every check box. Aren Cambre

Re: [pgadmin-support] Fields with long values show as blank in grid

2011-06-06 Thread Aren Cambre
Thanks. I didn't see it in your web site bugs list ( http://www.pgadmin.org/pgadmin3/bugs.php), but maybe I missed it? Aren On Mon, Jun 6, 2011 at 4:09 PM, Guillaume Lelarge wrote: > On Sun, 2011-06-05 at 21:03 -0500, Aren Cambre wrote: > > Sometimes with Pgadmin III, I view a ta

[pgadmin-support] Fields with long values show as blank in grid

2011-06-05 Thread Aren Cambre
Sometimes with Pgadmin III, I view a table that has a column of unrestricted length. It appears that if a cell in this column has too many characters, it displays as a blank cell in the grid. If I select that blank cell, press Ctrl-C, then paste into another program, then it is clear that there is

[pgadmin-support] Feature request: Allow Grant Wizard at lower level

2011-04-14 Thread Aren Cambre
If I have multiple schemas, it appears I have to run the Grant Wizard once per schema. Please allow the Grant Wizard to run at a lower level, such as on the Schemas item or on the database item, to allow me to run the Grant Wizard once for all applicable items in a database. Aren

Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-14 Thread Aren Cambre
54 AM, Dave Page wrote: > > > On Thu, Apr 14, 2011 at 1:51 PM, Aren Cambre wrote: > >> Thanks. I still consider this a usability bug. Even in enterprise IT, it >> is not uncommon to apply users directly to certain databases if there is >> only one user account tha

Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-14 Thread Aren Cambre
> EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> > > > > *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi> > > > On Thu, Apr 14, 2011 at 8:23 AM, Aren Cambre wrote: > >> The Grant Wizard's *

Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-13 Thread Aren Cambre
The Grant Wizard's *Privileges* tab only shows *public* in the dropdown. That dropdown shows nothing in the *Group Roles* or *Login Roles* section. By the way, below I meant that the dropdown on the *Privileges* tab isn't showing the roles. Aren On Wed, Apr 13, 2011 at 9:44 PM, A

[pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-13 Thread Aren Cambre
If I have a login role defined, the *Privileges *tab of the database properties dialog does not show that role. It only shows group roles. Also, searches on Google suggest that "login role" or "group role" are nonstandard terms. Aren

[pgadmin-support] Max SQL file size?

2010-12-14 Thread Aren Cambre
he command line" deal? Aren Cambre <>

Re: [pgadmin-support] UI feature requests

2010-11-27 Thread Aren Cambre
rote: > Le 27/11/2010 05:48, Aren Cambre a écrit : > > It's trivial if using .NET Framework, but not sure what you guys are > using. > > > > It's quite sure we're not using .NET as pgAdmin is available on Linux > and Mac OS X too :) > > We're u

Re: [pgadmin-support] UI feature requests

2010-11-26 Thread Aren Cambre
It's trivial if using .NET Framework, but not sure what you guys are using. Aren On Wed, Nov 24, 2010 at 5:00 PM, Guillaume Lelarge wrote: > Le 24/11/2010 17:39, Aren Cambre a écrit : > > More. :-) > > > >- In find/replace dialog in Query, if cursor in *Find what*

[pgadmin-support] UI feature requests

2010-11-24 Thread Aren Cambre
More. :-) - In find/replace dialog in Query, if cursor in *Find what* box and I press tab, cursor should go to the *Replace with* box. This is UI norm. Instead, *Find* button gets focus. One may argue, "But what if I just want to type something and search? Type chars-tab-enter." Respon

Re: [pgadmin-support] Foreign key UI bug

2010-11-20 Thread Aren Cambre
> > The simple patch attached forces one to type either the constraint name > or the index name. Which seems enough for me. > That sounds like a good resolution. Aren

[pgadmin-support] Foreign key UI bug

2010-11-20 Thread Aren Cambre
I found a UI bug when creating a foreign key. When creating a primary key, all you have to do is select the column in the *Columns* tab of the dialog. You don't have to fill out any other fields; pgadmin appears to take care of this for you. It seems then that with a foreign key, all you should h

[pgadmin-support] Two feature requests

2010-11-19 Thread Aren Cambre
Two feature requests to make pgadmin comply with UI norms: 1. If I press end on a line that is wrapped, the cursor only goes to the end of the line that appears on the screen, not to the end of the line as if it wasn't wrapped. For example, suppose I have this long line that is wrapped

Re: [pgadmin-support] Improper CSV export delimiter

2010-11-07 Thread Aren Cambre
> > Someone else could have used it. > > Anyway, I can't reproduce this. > It's my personal laptop. Guaranteed no other users. If you can't reproduce, I may be mistaken. Aren

Re: [pgadmin-support] Improper CSV export delimiter

2010-11-06 Thread Aren Cambre
> > Moreover, the value you have as a column separator comes from your last > export. You probably set it to a semi-colon the last time you used the > Export functionality. > This was the first time I ever used the dialog. Aren

Re: [pgadmin-support] Improper CSV export delimiter

2010-11-06 Thread Aren Cambre
to comma, I may end up doing an export and may risk a complex CSV edit later. (It's simple if you're just replacing *";"* with *","* but can be complex in certain scenarios.) Aren On Sat, Nov 6, 2010 at 4:19 PM, Thom Brown wrote: > On 6 November 2010 21:08, Aren

[pgadmin-support] Improper CSV export delimiter

2010-11-06 Thread Aren Cambre
Bug report: When I use File > Export from a Query window, it's clearly trying to make a CSV. The suggested filename is suffixed with .csv. The problem is the semicolon character is selected by default. That is not CSV. Please change this so the comma is the default delimiter. Now, I understand s