1. Forum
  2. Usenet
  3. LINUX.DEBIAN.BUGS.DIST

  • Bug#266263: fails to dump functions

    From Kai Henningsen@1:229/2 to All on Tue Aug 17 11:10:12 2004
    From: [email protected]

    Package: postgresql-client
    Version: 7.4.3-3
    Severity: normal
    File: /usr/bin/pg_dump

    At least in text mode, pg_dump does not even dump SQL functions. (I have
    not tested the other formats.) For a utility that claims to be useful
    for backup, this seems like a rather bad problem.

    -- System Information:
    Debian Release: 3.1
    APT prefers testing
    APT policy: (650, 'testing'), (550, 'experimental'), (550, 'unstable') Architecture: i386 (i686)
    Kernel: Linux 2.4.23+kai.62
    Locale: LANG=de_DE, LC_CTYPE=de_DE

    Versions of packages postgresql-client depends on:
    ii debconf [debconf 1.4.30 Debian configuration management sy ii debianutils 2.8.4 Miscellaneous utilities specific t ii libc6 2.3.2.ds1-13 GNU C Library: Shared libraries an ii libkrb53 1.3.3-2 MIT Kerberos runtime libraries
    ii libpam0g 0.76-22 Pluggable Authentication Modules l ii libpq3 7.4.3-3 Shared library libpq.so.3 for Post ii libreadline4 4.3-11 GNU readline and history libraries ii libssl0.9.7 0.9.7d-4 SSL shared libraries
    ii mailx 1:8.1.2-0.20040524cvs-1 A simple mail user agent
    ii zlib1g 1:1.2.1.1-5 compression library - runtime

    -- debconf information:
    * postgresql-client/missing-postgresql.env: true


    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)
  • From Oliver Elphick@1:229/2 to Kai Henningsen on Tue Aug 17 11:40:13 2004
    From: [email protected]

    On Tue, 2004-08-17 at 09:54, Kai Henningsen wrote:
    Package: postgresql-client
    Version: 7.4.3-3
    Severity: normal
    File: /usr/bin/pg_dump

    At least in text mode, pg_dump does not even dump SQL functions. (I have
    not tested the other formats.) For a utility that claims to be useful
    for backup, this seems like a rather bad problem.

    I don't see this problem:

    $ pg_dump advacs
    ...[snip output]...
    --
    -- TOC entry 326 (OID 53964774)
    -- Name: get_text(character, oid, character); Type: FUNCTION; Schema:
    core; Owner: olly
    --

    CREATE FUNCTION get_text(character, oid, character) RETURNS text
    AS '
    SELECT translation
    FROM core.translation
    WHERE key = $1 AND
    tableid = $2 AND
    language = $3
    '
    LANGUAGE sql;

    ...[snip more output]...

    --
    Oliver Elphick [email protected]
    Isle of Wight http://www.lfix.co.uk/oliver
    GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
    ========================================
    "If ye abide in me, and my words abide in you, ye shall
    ask what ye will, and it shall be done unto you."
    John 15:7



    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)