[ADMIN] re-create information_schema

2012-02-29 Thread Ray Stell
on rebuilding the information_schema: http://www.postgresql.org/docs/9.1/static/release-9-1-2.html ... Since the view definition is installed by initdb, merely upgrading will not fix the problem. If you need to fix this in an existing installation, you can (as a superuser) drop the information_sche

Re: [ADMIN] re-create information_schema

2012-02-29 Thread Ray Stell
On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote: > http://www.postgresql.org/docs/9.1/static/release-9-1-2.html > This must be repeated in each > database to be fixed. including postgres, template0, and template1? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To mak

Re: [ADMIN] re-create information_schema

2012-03-03 Thread Peter Eisentraut
On ons, 2012-02-29 at 16:25 -0500, Ray Stell wrote: > On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote: > > http://www.postgresql.org/docs/9.1/static/release-9-1-2.html > > This must be repeated in each > > database to be fixed. > > including postgres, template0, and template1? Yes, if y

Re: [ADMIN] re-create information_schema

2012-03-03 Thread Ray Stell
On Sat, Mar 03, 2012 at 08:27:19PM +0200, Peter Eisentraut wrote: > On ons, 2012-02-29 at 16:25 -0500, Ray Stell wrote: > > On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote: > > > http://www.postgresql.org/docs/9.1/static/release-9-1-2.html > > > This must be repeated in each > > > databas