pg_dump of regression (again)
От | Philip Warner |
---|---|
Тема | pg_dump of regression (again) |
Дата | |
Msg-id | 3.0.5.32.20000914210949.036e13d0@mail.rhyme.com.au обсуждение исходный текст |
Ответы |
Re: pg_dump of regression (again)
|
Список | pgsql-hackers |
Continuing to try to use format_type to output all types, I get the following in the regression database: CREATE AGGREGATE newavg ( BASETYPE = integer, SFUNC = int4_accum, STYPE = "numeric[]", INITCOND = '{0,0,0}', FINALFUNC= numeric_avg ); where the original source was: CREATE AGGREGATE newavg ( sfunc = int4_accum, basetype = int4, stype = _numeric, finalfunc = numeric_avg, initcond1= '{0,0,0}' ); The problem is the "numeric[]" type. Does this mean I should go back to just using typnam for aggregates? For all but table definitions? Or is there an alternate solution. ---------------------------------------------------------------- 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 по дате отправления: