Re: pg_dump && aggregate bug - Mailing list pgsql-bugs

Mathieu Arnold <mat@mat.cc> writes:
> when I dump my database, in the dump file, the aggregate becomes :

> CREATE AGGREGATE first ( BASETYPE = text, SFUNC = first_cat, STYPE = text,
> INITCOND = '' );

Ooops.  This seems to be fixed already in current sources, but I think
a back-patch to 7.2 may be warranted.  Try this around line 1912:

        agginfo[i].aggbasetype = strdup(PQgetvalue(res, i, i_aggbasetype));
-       agginfo[i].agginitval = strdup(PQgetvalue(res, i, i_agginitval));
+       if (PQgetisnull(res, i, i_agginitval))
+           agginfo[i].agginitval = NULL;
+       else
+           agginfo[i].agginitval = strdup(PQgetvalue(res, i, i_agginitval));
        agginfo[i].usename = strdup(PQgetvalue(res, i, i_usename));

            regards, tom lane