From: Ray Stell <stellr@cns.vt.edu>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: re-create information_schema
Date: Sat, 3 Mar 2012 17:28:04 -0500
Message-ID: <20120303222804.GA25365@cns.vt.edu> (raw)
In-Reply-To: <1330799239.11007.7.camel@vanquo.pezone.net>
References: <20120229205513.GA761@cns.vt.edu>
<20120229212501.GB761@cns.vt.edu>
<1330799239.11007.7.camel@vanquo.pezone.net>
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
> > > database to be fixed.
> >
> > including postgres, template0, and template1?
>
> Yes, if you want those databases to be fixed.
A trick with template0, or so it seems:
template1=# select datname, datallowconn from pg_database;
datname | datallowconn
-----------+--------------
template1 | t
template0 | f
postgres | t
rd | t
(4 rows)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu, peter_e@gmx.net
Subject: Re: re-create information_schema
In-Reply-To: <20120303222804.GA25365@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox