> -----Original Message-----
> From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au]
> Sent: 21 June 2005 08:57
> To: Dave Page
> Cc: Robert Treat; Tom Lane; Andrew Dunstan; Andreas Pflug;
> Magnus Hagander; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] [PATCHES] default database creation with initdb
>
> > Yes - that's intentional so that pgAdmin/phpPgAdmin et al. can
> > reasonably expect it to be there.
>
> Problem is, how the hell do I know it's there before I connect?
Well obviously you don't (any more than you know that template1 is
accessible until you try), but in time it will be on more and more
systems as people upgrade by when it will make a reasonable default for
clients.
Alternatively, try to connect to it first, and then fall back to
template1 (much as libpq negotiates protocol versions with the server).
Regards, Dave