Re: [pgadmin-support] Bug: Default parameters in functions not being maintained in pgAdmin definition
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
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
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
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
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