I thought I would test the latest changes to pg_dump on the regression db,
and got the following output for an aggregate:
CREATE AGGREGATE newcnt (BASETYPE = opaque, SFUNC = int4inc, STYPE =
int4, INITCOND = '0' );
Unfortunately, the backend produces the following error when this statement
is executed:
ERROR: AggregateCreate: Type 'opaque' undefined
I vaguely recall seeing something about pg_dump not working of the
regression db, but would be interested to know if this is the known
problem, and if there is any value in trying to fix it.
psql shows the following:
regression=# \da newcnt List of aggregates Name | Type | Description
--------+-------------+-------------newcnt | (all types) |
(1 row)
whereas in 7.0.2, it shows int4, so my guess is that this is a problem with
pg_dump and the new function manager.
Any suggestions would be appreciated.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/