Re: [pgadmin-support] pgAdmin brilliant - couple of little things

2006-12-15 Thread Raymond O'Donnell
On 15 Dec 2006 at 13:55, Dave Page wrote: > > something. This really annoying, because when I click on the main > > pgAdmin window, I have to move the help one out of the way first. > > Unfortunately that's down to the wxWidgets library we use. I agree it can I get around it by creating a new s

Re: [pgadmin-support] Error dropping constraint (case sensitivity)

2006-12-15 Thread Dave Page
M S wrote: Hi, I just produced and error message when trying to drop a constraint on a table which is in a schema with a mixed-case name. --- pgAdmin III --- An error has occurred: ERROR: schema "mycomponent" does not exist Thanks, fixed in S

[pgadmin-support] Error dropping constraint (case sensitivity)

2006-12-15 Thread M S
Hi, I just produced and error message when trying to drop a constraint on a table which is in a schema with a mixed-case name. --- pgAdmin III --- An error has occurred: ERROR: schema "mycomponent" does not exist --- OK

Re: [pgadmin-support] Menu accelerators don't work when another window

2006-12-15 Thread Dave Page
Daniel Segall wrote: Summary: If I have two Query windows open, and one has a modal dialog open, I cannot execute queries in the other one by pressing F5. Using the mouse to select Query -> Execute, however, does work. Hmm, odd - there's no obvious reason for that - I suspect it will end u

Re: [pgadmin-support] pgAdmin brilliant - couple of little things

2006-12-15 Thread Dave Page
David Gould wrote: Hi, We're now producing our database in PGSQL, switching from M$ SQL Server, and I think that pgAdmin is a fantastic tool. The following refer to 1.6.1 on Win32. I have two minor issues: (1) In the SQL Editor tool, File and Favourites are both configured to use 'F' as an ac

[pgadmin-support] Does New Server Registration Support entering both username and password?

2006-12-15 Thread Kieran McCusker
Hi I may be being dumb but I cannot see a way for creating a server registration that leaves both the username and password blank until connection time. In our organisation we have client jobs separated into schemas and were planning on a separate userid/login for each schema to allow staff

[pgadmin-support] pgAdmin brilliant - couple of little things

2006-12-15 Thread David Gould
Hi, We're now producing our database in PGSQL, switching from M$ SQL Server, and I think that pgAdmin is a fantastic tool. The following refer to 1.6.1 on Win32. I have two minor issues: (1) In the SQL Editor tool, File and Favourites are both configured to use 'F' as an access key. This is r

[pgadmin-support] pgAdmin brilliant - couple of little things

2006-12-15 Thread David Gould
Hi, We're now producing our database in PGSQL, switching from M$ SQL Server, and I think that pgAdmin is a fantastic tool. The following refer to 1.6.1 on Win32. I have two minor issues: (1) In the SQL Editor tool, File and Favourites are both configured to use 'F' as an access key. This i

Re: [pgadmin-support] Newbie questions, diff between functions and

2006-12-15 Thread M S
I'd be in favour of removing the distinction - a few people have asked me about the difference. > It's a historic thing - procedures actually appeared in > early versions of EnterpriseDB originally where they were > considered different objects from functions if memory > serves. The distinction

Re: [pgadmin-support] Empty tables show no field headings

2006-12-15 Thread M S
I see this as well, Win XP, pgAdmin 1.6.1, Postgres 8.2. Cheers. >In v1.6.1, when I go to view the data for a table with no (zero) rows, I don't see the columns of the table and no place to key a new record. The table does >have a primary key, and when it's got rows in, I can edit and add new