pgsql-server/ oc/src/sgml/Tag: oc/src/sgml/REL ...

Do we need to reinitdb to pick this up, or just run this file?

Curiousity.

--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

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

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 Tuesday, December 09, 2003 23:13:15 +0100 Peter Eisentraut
<peter_e@gmx.net> wrote:

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:

Thanks!

Thats what I get for not reading the SGML stuff.

quickie script did the trick.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749