Commit0d5fce3

committed

Restore information schema upgrade instructions of Peter.

1 parent4b1a35b commit0d5fce3Copy full SHA for 0d5fce3

File tree

+28

-1

lines changed

+28

-1

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -11,6 +11,17 @@`
`11`	`11`	`Migration to version 7.4`
`12`	`12`
`13`	`13`	`A dump/restore is not required for those running 7.4.`
	`14`	`+`
	`15`	`+ If you want to install the fixes in the information schema concerning`
	`16`	`+ the bit types, you need to reload the information schema. This is`
	`17`	`+ either accomplished by initializing a new cluster by running "initdb",`
	`18`	`+ or by running the following sequence of SQL commands in each database`
	`19`	`+ (ideally including template1) as a superuser in psql, after installing`
	`20`	`+ the new release:`
	`21`	`+DROP SCHEMA information_schema CASCADE;`
	`22`	`+\i /usr/local/pgsql/share/information_schema.sql`
	`23`	`+`
	`24`	`+ Substitute your installation path in the second command.`
`14`	`25`	`_________________________________________________________________`
`15`	`26`
`16`	`27`	`Changes`

Lines changed: 17 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.247 2003/12/15 22:24:59 momjian Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.248 2003/12/17 07:07:00 momjian Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<appendix id="release">`
`@@ -25,6 +25,22 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.247 2003/12/15 22:24:59 momjian`
`25`	`25`	`A dump/restore is <emphasis>not</emphasis> required for those`
`26`	`26`	`running 7.4.`
`27`	`27`	`</para>`
	`28`	`+`
	`29`	`+ <para>`
	`30`	`+ If you want to install the fixes in the information schema`
	`31`	`+ concerning the bit types, you need to reload the information`
	`32`	`+ schema. This is either accomplished by initializing a new cluster`
	`33`	`+ by running <command>initdb</command>, or by running the following`
	`34`	`+ sequence of SQL commands in each database (ideally including`
	`35`	`+ <literal>template1</literal>) as a superuser in`
	`36`	`+ <application>psql</application>, after installing the new release:`
	`37`	`+<programlisting>`
	`38`	`+DROP SCHEMA information_schema CASCADE;`
	`39`	`+\i /usr/local/pgsql/share/information_schema.sql`
	`40`	`+</programlisting>`
	`41`	`+ Substitute your installation path in the second command.`
	`42`	`+ </para>`
	`43`	`+`
`28`	`44`	`</sect2>`
`29`	`45`
`30`	`46`	`<sect2>`

Comments

(0)