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 the information
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
>
> <[EMAIL PROTECTED]> wrote:
> > CVSROOT: /cvsroot
> > Module name: pgsql-server
> > Changes by: [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
