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

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

From
Larry Rosenman
Date:
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

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

From
Peter Eisentraut
Date:
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



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

From
Larry Rosenman
Date:

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