pg_dump of regression db?
От | Philip Warner |
---|---|
Тема | pg_dump of regression db? |
Дата | |
Msg-id | 3.0.5.32.20000914025515.02a9c8a0@mail.rhyme.com.au обсуждение исходный текст |
Ответы |
Re: pg_dump of regression db?
|
Список | pgsql-hackers |
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 |/
В списке pgsql-hackers по дате отправления: