Re: pg_dump && aggregate bug

--On mardi 21 mai 2002 10:19 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Mathieu Arnold <mat(at)mat(dot)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

worked, thanks.
I wonder if it could go into a possible 7.1.2 if there is one ? :)

--
Mathieu Arnold