Re: [GENERAL] template Database - Mailing list pgsql-interfaces

From Dave Page
Subject Re: [GENERAL] template Database
Date
Msg-id 1108.193.237.19.179.1014669426.squirrel@ssl.vale-housing.co.uk
Whole thread Raw
In response to Re: [GENERAL] template Database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
Tom Lane allegedly said:
> "Bob T" <rjtalbo@attglobal.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.



pgsql-interfaces by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Starting psql without a database connection
Next
From: Andreas Kretzer
Date:
Subject: Re: pgaccess