| From: | Mathieu Arnold <mat(at)mat(dot)cc> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | pg_dump && aggregate bug |
| Date: | 2002-05-21 12:13:55 |
| Message-ID: | 2320161025.1021990435@andromede.reaumur.absolight.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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 AGGREGATE first ( BASETYPE = text, SFUNC = first_cat, STYPE = text,
INITCOND = '' );
which is *not* the same as you may imagine...
To dump my database, I use :
pg_dump -c
and I use :
PostgreSQL 7.2.1 on i386-portbld-freebsd4.5, compiled by GCC 2.95.3
I believe it lies around lines 3860 - 3864 of src/bin/pg_dump/pg_dump.c,
but I don't find what's wrong with it.
--
Mathieu Arnold
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-21 14:12:20 | Re: Bug #670: netmask displayed for a /32 |
| Previous Message | pgsql-bugs | 2002-05-21 11:22:29 | Bug #670: netmask displayed for a /32 |