Larry Rosenman wrote:
> Do we need to reinitdb to pick this up, or just run this file?
It's actually described in the release notes:
<para> If you want to install the fixes in the information schema concerning the bit types, you need to reload
theinformation schema. This is either accomplished by initializing a new cluster by running
<command>initdb</command>,or by running the following sequence of SQL commands in each database (ideally including
<literal>template1</literal>)as a superuser in <application>psql</application>, after installing the new release:
<programlisting>
DROP SCHEMA information_schema CASCADE;
\i /usr/local/pgsql/share/information_schema.sql
</programlisting> Substitute your installation path in the second command. </para>
> --On Sunday, December 07, 2003 06:18:50 -0400 Peter Eisentraut -
> PostgreSQL
>
> <petere@svr1.postgresql.org> wrote:
> > CVSROOT: /cvsroot
> > Module name: pgsql-server
> > Changes by: petere@svr1.postgresql.org 03/12/07 06:18:50
> >
> > Modified files:
> > doc/src/sgml : Tag: REL7_4_STABLE release.sgml
> > src/backend/catalog: Tag: REL7_4_STABLE information_schema.sql
> >
> > Log message:
> > Fix typmod interpretation for bit types. (It was erroneously
> > assumed that for bit(x), the typmod stores x+4, like for the
> > character types.)
> >
> >
> > ---------------------------(end of
> > broadcast)--------------------------- TIP 6: Have you searched our
> > list archives?
> >
> > http://archives.postgresql.org