File: 6.2_to_6.2.1

package info (click to toggle)
postgresql 6.3.2-8
  • links: PTS
  • area: main
  • in suites: hamm
  • size: 19,388 kB
  • ctags: 15,077
  • sloc: ansic: 158,988; sh: 5,379; java: 5,143; yacc: 4,891; tcl: 4,170; sql: 4,120; makefile: 2,615; lex: 906; cpp: 839; python: 836; perl: 678; asm: 70; csh: 5; sed: 2
file content (15 lines) | stat: -rw-r--r-- 596 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
This is a minor bug-fix release. A dump/reload is not required from v6.2,
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.