Re: dropping sequences - Mailing list pgsql-general

From scott.marlowe
Subject Re: dropping sequences
Date
Msg-id Pine.LNX.4.33.0306201113190.10453-100000@css120.ihs.com
Whole thread Raw
In response to Re: dropping sequences  (Erik Price <eprice@ptc.com>)
Responses Re: dropping sequences  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
On Fri, 20 Jun 2003, Erik Price wrote:

>
>
> Doug McNaught wrote:
>
> > Actually, I'm pretty sure it's "template1".  Where in the docs does it
> > say "template0"?
>
> Maybe it is template1.  I have a DB on my system named template0, but I
> might have created that right when I first installed PostgreSQL as an
> experiment and forgot about it.  I also have a template1 database.

Actually, template0 is the "oh dear god, what have I done to template1"
recovery database that the initdb script (now program) creates when run.

template1 is the "hey, if i add a language here, all my new databases get
it too" database.

You generally can't connect to tempalte0, by the way.

Just all FYI.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] psql
Next
From: Csaba Nagy
Date:
Subject: Re: Incremental backups, and backup history