Re: [pgadmin-support] Bug: Default parameters in functions not being maintained in pgAdmin definition

2012-09-11 Thread Guillaume Lelarge
On Fri, 2012-09-07 at 11:02 -0400, Paragon Corporation wrote:
> I'm using 1.16 beta 4 on Windows (the version that comes with EDB PostgreSQL
> 9.2RC1)
> 
> When I do this:
> 
> CREATE OR REPLACE FUNCTION test_defaults(param_int integer, param_def text
> DEFAULT NULL::text) 
>  RETURNS text AS
> $$
> SELECT $2;
> $$
> language sql; 
> 
> 
> Then right click or look in code paid to see the function created, it shows
> this:
> 
> CREATE OR REPLACE FUNCTION public.test_defaults(param_int integer, param_def
> text)
>   RETURNS text AS
> $BODY$
> SELECT $2;
> $BODY$
>   LANGUAGE sql VOLATILE
>   COST 100;
> 
> 
> As a result I can' reuse  it becauseit says default parameters can't be
> changed.
> 

Works for me on 1.16.0. Can you try on the final release, please?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


Re: [pgadmin-support] Double click to edit column

2012-09-11 Thread Guillaume Lelarge
Hi,

On Sat, 2012-09-08 at 18:02 +0300, Efe Erdoğru wrote:
> Hi,
> 
> I'll be very nice if we can edit a column by double clicking on it.
> 

Where? It already works in the browser if you checked the right option
(File/Options, then "UI Miscellaneous", and "Show object properties on
double click in treeview").


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


[pgadmin-support] pgAdmin v.1.16.0 now available

2012-09-11 Thread Guillaume Lelarge
The pgAdmin Development Team is pleased to announce the release of
pgAdmin 1.16.0, the Open Source graphical PostgreSQL administration tool
for Windows, Linux, FreeBSD, Mac OS X and Solaris, now available for
download in source and a variety of binary formats from:

http://www.postgresql.org/ftp/pgadmin3/release/v1.16.0/

The list of new features is available in the visual tour
(http://www.pgadmin.org/visualtour16.php). If you want the complete list
of changes, it's available in the changelog
(http://www.pgadmin.org/development/changelog.php).

Please report any issues you find to pgadmin-support@postgresql.org to
help us work on the next minor release.

Regards.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


[pgadmin-support] Upgrade.bat does nothing for 1.16.0

2012-09-11 Thread Guy Rouillier
Many thanks to the PgAdmin team for their years-long dedication to 
providing a top-notch end-user grahical tool for PostgreSQL.


I normally simply run the MSI file to upgrade from one version to the 
next.  This time, I decided to try the supplied upgrade.bat to see what 
if anything it did differently; I thought maybe it provided a hands-free 
upgrade.  Unfortunately, it didn't do anything for me (Windows 7 64-bit, 
current on all updates.)  I ran it, and it showed the setup program.  I 
got the popup from Windows asking me if I wanted to allow this program 
to make changes to my computer.  Once I clicked Ok, the setup window did 
something for about 3 more seconds and closed.  When I started PgAdmin 
from the start menu, version 1.14 was still installed.


--
Guy Rouillier


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


Re: [pgadmin-support] Upgrade.bat does nothing for 1.16.0

2012-09-11 Thread Dave Page
Hi

On Tue, Sep 11, 2012 at 8:10 PM, Guy Rouillier  wrote:
> Many thanks to the PgAdmin team for their years-long dedication to providing
> a top-notch end-user grahical tool for PostgreSQL.
>
> I normally simply run the MSI file to upgrade from one version to the next.
> This time, I decided to try the supplied upgrade.bat to see what if anything
> it did differently; I thought maybe it provided a hands-free upgrade.
> Unfortunately, it didn't do anything for me (Windows 7 64-bit, current on
> all updates.)  I ran it, and it showed the setup program.  I got the popup
> from Windows asking me if I wanted to allow this program to make changes to
> my computer.  Once I clicked Ok, the setup window did something for about 3
> more seconds and closed.  When I started PgAdmin from the start menu,
> version 1.14 was still installed.

You cannot upgrade from 1.14 to 1.16 - different major versions will
always install side-by-side. The upgrade script allows you to upgrade
a minor version, for example, from 1.16.0-beta4 to 1.16.0, or 1.16.1
to 1.16.2.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support