Re: Optional postgres database not so optional in 8.1 - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Optional postgres database not so optional in 8.1
Date
Msg-id 437C9CF2.2040505@commandprompt.com
Whole thread Raw
In response to Optional postgres database not so optional in 8.1  ("John Hansen" <john@geeknet.com.au>)
List pgsql-hackers
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
>   



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optional postgres database not so optional in 8.1
Next
From: Stephen Frost
Date:
Subject: Re: MERGE vs REPLACE