[pgadmin-hackers] Feature request: option to highlight function calls in the SQL editor.

2014-12-18 Thread sunset9002
Hello: I don't know if this is the appropriate place to do a feature request, so excuse me if I'm wrong. I believe that it would be very useful to have an option to highlight or colour the calls to functions in the SQL editor. One tries to structure the queries so that they're as much readable as

[pgadmin-hackers] Feature Request

2014-01-20 Thread Jeff Sacksteder
It's not clear what list is appropriate for feature requests, so I'm guessing here. I'd like to be able to create database connections on Windows using the currently-logged-in user. Since PgAdmin stores connections per-user, that can be captured at the time the connection is created instead of dyn

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Guillaume Lelarge
Le 21/07/2010 17:33, Dave Page a écrit : > On Wed, Jul 21, 2010 at 4:23 PM, Thom Brown wrote: >> Is the reason I can no longer spy on commits via mailing list as they >> occur related to the migration to git? > > Yes. Magnus is still finishing off the commit hook that'll deal with > that. I'm try

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Dave Page
On Wed, Jul 21, 2010 at 4:23 PM, Thom Brown wrote: > Is the reason I can no longer spy on commits via mailing list as they > occur related to the migration to git? Yes. Magnus is still finishing off the commit hook that'll deal with that. I'm trying to find cycles to help him test it -- Dav

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
On 21 July 2010 16:01, Thom Brown wrote: > On 21 July 2010 15:46, Dave Page wrote: >> On Wed, Jul 21, 2010 at 2:44 PM, Thom Brown wrote: >>> On 21 July 2010 14:32, Dave Page wrote: On Wed, Jul 21, 2010 at 2:26 PM, Guillaume Lelarge wrote: > > Tried it. Still works for me. I'm

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
On 21 July 2010 15:46, Dave Page wrote: > On Wed, Jul 21, 2010 at 2:44 PM, Thom Brown wrote: >> On 21 July 2010 14:32, Dave Page wrote: >>> On Wed, Jul 21, 2010 at 2:26 PM, Guillaume Lelarge >>> wrote: Tried it. Still works for me. I'm on Linux, but I don't think it is the issue

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Dave Page
On Wed, Jul 21, 2010 at 2:44 PM, Thom Brown wrote: > On 21 July 2010 14:32, Dave Page wrote: >> On Wed, Jul 21, 2010 at 2:26 PM, Guillaume Lelarge >> wrote: >>> >>> Tried it. Still works for me. I'm on Linux, but I don't think it is the >>> issue :) >> >> Actually, it might be. pgRule::CanDrop()

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
On 21 July 2010 14:32, Dave Page wrote: > On Wed, Jul 21, 2010 at 2:26 PM, Guillaume Lelarge > wrote: >> >> Tried it. Still works for me. I'm on Linux, but I don't think it is the >> issue :) > > Actually, it might be. pgRule::CanDrop() is calling schema->CanDrop(), > however schema actually cont

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Dave Page
On Wed, Jul 21, 2010 at 2:26 PM, Guillaume Lelarge wrote: > > Tried it. Still works for me. I'm on Linux, but I don't think it is the > issue :) Actually, it might be. pgRule::CanDrop() is calling schema->CanDrop(), however schema actually contains the table object. I think this is because rules

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Guillaume Lelarge
On Wed, 21 Jul 2010 14:12:37 +0100, Thom Brown wrote: > On 21 July 2010 14:06, Guillaume Lelarge wrote: >> On Wed, 21 Jul 2010 14:04:09 +0100, Dave Page wrote: >>> On Wed, Jul 21, 2010 at 2:01 PM, Thom Brown wrote: On 21 July 2010 10:45, Thom Brown wrote: > On 21 July 2010 10:38, Guil

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
On 21 July 2010 14:06, Guillaume Lelarge wrote: > On Wed, 21 Jul 2010 14:04:09 +0100, Dave Page wrote: >> On Wed, Jul 21, 2010 at 2:01 PM, Thom Brown wrote: >>> On 21 July 2010 10:45, Thom Brown wrote: On 21 July 2010 10:38, Guillaume Lelarge > wrote: > On Wed, 21 Jul 2010 10:23:33 +0

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Dave Page
On Wed, Jul 21, 2010 at 2:06 PM, Guillaume Lelarge wrote: > Works for me with PostgreSQL 9.0 beta 3 and pgAdmin 1.12 beta 3. I can reproduce on Windows with trunk + pg84 and Mac with 9.0b3/1.12b3 -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Se

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Guillaume Lelarge
On Wed, 21 Jul 2010 14:04:09 +0100, Dave Page wrote: > On Wed, Jul 21, 2010 at 2:01 PM, Thom Brown wrote: >> On 21 July 2010 10:45, Thom Brown wrote: >>> On 21 July 2010 10:38, Guillaume Lelarge wrote: On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown wrote: > On 21 July 2010 10:03,

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Dave Page
On Wed, Jul 21, 2010 at 2:01 PM, Thom Brown wrote: > On 21 July 2010 10:45, Thom Brown wrote: >> On 21 July 2010 10:38, Guillaume Lelarge wrote: >>> On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown >>> wrote: On 21 July 2010 10:03, Guillaume Lelarge wrote: > On Wed, 21 Jul 2010 09:43:33

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
On 21 July 2010 10:45, Thom Brown wrote: > On 21 July 2010 10:38, Guillaume Lelarge wrote: >> On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown >> wrote: >>> On 21 July 2010 10:03, Guillaume Lelarge wrote: On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown wrote: > I noticed you can't d

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
On 21 July 2010 10:38, Guillaume Lelarge wrote: > On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown > wrote: >> On 21 July 2010 10:03, Guillaume Lelarge wrote: >>> On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown >>> wrote: I noticed you can't drop rules from the GUI.  Could this be added?

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Guillaume Lelarge
On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown wrote: > On 21 July 2010 10:03, Guillaume Lelarge wrote: >> On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown >> wrote: >>> I noticed you can't drop rules from the GUI.  Could this be added? >>> >> >> It's already available. I see it, and I can drop a

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
On 21 July 2010 10:03, Guillaume Lelarge wrote: > On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown > wrote: >> I noticed you can't drop rules from the GUI.  Could this be added? >> > > It's already available. I see it, and I can drop a rule. > > -- Hmm... then it might be my version. I'm using 1.

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Dave Page
On Wed, Jul 21, 2010 at 10:03 AM, Guillaume Lelarge wrote: > On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown > wrote: >> I noticed you can't drop rules from the GUI.  Could this be added? >> > > It's already available. I see it, and I can drop a rule. That's what I thought, but I tried it and I c

