Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#153 template0 versus template1

closed-fixed
Oleg Broytman
Postgres (36)
5
2006-02-06
2006-02-01
Anonymous
No

There's a comment in SQLObject from the repository
about what the difference between template0 and
template1 is. It should not specify the template at
all, it should just use the default one when it runs
CREATE DATABASE.

It is also very naughty to create the database from
template0. First, the postgresql 8.1 docs say template0
is called postgres instead. Second, template1 is the
place for database features the user intends to put in
all new databases (for me, it's pl/sql and postgis
geographic types).

Just connect to template1 or don't specify a database
name to connect to and 'CREATE DATABASE db_name'. It
works fine.

Discussion

  • Oleg Broytman
    Oleg Broytman
    2006-02-06

    • assigned_to: nobody --> phd
    • status: open --> closed-fixed
     
  • Oleg Broytman
    Oleg Broytman
    2006-02-06

    Logged In: YES
    user_id=4799

    Fixed at the revision 1575 in the trunk and 1576 in the
    0.7-branch. Thank you!