diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-10-17 05:34:58 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-10-17 05:34:58 +0000 |
| commit | addf9d5f2eb86fb78c9e687256ba5218e1e194fc (patch) | |
| tree | bc6228f4ac743e05325c027bfa9f9638c1315c35 | |
| parent | b268758a3b446fd34a826f122ec7d73a911aa11e (diff) | |
Include recipe for updating pg_aggregate to fix avg(money) function.
| -rw-r--r-- | migration/6.2_to_6.2.1 | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/migration/6.2_to_6.2.1 b/migration/6.2_to_6.2.1 index 7842c1714a1..294f5f0158e 100644 --- a/migration/6.2_to_6.2.1 +++ b/migration/6.2_to_6.2.1 @@ -4,3 +4,11 @@ but is required from any release prior to v6.2. In upgrading from v6.2, if you choose to dump/reload you will find that avg(money) is now calculated correctly. All other bug fixes take effect upon updating the executables. + +Another way to avoid dump/reload is to use the following SQL command +from psql to update the existing system table: + + update pg_aggregate set aggfinalfn = 'cash_div_flt8' + where aggname = 'avg' and aggbasetype = 790; + +This will need to be done to every existing database, including template1. |