Package: pgadmin3 Version: 1.10.0-1 Severity: normal In a function argument with a default value this value are not shown in pgadmin3
When you try to change this function you get an error as when trying to change the function arguments An example of such a function: CREATE OR REPLACE FUNCTION public.demo(INOUT level integer DEFAULT 0) RETURNS integer LANGUAGE plpgsql STABLE STRICT AS $function$ BEGIN return; END; $function$ This function as viewed in pgadmin3: -- Function: demo(integer) -- DROP FUNCTION demo(integer); CREATE OR REPLACE FUNCTION demo(INOUT "level" integer) RETURNS integer AS $BODY$ BEGIN return; END; $BODY$ LANGUAGE 'plpgsql' STABLE STRICT COST 100; ALTER FUNCTION demo(integer) OWNER TO xxx; -- System Information: Debian Release: squeeze/sid APT prefers stable APT policy: (990, 'stable'), (500, 'proposed-updates'), (500, 'unstable'), (500, 'testing'), (1, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.30-1-686-bigmem (SMP w/1 CPU core) Locale: LANG=ru_RU.utf8, LC_CTYPE=ru_RU.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages pgadmin3 depends on: ii libc6 2.9-25 GNU C Library: Shared libraries ii libgcc1 1:4.4.1-3 GCC support library ii libkrb5-3 1.7dfsg~beta3-1 MIT Kerberos runtime libraries ii libpq5 8.4.0-2+b1 PostgreSQL C client library ii libstdc++6 4.4.1-3 The GNU Standard C++ Library v3 ii libwxbase2.8-0 2.8.10.1-0 wxBase library (runtime) - non-GUI ii libwxgtk2.8-0 2.8.10.1-0 wxWidgets Cross-platform C++ GUI t ii libxml2 2.7.3.dfsg-2.1 GNOME XML library ii libxslt1.1 1.1.24-2 XSLT processing library - runtime ii pgadmin3-data 1.10.0-1 graphical administration tool for Versions of packages pgadmin3 recommends: pn pgagent <none> (no description available) ii postgresql-client-8.4 [postgr 8.4.0-2+b1 front-end programs for PostgreSQL pgadmin3 suggests no packages. -- debconf-show failed
signature.asc
Description: PGP signature
