Commit200bc52

Thomas G. Lockhart

committed

Include explicit SQL update instructions.

Should have been here in time for 6.2.1 release...

1 parent789d075 commit200bc52Copy full SHA for 200bc52

File tree

-0

lines changed

-0

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -12,3 +12,11 @@ from psql to update the existing system table:`
`12`	`12`	`where aggname = 'avg' and aggbasetype = 790;`
`13`	`13`
`14`	`14`	`This will need to be done to every existing database, including template1.`
	`15`	`+`
	`16`	`+Another way to avoid dump/reload is to use the following SQL command`
	`17`	`+from psql to update the existing system table:`
	`18`	`+`
	`19`	`+ update pg_aggregate set aggfinalfn = 'cash_div_flt8'`
	`20`	`+ where aggname = 'avg' and aggbasetype = 790;`
	`21`	`+`
	`22`	`+This will need to be done to every existing database, including template1.`

Comments

(0)