I've updated my Perl script to accommodate the version of the
procedures in the final release notes:
http://www.sitening.com/postgresql-update-2005-1
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On May 11, 2005, at 12:07 AM, Tom Lane wrote:
> Neil Conway <neilc@samurai.com> writes:
>> Note that if you're upgrading within a release series (e.g. 8.0.x to
>> 8.0.3) without a dump and reload, you will _not_ get the necessary
>> system catalog changes automatically. Tom's earlier mail describes the
>> procedure needed to correct the system catalog:
>
>> http://www.postgresql.org/about/news.315
>
> Also, note that that message was the zero-day-security-problem response
> to the issue, and that we since figured out cleaner responses. If you
> haven't yet implemented this in your own DBs, I would suggest following
> the procedures given in the final release notes, eg
> http://developer.postgresql.org/docs/postgres/release-7-4-8.html
>
> I expect these notes will shortly show up in the static documentation,
> eg
> http://www.postgresql.org/docs/7.4/static/release.html
> but they aren't there yet as I set finger to keyboard.
>
> regards, tom lane