#153 template0 versus template1

closed-fixed
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!

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks