Обсуждение: Re: [GENERAL] template Database

"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.

            regards, tom lane

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.