[pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

2012-07-18 Thread Daniel Serodio (lists)
I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE clauses for joins. It would be nice if it generated JOIN clauses instead. Thanks in advance, Daniel Serodio -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription:

Re: [pgadmin-support] default parameters

2012-07-18 Thread Maximilian Tyrtania
Am 02.07.2012 um 22:46 schrieb Guillaume Lelarge: > On Mon, 2012-07-02 at 15:04 +0400, Andrey Vinogradov wrote: >> Hi, >> >> There is a function with the default parameter: >> >> CREATE OR REPLACE FUNCTION test(p_int integer *default 1*) >> RETURNS void AS >> $BODY$declare >> begin >> --foo; >>

[pgadmin-support] schema diff

2012-07-18 Thread Michael Shapiro
I would like to to request a schema diff feature -- see the differences between the schemas of two databases. I realize this could be done with backup and an external diff tool, but it is cumbersome and generic diff tools don't give the necessary browsing capabilities. For example it would be nic

Re: [pgadmin-support] schema diff

2012-07-18 Thread Guillaume Lelarge
On Wed, 2012-07-18 at 10:14 -0500, Michael Shapiro wrote: > I would like to to request a schema diff feature -- see the differences > between the schemas of two databases. > I realize this could be done with backup and an external diff tool, but it > is cumbersome and generic diff tools don't give

Re: [pgadmin-support] default parameters

2012-07-18 Thread Guillaume Lelarge
On Wed, 2012-07-18 at 16:22 +0200, Maximilian Tyrtania wrote: > Am 02.07.2012 um 22:46 schrieb Guillaume Lelarge: > > > On Mon, 2012-07-02 at 15:04 +0400, Andrey Vinogradov wrote: > >> Hi, > >> > >> There is a function with the default parameter: > >> > >> CREATE OR REPLACE FUNCTION test(p_int i

Re: [pgadmin-support] Search the schema

2012-07-18 Thread Guillaume Lelarge
On Tue, 2012-07-17 at 20:52 +0200, Guillaume Lelarge wrote: > On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro wrote: > > No, it doesn't. > > > > For example, I want to see if a given string is used within a function. > > I want to be able to see all the uses of a function: in other functions, i

Re: [pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

2012-07-18 Thread Guillaume Lelarge
On Tue, 2012-07-17 at 20:06 -0300, Daniel Serodio (lists) wrote: > Nelson A. de Oliveira wrote: > > Hi! > > > > On Tue, Jul 17, 2012 at 7:36 PM, Daniel Serodio (lists) > > wrote: > >> I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE > >> clauses for joins. It would be nic

Re: [pgadmin-support] Rename database destroys server connections

2012-07-18 Thread Guillaume Lelarge
On Mon, 2012-07-16 at 11:05 -0400, Colin Beckingham wrote: > Using wxw 2.9.3, latest dev 1.17, Opensuse 12.1 > > With two servers connected, select database in object browser for > localhost. Click properties, select database name, edit to something > different, click OK. > > Error backtrace: >

Re: [pgadmin-support] Rename database destroys server connections

2012-07-18 Thread Colin Beckingham
On 07/18/2012 05:23 PM, Guillaume Lelarge wrote: On Mon, 2012-07-16 at 11:05 -0400, Colin Beckingham wrote: Using wxw 2.9.3, latest dev 1.17, Opensuse 12.1 With two servers connected, select database in object browser for localhost. Click properties, select database name, edit to something di

Re: [pgadmin-support] Search the schema

2012-07-18 Thread Michael Shapiro
What motivated me to ask for this feature was that I was looking to see if the dependents/dependencies tabs on function would show all the objects that use the function and the objects that the functions uses, including other functions, views, etc. Those relationships, I realize, are not explicitly