Re: [INTERFACES] template Database

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <rjtalbo(at)attglobal(dot)net>, <pgsql-general(at)postgresql(dot)org>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] template Database
Date: 2002-02-25 20:37:06
Message-ID: 1108.193.237.19.179.1014669426.squirrel@ssl.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

Tom Lane allegedly said:
> "Bob T" <rjtalbo(at)attglobal(dot)net> writes:
>> I notice the error....
>> FATAL 1: Database "template0" is not currently accepting connections
>
>> only when using pgAdmin II not when using psql terminal..
>> The circumstance occurs when you first mouse click the Databases
>> container.=
>> After the container is chosen it then has a plus sign next to it
>> and by clicking on the plus you can see the individual databases.
>> If at any time I click on the primary container (Databases) I will
>> get the
>> above error as pgAdmin II attempts to open all datesbases including
>> templat= e0.
>
> This is evidently a bug in pgAdmin II --- it should ignore pg_database
> entries that are marked not datallowconn.

The CVS code does as of earlier this afternoon. This code was originally
written with 7.0 when (iirc) the datallowconn column didn't exist.

Regards, Dave.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Shellman 2002-02-25 20:49:49 Permissions on file created by COPY TO
Previous Message Doug McNaught 2002-02-25 20:36:38 Re: Backup & Restore

Browse pgsql-interfaces by date

  From Date Subject
Next Message Andreas Kretzer 2002-02-26 12:03:13 Re: pgaccess
Previous Message Arguile 2002-02-25 16:07:29 Re: Starting psql without a database connection