Re: Optional postgres database not so optional in 8.1

John Hansen wrote:
> On a fresh installation of postgrsql 8.1    if you drop the
> 'postgres' database,
> psql, createdb, etc. no longer works.
>
> psql -l; ignores -dtemplate1, and createdb doesn't have such an option.
>   
I can't test createdb here but on the psql... what happens if you just:

psql -Upostgres template1?



> Maybe it should fallback to template1 if the postgres database doesn't
> exist?
>
> ... John
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>