Re: [pgadmin-support] saved passwords deleted

2012-07-02 Thread Rohan Carly
On 17/02/2012 6:33 AM, Guillaume Lelarge wrote: On Wed, 2012-02-15 at 05:16 -0600, Michael Shapiro wrote: I have taken to making a copy of the password file so that when the connection fails and PgAdmin removes the password, I can put it back. I think I've found your issue. Here is the way to

Re: [pgadmin-support] default parameters

2012-07-02 Thread 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; > end;$BODY$ > LANGUAGE plpgsql VOLATILE > COST 100; > >

Re: [pgadmin-support] Prevent loss of query text when pgAdmin crashes or freezes

2012-07-02 Thread Guillaume Lelarge
On Mon, 2012-07-02 at 12:32 +1000, Evan Martin wrote: > I often have multiple SQL query windows open in pgAdmin (v1.14.3 on > Windows 7 x64). From time to time pgAdmin will crash or freeze (become > unresponsive) and would have to be killed. When this happens all unsaved > query text is lost, wh

[pgadmin-support] default parameters

2012-07-02 Thread Andrey Vinogradov
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; end;$BODY$ LANGUAGE plpgsql VOLATILE COST 100; The object browser of the pgAdmin III has been refreshed more than once. The SQL query o