Re: [pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Guillaume Lelarge
On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown wrote: > I noticed you can't drop rules from the GUI. Could this be added? > It's already available. I see it, and I can drop a rule. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-hackers mailing list (pgadmin-ha

[pgadmin-hackers] Feature request: drop rules

2010-07-21 Thread Thom Brown
I noticed you can't drop rules from the GUI. Could this be added? Thanks Thom -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Feature request: threaded processes

2010-06-01 Thread Dave Page
On Tue, Jun 1, 2010 at 5:32 PM, Guillaume Lelarge wrote: > Le 01/06/2010 16:45, Thom Brown a écrit : >> I notice that pgAdmin often locks up while it's doing something, like >> vacuuming or restoring a database.  Would it be possible to have this >> run in a separate thread instead of locking the

Re: [pgadmin-hackers] Feature request: threaded processes

2010-06-01 Thread Guillaume Lelarge
Le 01/06/2010 16:45, Thom Brown a écrit : > I notice that pgAdmin often locks up while it's doing something, like > vacuuming or restoring a database. Would it be possible to have this > run in a separate thread instead of locking the whole app up? The maintenance dialog uses the same connection

[pgadmin-hackers] Feature request: threaded processes

2010-06-01 Thread Thom Brown
I notice that pgAdmin often locks up while it's doing something, like vacuuming or restoring a database. Would it be possible to have this run in a separate thread instead of locking the whole app up? And maybe be minimisable so that it appears somewhere as a running task, allowing the user to do

Re: [pgadmin-hackers] Feature request: limited deletions

2010-04-08 Thread Thom Brown
On 8 April 2010 11:55, Ian Barwick wrote: > 2010/4/8 Thom Brown : > > I couldn't find any discussion on this, but the request is quite > > straightforward. Implement a LIMIT on DELETE statements like SELECT > > statements. > > > > So you could write: > > > > DELETE FROM massive_table WHERE id <

Re: [pgadmin-hackers] Feature request: limited deletions

2010-04-08 Thread Ian Barwick
2010/4/8 Thom Brown : > I couldn't find any discussion on this, but the request is quite > straightforward.  Implement a LIMIT on DELETE statements like SELECT > statements. > > So you could write: > > DELETE FROM massive_table WHERE id < 4000 LIMIT 1; > > This would allow deletions in smal

[pgadmin-hackers] Feature request: limited deletions

2010-04-08 Thread Thom Brown
I couldn't find any discussion on this, but the request is quite straightforward. Implement a LIMIT on DELETE statements like SELECT statements. So you could write: DELETE FROM massive_table WHERE id < 4000 LIMIT 1; This would allow deletions in smaller batches rather than waiting poten

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Guillaume Lelarge
Le 22/12/2009 14:23, Thom Brown a écrit : > 2009/12/22 Dave Page > >> On Tue, Dec 22, 2009 at 1:16 PM, Guillaume Lelarge >> wrote: >>> Done. I didn't backpatch it on the 1.10 branch. I don't think we should >>> do this but I don't really have a hard feeling on this, so tell me if it >>> needs to

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Thom Brown
2009/12/22 Dave Page > On Tue, Dec 22, 2009 at 1:16 PM, Guillaume Lelarge > wrote: > > Done. I didn't backpatch it on the 1.10 branch. I don't think we should > > do this but I don't really have a hard feeling on this, so tell me if it > > needs to be done. > > It's not a bug fix so it doesn't g

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Dave Page
On Tue, Dec 22, 2009 at 1:16 PM, Guillaume Lelarge wrote: > Done. I didn't backpatch it on the 1.10 branch. I don't think we should > do this but I don't really have a hard feeling on this, so tell me if it > needs to be done. It's not a bug fix so it doesn't get back patched. -- Dave Page Ent

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Guillaume Lelarge
Le 22/12/2009 11:07, Thom Brown a écrit : > 2009/12/22 Guillaume Lelarge > >> Le 22/12/2009 11:02, Thom Brown a écrit : >>> 2009/12/22 Dave Page >>> On Mon, Dec 21, 2009 at 5:37 PM, Guillaume Lelarge wrote: > Le 21/12/2009 15:41, Thom Brown a écrit : >> [...] >> Not so muc

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Thom Brown
2009/12/22 Guillaume Lelarge > Le 22/12/2009 11:02, Thom Brown a écrit : > > 2009/12/22 Dave Page > > > >> On Mon, Dec 21, 2009 at 5:37 PM, Guillaume Lelarge > >> wrote: > >>> Le 21/12/2009 15:41, Thom Brown a écrit : > [...] > Not so much a feature request but a tweak to a default se

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Guillaume Lelarge
Le 22/12/2009 11:02, Thom Brown a écrit : > 2009/12/22 Dave Page > >> On Mon, Dec 21, 2009 at 5:37 PM, Guillaume Lelarge >> wrote: >>> Le 21/12/2009 15:41, Thom Brown a écrit : [...] Not so much a feature request but a tweak to a default settings. The >> guys at work agree that c

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Dave Page
On Tue, Dec 22, 2009 at 10:03 AM, Magnus Hagander wrote: > 2009/12/22 Dave Page : >> On Tue, Dec 22, 2009 at 9:59 AM, Magnus Hagander wrote: >> >>> We still have an explicit option in the right-click menu to do it, right? >> >> What right-click menu? > > Right click on an object in the tree. Oh

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Magnus Hagander
2009/12/22 Dave Page : > On Tue, Dec 22, 2009 at 9:59 AM, Magnus Hagander wrote: > >> We still have an explicit option in the right-click menu to do it, right? > > What right-click menu? Right click on an object in the tree. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.r

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Thom Brown
2009/12/22 Dave Page > On Mon, Dec 21, 2009 at 5:37 PM, Guillaume Lelarge > wrote: > > Le 21/12/2009 15:41, Thom Brown a écrit : > >> [...] > >> Not so much a feature request but a tweak to a default settings. The > guys > >> at work agree that copying the creation script for a database object

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Guillaume Lelarge
Le 22/12/2009 10:57, Dave Page a écrit : > On Mon, Dec 21, 2009 at 5:37 PM, Guillaume Lelarge > wrote: >> Le 21/12/2009 15:41, Thom Brown a écrit : >>> [...] >>> Not so much a feature request but a tweak to a default settings. The guys >>> at work agree that copying the creation script for a data

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Dave Page
On Tue, Dec 22, 2009 at 9:59 AM, Magnus Hagander wrote: > We still have an explicit option in the right-click menu to do it, right? What right-click menu? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Magnus Hagander
2009/12/22 Dave Page : > On Mon, Dec 21, 2009 at 5:37 PM, Guillaume Lelarge > wrote: >> Le 21/12/2009 15:41, Thom Brown a écrit : >>> [...] >>> Not so much a feature request but a tweak to a default settings.  The guys >>> at work agree that copying the creation script for a database object into a

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Dave Page
On Mon, Dec 21, 2009 at 5:37 PM, Guillaume Lelarge wrote: > Le 21/12/2009 15:41, Thom Brown a écrit : >> [...] >> Not so much a feature request but a tweak to a default settings.  The guys >> at work agree that copying the creation script for a database object into a >> new query window is a bit a

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-22 Thread Dave Page
On Mon, Dec 21, 2009 at 2:41 PM, Thom Brown wrote: > Hi, > > Not so much a feature request but a tweak to a default settings.  The guys > at work agree that copying the creation script for a database object into a > new query window is a bit annoying and unnecessary as we always end up > having to

Re: [pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-21 Thread Guillaume Lelarge
Le 21/12/2009 15:41, Thom Brown a écrit : > [...] > Not so much a feature request but a tweak to a default settings. The guys > at work agree that copying the creation script for a database object into a > new query window is a bit annoying and unnecessary as we always end up > having to clear the

[pgadmin-hackers] Feature request: disable copying SQL from main window to query tool by default

2009-12-21 Thread Thom Brown
Hi, Not so much a feature request but a tweak to a default settings. The guys at work agree that copying the creation script for a database object into a new query window is a bit annoying and unnecessary as we always end up having to clear the window each time before typing anything. I imagine

Re: [pgadmin-hackers] feature request for pgadmin - export options

2008-01-11 Thread Guillaume Lelarge
Christian Nicolaisen a écrit : I am a happy user of pgAdmin, but one feature went missing several versions ago. The missing feature is xls export. More than a XLS export, a complete export tool is needed. I've been thinking about this for quite some time as my brother in law keeps asking me

[pgadmin-hackers] feature request for pgadmin - export options

2008-01-10 Thread Christian Nicolaisen
Hi I am a happy user of pgAdmin, but one feature went missing several versions ago. The missing feature is xls export. What I would like to have is xls (for use with MS Excel) or ods (for use with OpenOffice Calc) export so I don't have to go through csv files to export quick SQL reports.

Re: [pgadmin-hackers] Feature request

2007-03-14 Thread Guillaume Lelarge
Milen A. Radev a ecrit le 14/03/2007 16:55: Kevin Macdonald wrote: Version: pgAdmin III 1.6.2 I would like to make two feature requests for the "Query Tool". Background: Our environment includes a number Postgres installations. For each installation, we have defined a number of accounts (eg. p

Re: [pgadmin-hackers] Feature request

2007-03-14 Thread Milen A. Radev
Kevin Macdonald wrote: > Version: pgAdmin III 1.6.2 > > I would like to make two feature requests for the "Query Tool". > > Background: Our environment includes a number Postgres installations. > For each installation, we have defined a number of accounts (eg. > postgres, and various restricted u

Re: [pgadmin-hackers] Feature request

2007-03-14 Thread Guillaume Lelarge
Kevin Macdonald a ecrit le 14/03/2007 16:25: [...] REQUEST 1 - Often, I have a number of "Query Tool" windows open at any one time -- each connected to a different database and through a different account. It would be very useful to know which window points where. One way would be to

[pgadmin-hackers] Feature request

2007-03-14 Thread Kevin Macdonald
Version: pgAdmin III 1.6.2 I would like to make two feature requests for the "Query Tool". Background: Our environment includes a number Postgres installations. For each installation, we have defined a number of accounts (eg. postgres, and various restricted user-level accounts.) REQUEST 1

Re: [pgadmin-hackers] feature request: expose sql formatter

2007-02-07 Thread Merlin Moncure
On 2/6/07, Dave Page <[EMAIL PROTECTED]> wrote: Merlin Moncure wrote: > hello all, I have a pie in the sky feature request here. I've been > looking around for a sql 'beautifier' so that all our ddl which is > stored in .sql files can be cleaned up. pgadmin has a much better > formatter than th

Re: [pgadmin-hackers] feature request: expose sql formatter

2007-02-06 Thread Dave Page
Merlin Moncure wrote: > hello all, I have a pie in the sky feature request here. I've been > looking around for a sql 'beautifier' so that all our ddl which is > stored in .sql files can be cleaned up. pgadmin has a much better > formatter than the gook emitted by pg_dump... > > couple of questi

[pgadmin-hackers] feature request: expose sql formatter

2007-02-06 Thread Merlin Moncure
hello all, I have a pie in the sky feature request here. I've been looking around for a sql 'beautifier' so that all our ddl which is stored in .sql files can be cleaned up. pgadmin has a much better formatter than the gook emitted by pg_dump... couple of questions here: * would it be possible

Re: [pgadmin-hackers] Feature Request

2003-12-10 Thread Andreas Pflug
Adam H. Pendleton wrote: ... I cut and paste the schema out of the schema "preview" pane, only to find that the text didn't use the windows line delimiter. It seems that the lines in the window are terminated with just a line feed character, instead of the CRLF used byWindows. Can we change t

Re: [pgadmin-hackers] Feature Request

2003-12-09 Thread Andreas Pflug
Adam H. Pendleton wrote: I know I've been quiet lately, but I was working with pgAdmin3 today, and I wanted to print out the schema from a table, but there is no print feature. Is it possible to implement one, and if so how hard would it be? After finding I couldn't print, I cut and paste the

[pgadmin-hackers] Feature Request

2003-12-09 Thread Adam H. Pendleton
I know I've been quiet lately, but I was working with pgAdmin3 today, and I wanted to print out the schema from a table, but there is no print feature. Is it possible to implement one, and if so how hard would it be? After finding I couldn't print, I cut and paste the schema out of the schema