Commitaddf9d5

Thomas G. Lockhart

committed

Include recipe for updating pg_aggregate to fix avg(money) function.

1 parentb268758 commitaddf9d5Copy full SHA for addf9d5

File tree

-0

lines changed

-0

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -4,3 +4,11 @@ but is required from any release prior to v6.2.`
`4`	`4`	`In upgrading from v6.2, if you choose to dump/reload you will find that`
`5`	`5`	`avg(money) is now calculated correctly. All other bug fixes take effect`
`6`	`6`	`upon updating the executables.`
	`7`	`+`
	`8`	`+Another way to avoid dump/reload is to use the following SQL command`
	`9`	`+from psql to update the existing system table:`
	`10`	`+`
	`11`	`+ update pg_aggregate set aggfinalfn = 'cash_div_flt8'`
	`12`	`+ where aggname = 'avg' and aggbasetype = 790;`
	`13`	`+`
	`14`	`+This will need to be done to every existing database, including template1.`

Comments

(0)