[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #7506: Windows 64 bit PGAdmin 1.14.3 plpgsql default parameter value not appearing
From:       Guillaume Lelarge <guillaume () lelarge ! info>
Date:       2012-08-26 6:32:57
Message-ID: 1345962777.1959.9.camel () localhost ! localdomain
[Download RAW message or body]

On Sat, 2012-08-25 at 00:56 +0000, crispond@gmail.com wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      7506
> Logged by:          Cris Pond
> Email address:      crispond@gmail.com
> PostgreSQL version: 9.1.5
> Operating system:   Windows 64 bit
> Description:        
> 
> Sorry, I'm having trouble posting a bug report to the pgAdmin site.

How so? you just need to send an email to pgadmin-support mailing list
(http://archives.postgresql.org/pgadmin-support/).

>   Please
> forward this on:
> 
> 
> It looks like this bug has come back in pgAdmin 1.14.3 for Windows 64bit:
> 
> http://code.pgadmin.org/trac/ticket/79
> 
> If you do the following:
> 
> ------
> CREATE OR REPLACE FUNCTION demo(level integer DEFAULT 0) RETURNS
> integer language 'plpgsql' AS $$
> BEGIN
>         return (level);
> END; $$;
> select demo(); --<---No error
> ------
> 
> The default parameter functions correctly.  The code showing in
> pgadmin, however, is missing the default:
> 
> -----
> drop function if exists demo(int);
> --Copied from pgAdmin
> CREATE OR REPLACE FUNCTION demo(level integer)
>   RETURNS integer AS
> $BODY$
> BEGIN
>         return (level);
> END; $BODY$
>   LANGUAGE plpgsql VOLATILE
>   COST 100;
> select demo(); --<---Error
> ------
> 
> I'm pretty sure pg_proc.proargdefaults contains the correct
> information and that pgadmin is just not interpreting it.  I tried
> executing the code on postgresql 8.4.3 and 9.1.5, and the field looked
> basically the same, but pgAdmin 1.10 is displaying correctly and
> pgAdmin 1.14.3 is not.
> 

This has been fixed in 1.16 in june, so you can have a fixed binary with
1.16 beta 4.


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



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]