[Pkg-postgresql-public] Bug#769848: [postgresql-contrib-9.4] uuid-ossp strange parms

Bzzzz lazyvirus at gmx.com
Mon Nov 17 01:10:45 UTC 2014


Package: postgresql-contrib-9.4
Version: 9.4~beta3-3
Severity: normal

--- Please enter the report below this line. ---

Hi folks,

There are 2 Fn that pose a problem in this extension:
   uuid_generate_v3(namespace uuid, name text)
   uuid_generate_v5(namespace uuid, name text)
because pg_get_function_identity_arguments(func_oid)
and pg_get_function_arguments(func_oid) always return:
"namespace uuid, name text" as parameters instead of
"uuid, text".

This prevents to reconstitute these Fn full names in
an external python program (in order to grant or revoke
user rights.)

Jean-Yves

--- System information. ---
Architecture: amd64
Kernel:       Linux 3.16.0-4-amd64

Debian Release: jessie/sid
  500 unstable        www.deb-multimedia.org 
  500 unstable        ftp.fr.debian.org 
  500 trusty          ppa.launchpad.net 

--- Package information. ---
Depends                  (Version) | Installed
==================================-+-================
postgresql-9.4     (= 9.4~beta2-1) | 9.4~beta3-3
libc6                    (>= 2.15) | 2.19-13
libpq5              (>= 9.2~beta3) | 9.4~beta3-3
libselinux1            (>= 2.1.12) | 2.3-2
libssl1.0.0             (>= 1.0.0) | 1.0.1j-1
libuuid1                 (>= 2.16) | 2.25.2-2
libxml2                 (>= 2.7.4) | 2.9.2+dfsg1-1
libxslt1.1             (>= 1.1.25) | 1.1.28-2+b2
zlib1g                (>= 1:1.1.4) | 1:1.2.8.dfsg-2


Package's Recommends field is empty.

Suggests            (Version) | Installed
=============================-+-===========
libdbd-pg-perl                | 3.4.2-1



More information about the Pkg-postgresql-public mailing list