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.