Re: [BUGS] pg_dump && aggregate bug

2002-05-27 Thread Mathieu Arnold
--On mardi 21 mai 2002 10:19 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Mathieu Arnold <[EMAIL PROTECTED]> writes: >> when I dump my database, in the dump file, the aggregate becomes : > >> CREATE AGGREGATE first ( BASETYPE = text, SFUNC = first_cat, STYPE = >> text, INITCOND = '' ); > > Ooop

Re: [BUGS] pg_dump && aggregate bug

2002-05-21 Thread Tom Lane
Mathieu Arnold <[EMAIL PROTECTED]> 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

[BUGS] pg_dump && aggregate bug

2002-05-21 Thread Mathieu Arnold
Hi I have : CREATE FUNCTION "first_cat" (text,text) RETURNS text AS 'SELECT CASE WHEN $1 IS NULL THEN $2 ELSE $1 END' LANGUAGE 'sql'; and : CREATE AGGREGATE first ( BASETYPE = text, SFUNC = first_cat, STYPE = text); when I dump my database, in the dump file, the aggregate becomes : CREATE A