% pg_dump -sv regression > foo
...
--  dumping out user-defined procedural languages 
--  dumping out user-defined functions 
Segmentation fault (core dumped)

#0  0x4810dc02 in vfprintf ()
#1  0x480c4963 in vsprintf ()
#2  0x48078e8a in appendPQExpBuffer (str=0x616e746f, 
    fmt=0x3d20656d <Address 0x3d20656d out of bounds>) at pqexpbuffer.c:197
#3  0x6c732065 in ?? ()

% tail foo
    end if;
    return new;
end;
' LANGUAGE 'plpgsql';
CREATE FUNCTION "tg_iface_biu" ( ) RETURNS opaque AS '
declare
    sname       text;
    sysrec      record;
begin
    select into sysrec * from

ie., it stops in mid flight, the line is

    select into sysrec * from system where name = new.sysname;

so it seems that the PQExpBuffer may well be to full ?

-s means dumpSchema(), getFuncs(), dumpFuncs(), dumpOneFunc()

pg_dump.c:dumpOneFunc():2346:

        appendPQExpBuffer(q, " ) RETURNS %s%s AS '%s' LANGUAGE '%s';\n",
                        (finfo[i].retset) ? " SETOF " : "",
                        fmtId(findTypeByOid(tinfo, numTypes, finfo[i].prorettype), false),
                        func_def, func_lang);


so it cored while printing func_def ?! which is only 487 bytes long..
Rather confused.. Are any of you seeing this?

Cheers,

Patrick

Thu, 6 Jan 2000 22:56:22 +0000 (GMT)
"Patrick Welche,SCC,ext.35710," <prlw1@newn.cam.ac.uk>
pg_dump problem