diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-10-25 05:05:06 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-10-25 05:05:06 +0000 |
| commit | 200bc52b8db1a5e711503bbdef237ce51425c578 (patch) | |
| tree | 942372d8fa5f4bf542878f5a198f8bb82930933c | |
| parent | 789d0750215f3612642b3201ffccb42cc866d2ea (diff) | |
Include explicit SQL update instructions.
Should have been here in time for 6.2.1 release...
| -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 294f5f0158e..09a4118d32b 100644 --- a/migration/6.2_to_6.2.1 +++ b/migration/6.2_to_6.2.1 @@ -12,3 +12,11 @@ from psql to update the existing system table: where aggname = 'avg' and aggbasetype = 790; This will need to be done to every existing database, including template1. + +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. |