Re: [COMMITTERS] pgsql-server/ oc/src/sgml/Tag: oc/src/sgml/REL ...

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